Now I want implement security in such a way that certain rows will only be displayed for a particular user role.
Look into using conditional formatting on your table. Hide the row if the user should not see it.
Filters are more preferable, but unfortunately do not work on secondary data source tables... so you'll need to use conditional formatting.
Hi Greg,
Thanks a lot for that. The conditional formatting is giving options only to hise the whole table. How to hide individual rows or columns in tha ?
Joseph
Contrary to how it sounds... conditional formatting on a repeating table only hides rows, not the whole table. If you want to hide the entire table, you need to place the table into a section and add conditional formatting on that section.