This example demonstrates how to find all sewer pipes not inspected in the last six years.
Open the Television Inspection module and open the Television Inspection filter. Set a filter for Date Televised > [6 years from yesterday].
Click Go. If you have any records, you can create a subset. To check your record count, look in the lower left hand corner of the module .
Click on the Subset Manager button.
Select "New" and enter a subset name
In Lucity GIS, click on the Subset Manager button and select "Inventory Subset". Select "Sewer Pipes" from the Infrastructure Type list and click "Load".
Highlight the subset you created and click "Load".
This selected set shows all pipes that have been inspected in the last six years. Right click on the Sewer Pipes theme and click Selection > Switch Selection.
This selected set shows all pipes that have not been inspected in the last six years.
At this point, you could narrow your selection by selecting Selection > Select from Selection and use the standard ArcGIS select tool to select a small area of the un-inspected pipes.
To create a work order for these selected pipes to be inspected, use the Open Module tool and right click on one of the selected pipes. For information on creating work orders on selected assets see Creating a Work order for a Single or Group of Assets.