Hi Community
I should manage the section Access in my app using a field called: Market.
CASE: Market Field is a LOV of country. Ex. ITALY, GERMANY, SWEDEN, SPAIN, FRANCE...
I have two different kind of pages in my Dashboard, called By Market and All Markets
SCENARIO 1: By Market
users that navigate the app in the By Market Pages are allowed to see only the LOV of Markets rescricted to the section access list.
SCENARIO 2: All Markets
All the users can see the complete LOV of Markets.
The problem is that if I implement the Section Access using such Market field, in the All Markets Pages will be visible only the market restricted by the Section access.
For Example:
UserID: Paolo
Market: Italy
SECTION Access;
USERS:
LOAD
'ADMIN' as ACCESS,
'Paolo' as NTNAME,
'Italy' as Market
FROM [..\..\Data\MOPAR_Executive_Dashboard_users.xlsx] (ooxml, embedded labels, table is User);
SECTION Application;
Question:
Is Possible that User: Paolo can see only Italy in the By Market Pages and in the All Markets pages all the Markets?
NOTE: is not possible to implement 2 different datamodel for the By Market and All Markets pages. Is necessary to use exactly the same field Markets.
Thanks a lot,
regards,
Paolo.