Definition Query based on relate

Question

In ArcGIS Pro.  I have a point feature that contains site locations.   They each have a unique LocationID (Maximo Location to be specific)

I have a table that is downloaded from Maximo that contains all the active Project #'s

The projects #'s table contains asset numbers and the device name.  There will be multiple unique asset numbers with the same project #

I want to be able to update Install Date and Status on the Project #'s table.

To that end I have created a relationship of 1 (Site Locations)  to many (Project #'s) based on Location.

When I start an edit session the relationship works and I can edit the fields I need to edit in the Project # table

However, I have 1606 unique sites.  I only have 26 unique location numbers in the Project # table.

I would like to know how I can create a definition query to only show the Site Locations that have a relation

It would work with a Join, but  a join will not show a many

BrianBulla1 · Answer

Hi Robert Borchert‌

Was there ever any resolution to this?  I need to run a definition query on a layer, based on attributes in the related record.  Mine is for Watermain Breaks.  I need to query out all of the breaks (a 1:1 relate to WaterMains), where the Watermain has a LININGINSTALLDATE.

The join (in SDE, versioned) is there and working, but I just can't figure out how to write the Definition Query in ArcPro.

Also, how is your Maximo implementation going?  Did you have to write any custom code to update the MXCREATIONSTATE as you edit your data??

RobertBorchert · Answer

The end result is I have to get it working in Collector for field crews. If it was a matter for in office uses the user could select the table showing selected objects.

I could work around by doing a join first and populating a field in the Sites toggle visibility but the desire is to set up a reconcile back to Maximo with updates on completed work and a new export of Project #'s.  I suppose if there is not a way to do this I will have to opt for a python script to run after the export to field calculate the visibility field

KoryKramer · Answer

I see.  I was thinking about the attribute table itself, not the Attributes Pane.