All entities can not see in query designer

Hi @NayayanS ,

It seems that the Entities which listed in the query designer need to have Row Level Security defined in the LU level or in column level.

You can try below sql query (login as sys user)

SELECT LU_NAME, Row_level_security 
FROM ifsapp.dictionary_sys_view_active
WHERE lu_name IN ('TEST_A','TestC')
AND view_type = 'B';

Best Regards,
Tharindu

Once row-level security is defined refresh Materialized view Query_Designer_Entities_MV

Hi ​@Tharindu Sooriyaarachchi 

Do You want to say that all the time I need to check this I must Admin to launch SQL Query? Is this information available on any IFS Cloud page?