Marvin, Something like this should work: select count(1) from workorder where workorder.jpnum in ('INVEST-LEAK-D','RSPND-GO-D') and exists(select 1 from workorderspec where workorder.wonum = workorderspec.wonum and workorder.siteid = workorderspec.siteid and workorder.classstructureid =...
Hi Everyone, A pleasure being here, I was hoping someone could lend me a hand with the following query, I'm trying to display a number using a KPI through in a startcenter, it deals with "Leak Investigations with no follow up WO's" - I really appreciate your feedback and thank you for such an...
I'm not sure how you are writing your query, but I can defiantly tell you the WOSTATUS table holds all the status's per work order with dates associated with it. Send me a direct message and maybe I can lend you a little more personal help. Thanks
Hi Eric, thank you and great to hear positive feedback on this! Unfortunately, I'm a newbie and thinking maybe I'm missing something in my search terms? When i create a report, i see WOSTATUS but it outputs only the current WO status. Thanks again for any help on this!
Hi BJ, yes both are possible, these sound like a fun reports to create! For tickets I'm showing the TKSTATUS table keeps track of the status history. SR's, which are a view of tickets, use this table. Work orders would use the WOSTATUS table for the same information. I am picturing a report...
Hi, i'd like to see if it's possible to generate a report that shows the time that each of my tickets spent in each status. Or, perhaps if there is a way to generate a historical report that displays the status of tickets at a specified historical point in time. Figuring option 1 is more...
I'll take a guess. . .count() returns an integer; multiplying by .1 implicitly changes it to decimal, and I'm guessing the "plumbing" behind Maximo's KPI Percentage calculation needs decimal datatype values to work.
Contact us with questions or feedback.
Join CommunityInvite ColleaguesLearn MoreGet Started on MORE
About UsTerms of Use