Section access is not working by connecting MYSQL Qlik Sense
* is working fine when implementing section access by inline table.But I am trying to implement section by connecting with SQL, but i am not getting correct result for * while retrieving data from MYSQL for sectionaccess.
Below is sql table values
Here admin and user009 should see all the data and user123 should see sales_123 part alone, but in my dashboard all users can see only sales_123. '*' is not working here for admin and user009.
upper(SALES_ID) as SALES_ID;
SQL SELECT * FROM MYSQL_DATABASE.TABLE_NAME;
Please help me to achieve * from MYSQL in section access