Remove filter option when the data grid2 is empty

0
I have two columns as Name and STATUS in datagrid2(column vise filter is enabled)  in a page with data source from entity. Status can be two values as ACTIVE and  INACTIVE.   When the normal user logs in data grid will list all the  entries with name and inactive  status. For admin user data grid will list all entries with active and inactive.  Currently i have only 10 active entries in the data base table.   When normal user log in the data grid shows empty, where as filter for column NAME suggest all the entries whose status is ACTIVE.     My requirement is, data grid should not show any suggestion when there is he list is empty.   Cam somebody help?
asked
1 answers
0

Hi Mani, 

 

Datagrid dropdown filetr is mostly based on the data loaded. I would suggest to add a helper entity on the page level and configure it with the same ENUM as an attribute and update the value using a microflow before loading the page. That should do the trick you can still directly use the value from the enum on your Xpath constraint. 

 

Hope this helps! 

 

answered