In order to resolve the issue for the search options in queries not showing please follow the steps below.
These instructions will require access to the User Profiles and SQL Maintenance programs on the Proclaim toolbar.
If you do not have access to these programs please raise a new case online and reference the title of this article.
Sign in to Proclaim on the client's machine/server.
Open SQL Maintenance.
Click on the Case Type drop-down box and select the correct case type.
On each SQL check what number is listed next to Security Level: and click EXIT.
Open User Profiles and find the user in question.
Select the user profile and click UPDATE.
Change the number listed next to Security Level on the MAIN tab to the security level of the SQL.
Click SAVE then click EXIT.