I'll add another version of the query to the one @Sid Ogden gave (which is absolutely correct) with one that uses the EXISTS statement: siteid = 'WODM' and exists(select null from longdescription where ldkey=pm.pmuid and ldownertable='PM' and ldownercol='DESCRIPTION' and ldtext is not null) The...
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...
appdesigner.png
Hi Eric, Make a new relationship and try this where clause (child table=WFTRANSACTION). It will get the WF transaction with the most recent date for the WO. ownertable = 'WORKORDER' and ownerid = :workorderid and transdate=(select max(transdate) from wftransaction z where z.ownertable='WORKORDER...
DESCRIPTION LONGDESCRIPTION is actually an alias for the field, so doesn't work in a query. You can add the long description field to your Advanced Search and query from there, or if you stick with the where clause you would need to look to the LONGDESCRIPTION table. As noted by Sid, the join is...
LONGDESCRIPTION is its own table. Because of this, there is a Maximo relationship established for it on any table that has an attribute with a long description. They are linked by the unique identifier of the record in the table (for PM this is pmuid) to the LDKEY on LONGDESCRIPTION. Try this in...
Hello, I'm trying to write a query to retrieve all PM records that have the long description, but the system says my syntax is incorrect. These long descriptions come from the users inputting directly onto PM records, not from the associated job plan. I'm using the 7606 version. The table and...
"order by transdate desc" will just reverse the order of values in the set but it is not going to filter and return only 1 latest value. Use max(), row number(), etc. functions depending upon the database that you are using with Maximo to write a query that gives you the latest record. Eg- If I...
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
Screenshot 2023-01-23 190040.jpg
Contact us with questions or feedback.
Join CommunityInvite ColleaguesLearn MoreGet Started on MORE
About UsTerms of Use