Search

Answer

RE: Work orders won’t come up unless you go to advanced search and click find

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

Answer

RE: Most recent workflow transaction

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...

Answer

RE: Most recent workflow transaction

"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...

Answer

RE: Work orders won’t come up unless you go to advanced search and click find

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

Answer

RE: Most recent workflow transaction

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...

Answer

RE: Most recent workflow transaction

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...

Answer

RE: Work orders won’t come up unless you go to advanced search and click find

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

2 attachments

Question

Most recent workflow transaction

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...

Answer

RE: Work orders won’t come up unless you go to advanced search and click find

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...

Question

Work orders won’t come up unless you go to advanced search and click find

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...