...
The scope for the portal should be set to User.
The security for the portla portal should be set to User.
Ensure portal status is set to active when ready to use.
Query
Below is the custom SQL included in the query in the portal. This SQL connects the query table to the access and realm tables to filter the results by metadata about the query (folder, archived status), the permissions settings (access), and the realm assigned to the query.
...