List of Contributions

User1971

Contact Details

My Content

1 to 20 of 50+ total
Posted By User1971 Jan 11, 2021 11:31 PM
Found In Egroup: Maximo
\ view thread
Thanks for your help. In the child WO, when I try to select the closed PARENT WO, I can't see it in the list. Any idea how I can select a closed parent WO? Cheers.
Posted By User1971 Jan 11, 2021 10:05 PM
Found In Egroup: Maximo
\ view thread
I can think of a few ways to do this. Option 1 : Use the WOANCESTOR table: 1A) Self-join (WOANCESTOR): select a.wonum, b.ancestor as topancestor, a.hierarchylevels from ( select wonum, max (hierarchylevels) as hierarchylevels from woancestor where siteid = 'SERVICES' group by wonum ...
Posted By User1971 Jan 11, 2021 9:33 PM
Found In Egroup: Maximo
\ view thread
MAM 7.6.1.2: I want to write an SQL query that does the following: Indicates the WO's top ancestor (top work package) Includes the level/order within the group WONUM PARENT CLASSIFICATION TOPANCESTOR (TOPWORKPACKAGE) LEVEL WOHIERARCHY WO55016 ROADS WO55016 ...
Posted By User1971 Jan 11, 2021 9:19 PM
Found In Egroup: Maximo
\ view thread
MAM 7.6.1.2: Is anyone aware of an OOB WORKORDER field that could be used to indicate that a follow-up WO is required? Example: WORKORDER.FOLLOWUPWORKREQ Thank you.
Posted By User1971 Jan 10, 2021 6:00 PM
Found In Egroup: Maximo Anywhere
\ view thread
Any luck?
Posted By User1971 Jan 10, 2021 5:45 PM
Found In Egroup: Maximo
\ view thread
Posted By User1971 Jan 7, 2021 4:21 PM
Found In Egroup: Maximo
\ view thread
I have a parent WO for a winter storm event . The parent WO has been closed. Additionally, there is an emergency tree pruning WO that has also been closed. In hindsight, staff realize that the tree WO should have been a entered as a child of the parent winter storm WO. This is needed for financial reporting ...
Posted By User1971 Jan 5, 2021 7:21 AM
Found In Egroup: Maximo
\ view thread
MAM 7.6.1.2 Tree removal scenario: Tree removal work happens in two steps. 1. Initial WO to remove/cut down the tree 2. 2-3 years later, the stump is removed by a contractor via a follow-up WO For WOs that are classified as TREE REMOVAL, is there a way to do one of the following? A. Automatically generate ...
Posted By User1971 Jan 5, 2021 7:19 AM
Found In Egroup: Maximo Anywhere
\ view thread
I accidentally posted this to the wrong forum. It's not an Anywhere question. Reposted here: https://community.ibm.com/community/user/iot/communities/community-home/digestviewer/viewthread?GroupId=727&MessageKey=dae678d4-98a8-4c83-8a93-d03d247f6066&CommunityKey=3d7261ae-48f7-481d-b675-a40eb4 ...
Posted By User1971 Jan 4, 2021 10:14 PM
Found In Egroup: Maximo Anywhere
\ view thread
MAM 7.6.1.2 Tree removal scenario: Tree removal work happens in two steps. 1. Initial WO to remove/cut down the tree 2. 2-3 years later, the stump is removed by a contractor via a follow-up WO For WOs that are classified as TREE REMOVAL, is there a way to do one of the following? A. Automatically generate ...
Posted By User1971 Dec 31, 2020 2:45 PM
Found In Egroup: Maximo
\ view thread
MAM 7.6.1.2 and Anywhere 7.6.4: In the Change Status window, the Status Date field is editable . I would have thought that field would be read-only (OOB). I can't think of any scenarios where my users would need to manually enter the Status Date. What is the intended use case for editing that field? ...
Posted By User1971 Dec 29, 2020 10:25 AM
Found In Egroup: Maximo
\ view thread
In a recent post , @Andrew Jeffery made a comment about indexes: "Workorder is often the largest table​. I've seen indexes involving a status field being greater than 1GB, that is a lot of disk IO..." On a similar note, when I look at the WORKORDER table, I see that there are 300 columns (including add-ons) ...
Posted By User1971 Dec 29, 2020 9:19 AM
Found In Egroup: Maximo
\ view thread
A related question here: WOs from PM/JP/Route: Multiple issues with auto-populating data (including Job Plan conditions)
Posted By User1971 Dec 29, 2020 9:12 AM
Found In Egroup: Maximo
\ view thread
Do I remember that you experienced a similar issue with Job Plan conditions?
Posted By User1971 Dec 29, 2020 9:12 AM
Found In Egroup: Maximo
\ view thread
MAM 7.6.1.2: I can create WOs using one of two methods: Create new WO from Work Order Tracking Or use a PM/JP/Route to generate parent and child WOs With option 1, I can do the following successfully: a) Use a crossover domain on classification to automatically populate fields in ...
Posted By User1971 Dec 26, 2020 7:00 PM
Found In Egroup: Maximo
\ view thread
For those of us that have purchased the book SQL Performance Explained by Markus Winand , the book can also be downloaded here: http://docshare01.docshare.tips/files/29375/293750304.pdf
Posted By User1971 Dec 23, 2020 1:41 PM
Found In Egroup: Maximo
\ view thread
Thanks. Glad to hear it wasn't just me.
Posted By User1971 Dec 22, 2020 7:20 PM
Found In Egroup: Maximo
\ view thread
When writing SQL queries for reports, etc., it can be easy to make mistakes. What are some techniques that can be used to check for incorrect query results? Compare the total costs: For financial queries: compare the total cost in the query against the total cost in Maximo. My total cost vs. ...
Posted By User1971 Dec 22, 2020 2:12 PM
Found In Egroup: Maximo
\ view thread
Here is the updated query. select nt.wonum, nt.parent, nt.hierarchypath, nt.classstructureid, nt.worktype, nt.status, nt.glaccount, actstart, actfinish, nt.siteid, nvl(nt.actlabcost,0) + nvl(t.t_actlabcost,0) as actlabcost, nvl(nt.actmatcost,0) + nvl(t.t_actmatcost,0) as actmatcost, ...
Posted By User1971 Dec 22, 2020 1:59 PM
Found In Egroup: Maximo
\ view thread
Thanks for you help. When I look at the WORKORDER table, it looks like the act___ columns don't allow nulls. Is that good enough? More info here: Can the WORKORDER actuals columns ever be null? -------------------------------------------