User cannot see the SQL Where Clause edit field in View/Manage Queries Dialog box.
When trying to open the detail of a query to edit the SQL where clause using the Arrow icon, the SQL Clause edit field is not visible, like in the screenshot below.
From Maximo 18.104.22.168 onwards, the SQL query Clause edit field is related to the sigoption "BMXVIEWMANAGEWHER". It means that users cannot see the SQL Where Clause edit field if users do not have access to the "BMXVIEWMANAGEWHER" option.
The "BMXVIEWMANAGEWHER" option is the Sigoption to control the visibility of the Detail section in the View/Manage Queries dialog box.
Resolving the problem
Please follow the steps below in order to fix your issue:
Check if the user has access to the BMXVIEWMANAGEWHER option. Run the SQL query below (change XXX to your userid):
SELECT * FROM APPLICATIONAUTH WHERE GROUPNAME IN ( SELECT GROUPNAME FROM GROUPUSER
WHERE USERID = 'XXX' ) AND OPTIONNAME = 'BMXVIEWMANAGEWHER' AND APP = 'WOTRACK';
If no record is returned, you need to grant access for BMXVIEWMANAGEWHER to XXX user's group.
- Go to the Security Group application.
- Open the Security Group that user XXX belongs to.
- Go to the Applications tab - Work Order Tracking application.
Find the option "Sigoption to control the visibility of the Detail section in View/Manage Queries Dialog" and check the "Grant Access?" checkbox like below.
Save the record. Log back in to Maximo.
You can now see the SQL Where Clause edit field like below.