August 9, 2018
At WO tracking in Advanced Search you are able to search within WO hiearchys (the woancestor table). This would be great for i.e. shutdown planning. But this search seems to give a faulty SQL-expression in the where clause.
What I get is something like:
((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 0 and istask = 0) and (exists (select 1 from maximo.woancestor where ((ancestor = '2725409')) and (wonum=workorder.wonum and ancestor=workorder.wonum and siteid=workorder.siteid)))
The part with "ancestor=workorder.wonum" blocks the resultset and what I get is just one record, which is the top parent wo. But if I edit the where clause and delete this part, then I will get all expected records which have the wo 2725409 as top parent wo.
I think this must be a bug. Does anyone know where I can find the sql-expression for this field for searching in the woancestor table, so I can correct it? It must be written somewhere, where Maximo fetch it, I think.
Most Users Ever Online: 54
Currently Browsing this Page:
sun kim: 59
Guest Posters: 0
Newest Members:Kevin Arhagba, M Bosma, Gilberto Hernandez, Patrik Nilsson, ed oldak, Sarah Mattern
Administrators: Chon: 1090, kristensibilia: 0, Joe Grassia: 0