Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am providing security with Section access to my application.
While implementing security, we are using excel file as following.
Access | NTNAME | Region Code |
USER | PRDQLIKSVR\EAST | 010101 |
USER | PRDQLIKSVR\WEST | 01* |
USER | PRDQLIKSVR\NORTH | 05* |
USER | PRDQLIKSVR\WEST | 020201 |
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...?
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;