topic Re: Section access reduction on one field with date range Historical data in App Development

Section access reduction on one field with date range Historical data

RanOuerg — Thu, 26 Dec 2024 09:58:05 GMT

Hello,

I need to add section access where the reduction is on the Company field. However, I have other conditions:

Group 1: Should have access to company GH when the date is before 2024/12 and should have access to GHM if the date is after 2025/01.
Group 2: Should have access to GH only when the date is after 2025/01.
Group 3: Should have access to all data.

Note that, we have date for both companies for both years 2025 and 2024

What are the best ways to do this ?

Thank you!

Re: Section access reduction on one field with date range Historical data

BrunPierre — Thu, 26 Dec 2024 13:58:01 GMT

Hi, how about a creating a composite of the company and ranges of dates as a linkage between section access and the model.

SECTION ACCESS;
LOAD * INLINE [
ACCESS, USERID, COMPANYYEARKEY
ADMIN, ADMIN, *
USER, GROUP1, GH-PRIORYEAR
USER, GROUP1, GHM-CURRENTYEAR
USER, GROUP2, GH-CURRENTYEAR
USER, GROUP3, *
];

SECTION APPLICATION;

DATA:
LOAD *,
Upper(Company) & '-' & If(Date(MonthStart(Date), 'YYYY/MM') < '2024/12', 'PRIORYEAR', 'CURRENTYEAR') as COMPANYYEARKEY
FROM <SourceTable>;