Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
madhubabum
Creator
Creator

Security issue using Section Access .

Hi All,

I am providing security with Section access to my application.

While implementing security, we are using excel file as following.

   

AccessNTNAMERegion Code
USERPRDQLIKSVR\EAST010101
USERPRDQLIKSVR\WEST01*
USERPRDQLIKSVR\NORTH05*
USERPRDQLIKSVR\WEST020201

In My section access file, i want read * (because i am also having sub region codes for WEST,NORTH)

Remaining working perfectly, But i want to read sub region codes also while implementing security(With EXCEL).

Note : If i am having 010101,010102,010103,0101..............99.Having like this.

If I logged into WEST , i want to show all the region codes(From 010101 to 010199)

How we can achieve this...?

1 Reply
Anil_Babu_Samineni

With in the Field row values it consider as Cell not the Wildcard match. can you try this way?

Section Access;

Load Access, NTNAME, If(WildMatch([Region Code], '01*', '05*'), [Region Code]) as [Region Code] Inline [

Access,    NTNAME,    Region Code

USER,    PRDQLIKSVR\EAST,    010101

USER,    PRDQLIKSVR\WEST,    01*

USER,    PRDQLIKSVR\NORTH,    05*

USER,    PRDQLIKSVR\WEST,    020201

];

Security Application;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful