Hi Steve,
Yup, thanks for thinking this through a bit more.
So, if I have a location ADDR2001 and it lives in the GEO and SANITARY systems, neither of which are a primary system.
When the location lookup is used it's only looking at the LOCATIONS object i.e. a single entity with no reference to a system. So, where on earth is the SYSTEMID coming from? We;; nowhere at this point.
Back to the OP, the question was asked about how to display the parent and its description to the Locations lookup. We've got a solution to show a parent, but a location can have multiple, so this cannot be done unless a key change is done in the query used to form the relationship.
You would either need to perhaps hardcode the SYSTEMID into the relationship. Typicall it's the primary system for the site, but that's not going to work for the ADD2001 location. Which just means that at the moment no parent would show.
------------------------------
===============================
Craig Kokay,
Lead Senior Maximo/IoT Consultant
ISW
Sydney, NSW, Australia
Ph: 0411-682-040
=================================
#IBMChampion2022
------------------------------
Original Message:
Sent: Fri June 03, 2022 10:50 AM
From: Steve Hauptman
Subject: Adding Parent Location and Parent Location Description in Select Value dialog box of Location field in Maximo
Hi Craig,
Maybe I am missing something, but I think that will show "a" parent of the location if there are many. I think which one it shows may be somewhat random. But, you made me think, so I did more research. There are actually 2 non-persistent fields - parent and systemid which could be just used with no further needs. The code for those work basically to use the Primary system unless the location is not part of the primary in which case they are set to the first parent/system found. For the parent description, it would then just be a simple relationship to that parent location record.
------------------------------
Steve Hauptman
Original Message:
Sent: Fri June 03, 2022 01:31 AM
From: Craig Kokay
Subject: Adding Parent Location and Parent Location Description in Select Value dialog box of Location field in Maximo
Hi Steve,
I've already replied to this in another post. You don't have to choose, just use the correct relationship which is LOCATION_PARENT_SYS
------------------------------
===============================
Craig Kokay,
Lead Senior Maximo/IoT Consultant
ISW
Sydney, NSW, Australia
Ph: 0411-682-040
=================================
#IBMChampion2022
Original Message:
Sent: Thu June 02, 2022 09:59 AM
From: Steve Hauptman
Subject: Adding Parent Location and Parent Location Description in Select Value dialog box of Location field in Maximo
One other consideration. A location can belong to more than one system and can have a different parent in each of those systems. If you have just one system, then that is fine. If you have multiple systems you will have to decide from which system the parent is shown.
------------------------------
Steve Hauptman
Original Message:
Sent: Thu June 02, 2022 03:59 AM
From: Henrik Christiansen
Subject: Adding Parent Location and Parent Location Description in Select Value dialog box of Location field in Maximo
To expand a bit on changing the XML definitions in general:
Updating Lookups.xml would change it system wide for all applications using the id="locations" lookup.
If you're looking to change it only for a specific application, say WOTRACK, you can copy the XML starting from <table id= and ending with </table> and add that to your application XML file.
When in the WOTRACK application it will use the local definition of the lookup with all your changes, but other applications will use the global from Lookups.xml.
Additionally you can create a custom definition in Lookups.xml and utilize those across multiple applications if you don't want to change it system wide for everyone.
------------------------------
Henrik Christiansen
Original Message:
Sent: Wed June 01, 2022 08:53 PM
From: Manoj Sawant
Subject: Adding Parent Location and Parent Location Description in Select Value dialog box of Location field in Maximo
You can export the lookups.xml from application designer. Go to locations lookup (I think it would be table id="locations") and then add the parent location and parent location description by using tablecol. You may need to create relationship to get parent record. In dataattribute binding you can use relationshipname.attributename to specify attribute fetched using relationship.
------------------------------
Manoj Sawant
Maximo Consultant
Wipro Technologies
Adelaide
Original Message:
Sent: Wed June 01, 2022 10:27 AM
From: mx pro
Subject: Adding Parent Location and Parent Location Description in Select Value dialog box of Location field in Maximo
Hi Guys,
Can someone tell me step by step procedure on how to add Parent Location and Parent Location Description in Select Value dialog box of Location field?
Thanks in Advance
------------------------------
mx pro
ON
------------------------------
#AssetandFacilitiesManagement
#Maximo