Forum Discussion

Arpit_Jain's avatar
Arpit_Jain
Frequent Visitor
3 years ago

ROW LEVEL SECURITY filtering across two table context

Hi All, I’m a beginner at RLS. I’ve several tables out of which two table are of priority for this discussion. I’m providing you a sample for the same- Period Table: Period Type. Period Value. monthly. Jan’22 Monthly. Feb’22 Monthly. Apr’21 Quarterly. JFM’22 Quarterly. AMJ’22 Quarterly. AMJ’21 Sales table: Period. Category. Sales units. Jan’22. Heater. 1000 Feb’22. Fans. 5000 Feb’22. Heaters. 100 Apr’21. Fans. 2000 Apr’21. Heaters. 1100 Jan’22. Purifiers. 500 I would like RLS in such a way that user is able to see the Fans data only for quarterly period while both monthly and quarterly data is available for heaters and in the process completely leaving out purifiers. A quick help is much needed. Regards