Maximo Open Forum

Steven Shull posted 01-20-2023 09:42

Have you looked at the where clause being generated by each of the queries to determine how they're different? There's something different between the field on the list tab and the field in the advanced search. For example, the list tab could have a different relationship to the same child object. 

If you're not familiar with how to access the where clause that was generated, on the list tab there's a drop-down arrow near advanced search to view it.

Mitchell Brown posted 01-22-2023 07:29

Thank you for this Steven. I have had look where you told me. I have attached the where clause for both ways.

Gina Leonard posted 01-23-2023 20:01

Hey Mitchell,
Check view manage Queries to make sure someone didn't turn on a default query by accident.  See the screenshot attached!  Hope it's something easy like this!
Thanks
Gina

Danielle Shaw posted 01-26-2023 15:57

It looks like the culprit is the beginning part of the query in your first screenshot: (mxrsource != 'FRC' or mxrsource is null)

The other query does not have that. So I am guessing that field is some other value besides FRC/blank for your WOs.

It could be a default query as suggested or possibly a where clause put in the the XML itself through application designer (see screenshot attached). You can find this dialog by clicking "presentation" so that it's highlighted green, then the "Control Properties" button (2 to the left of the delete node button).