I'm trying to create a basic app to display sales and marketing data from SQL table, but to only allow access or to filter the data based on the users role.
I've managed to filter by ${security.isInRole('Sales')}, I'd like to automatically filter the data based on role they are in.
User 1 - Sales
User 2 - Marketing
User 3 - Admin
So when user 2 and 3 login it automatically filters the results based on the roles the are in.