Checking for Inventory records in Lucity with no matching GIS record
This simple filter checks a field in a Lucity Inventory table that is automatically flagged when a GIS record is synced with the Lucity record. It does not actually go and check the geodatabase to make sure the record still exists. The filter used here is specifically for checking sewer pipes but the basic design can be used for any inventory module.
The inventory module that you want to check.
TABLE WHERE (TABLE.%%_INMAP = 0)
SWNET WHERE (SWNET.NT_INMAP = 0)
Example Drill Downs:
SWNET - NT_NUMBER
Note: The NT_INMAP field is the name of the field for the Sewer Pipe module. There is a similarly named field in every inventory module. Update the tablename and field to match the module you are running this filter against.
Please sign in to leave a comment.