Post

1 follower Follow
0
Avatar

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.

Selected Module:

The inventory module that you want to check.

Filter:

TABLE WHERE (TABLE.%%_INMAP = 0)

Example Filter:

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.

Jonathan Semones

Please sign in to leave a comment.