Please consider registering

sp_LogInOut Log In sp_Registration Sign up

Sign up | Lost password?
Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Error in Advanced Search in WO tracking
Searching in WO hierarchy gives a faulty sql expression
January 15, 2019
10:52 am
Krister Sundborg
Forum Posts: 3
Member Since:
August 9, 2018
sp_UserOfflineSmall Offline

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.

Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

sun kim: 60

madd0g17: 59

v.barsamov: 51

Maximofresher: 44

cgregory: 42

matta0990: 33

Member Stats:

Guest Posters: 0

Members: 13636

Moderators: 0

Admins: 3

Forum Stats:

Groups: 1

Forums: 8

Topics: 1533

Posts: 4202

Newest Members:

sushant naik, Richard Del Rosario, RNLPRSH, Masako N, Julio Hernandez, Salvatore Morisset

Administrators: Chon: 1090, kristensibilia: 0, Joe Grassia: 0