Use case : manage user right depending its groups.
For example, you want some admin user to see a specific chart, but basic user not to, on the same report. In a model, you can get the context groups with :
that gives you a string of all the user’s groups ‘18,19,27,600000,2,8’ (Jooma user group ids)
You can use it to check if your user is inside specific group :
SELECT ‘19’ = ANY (string_to_array(:constants_contextVar_groups_ids,','))
You can replace ‘19’ with a query that will give you the required group id (cast it as a text)
Finally, use this model for the conditonnal rendering of a grid item.