topic Re: Section Access in App Development

Section Access

ritumishra01 — Fri, 15 Nov 2024 21:15:07 GMT

UserData:
LOAD "USER_ID" as SurgLogOPID,
NAME,
"PROV_ID",
"EPIC_EMP_ID",
;
SQL SELECT "USER_ID",
NAME,
"PROV_ID",
"EPIC_EMP_ID"
FROM clarity.dbo."CLARITY_EMP"
;

SurgSup:
LOAD Distinct
SurgCardItemKey,
HAR,
UnknownPanelMarker,
Surgeon AS SURGEON,
SurgLogOPID,
SurgeonID, //prov_id
OrProcedure,
all_proc_as_ordered,
ItemMfg,
ItemType,
SurgeryDate,
AmtUsed,
AmtWasted,
CostPerUnit,
AmtUsed * CostPerUnit as TotCost,
SurgLocation,
SurgFacility,
SurgInRoomDT,
SurgOutRoomDT,
Date#(Interval((SurgOutRoomDT) - (SurgInRoomDT),'m')) as ProcLength,
Interval((SurgOutRoomDT) - (SurgInRoomDT),'m') as zzzProcInterval,
SurgicalService
resident surgload;
//where ApplyMap('UserAccessMap' ,SurgLogOPID,0);
drop tables surgload, surgtransform;

Section Access;
Section_Access:
load
'USER' as ACCESS ,
'DS/'&SurgLogOPID as USERID,
SURGEON as OMIT
Resident SurgSup;

Section Application;
exit script;

Can anyone tell wht is the error in code as i am still seeing Surgeon values. its not working as expected .

Re: Section Access

TcnCunha_M — Tue, 28 Nov 2023 11:17:36 GMT

Kind of work as expected , because there nothing to be filter.

in order to reduce the data an proper way you need to have a field on the table where Qlik can connect between your session access table and data model , so let's just say add a new field and make SurgLogOPID AS USERID it will be reducing the data base by ID and will probably will Omit the data 😄

Re: Section Access

ali_hijazi — Tue, 28 Nov 2023 12:42:12 GMT

under the field OMIT the value has to be SURGEON
you want not to see the field SURGEON at all in the app? or you want to filter in some values of the SURGEON column?
currently you are putting the values of the SURGEON column under OMIT
you need to put (I assume) 'SURGEON' as OMIT

Re: Section Access

ritumishra01 — Thu, 30 Nov 2023 11:52:17 GMT

Hi , Thanks for your response , i am looking out for something where surgeons who logs in to app should not be able to see other surgeon names ,they should be able to see only their names.

Re: Section Access

TcnCunha_M — Thu, 30 Nov 2023 12:51:54 GMT

IN that case you don't need OMIT, OMIT will hide the field , Session access if work correctly should not allow you to see other data with is not assign to you