Maximo Open Forum

I am creating a new dashboard and adding work queues.  I have added a few from wotrack and  1 from purchase requisitions and was adding from purchase orders when i received this error message.  I checked all of the objects structures and security but still keep getting this message.  I didn't see this error until i added the purchase orders and now none of my work views are visible can someone please assist. Below is a screen shot of my error. 

You can check the server logs to get the exact error, but I would assume the saved query has an order by in it which is leading to the REST API error. At a high level, when the query has an order by and the REST API tries to provide an order by, it leads to a query like below (replacing querycolumns with the columns in the saved query and restcolumns with the order by provided by the REST API query parameters):

order by querycolumns order by restcolumns

The REST API doesn't replace the order by from the saved query and just adds to it which leads to an invalid SQL query. If you want to use the query in the Operational Dashboard you unfortunately need to remove the order by in the query.