nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Geting work order # from ticket #

Stry

Hi All,

I'm trying to write a report query based on the SR view in Maximo. I need to add the work order number that the ticket number belongs to, to the report. I know the SR view is based to the ticket table but I can't seem to find the relationships between the tables to be able to get the WONUM. Can some one tell me how?

Thanks a ton

Find more posts tagged with

Comments

wwilliams

select * from workorder where workorderid in (select relatedreckey from relatedrecord where relatedrecclass = 'SR' )