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...
"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
Hi Prashant, When ordering the result set like this, I added "order by transdate desc" at the end of the where clause. Doing this is still giving me only the last workflow transactions that had been put in the database, it is not returning the transactions that are currently being created. Im...
Hi Eric, OOB WFTRANSCTION where clause for example when WF is on WO will be - ownertable = 'WORKORDER' and ownerid = :workorderid Now as you can see this clause will return more than 1 value when there is more than 1 WFTRANSACTION happening against a WO and by default Maximo mboset coming from...
Thank you for this Steven. I have had look where you told me. I have attached the where clause for both ways.
2 attachments
HI all, I am trying to get the WFTRANSACTION.TRANSID field and copy it to a field on my work order when the user routes the the workflow. I have configured my workflow to run the "SETVALUE" action while routing to the next assignment. My set value action uses the relationship WFTRANSACTION to...
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...
Hello, we recently come across a problem and was hoping someone may be able to help please we searched for some work orders using the filter fields and then pressed enter but find no records. If we then go to advanced search and click find, it finds all of the work orders. does anyone know why...
Contact us with questions or feedback.
Join CommunityInvite ColleaguesLearn MoreGet Started on MORE
About UsTerms of Use