Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
* 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.
Section Access;
LOAD
ACCESS,
USERID,
upper(SALES_ID) as SALES_ID;
SQL SELECT * FROM MYSQL_DATABASE.TABLE_NAME;
Section application;
Load
SALES_ID,
SALES_NAME,
AMOUNT
from sales_table;
Please help me to achieve * from MYSQL in section access
Hi,
I’ve been struggling with this also.
The * gives access to records is your table, in your case SALAES_123. To give the admin user access to all records, change the access from USER to ADMIN en clear the * in the field SALES_ID.
This works for me.
And of course keep user id values uppercase. But it seems you have that.
I would also clear the * in the SA_SCHEDULAR record, so that the account van read all of the records.
Hope thishelps you out.
Peter.
Hi,
I’ve been struggling with this also.
The * gives access to records is your table, in your case SALAES_123. To give the admin user access to all records, change the access from USER to ADMIN en clear the * in the field SALES_ID.
This works for me.
And of course keep user id values uppercase. But it seems you have that.
I would also clear the * in the SA_SCHEDULAR record, so that the account van read all of the records.
Hope thishelps you out.
Peter.