To apply a filter to an asset table based on information in the carriageway table (such as province or sealed/unsealed network) the following steps should be followed (note that this article outlines how to apply a filter for province – if you want to filter for network type or other information, change “province” for the appropriate field.
Open the filter for the layer you want to filter.
Use the drop down arrow beside the “Add” button.
Select the third option “Add condition on a related item”.
On the next tab that opens up once you select the option, make sure that the option “have” is selected, and then click on Select Table.
In the select table tab that pops up, type carr in the search box, and then select “carriageway sections” in the list that shows up.
Once you’ve selected Carriageway Sections it will automatically return to the Linked Tab where you want to select displacement overlaps option and click apply:
This is why we choose displacement overlaps – the asset has a start RP that overlaps with one of the carriageway sections – it then uses this carriageway section to filter for the data held on the carriageway section (note that the RPs given here are examples and may not match those in the actual database ) – in this case, the example bridge would be assigned to the Morobe province based on its start position:
The select column tab will pop up as usual – here we want to select province (either start typing province in the search bar at the top or scroll through the list to find it):
This will cause the lookup for province to pop-up – select the province(s) or region(s) you want to filter by – you can tick as many as you want – if you’re only after a single province, only select that single province, and then click apply:
This takes you back to the main filter tab – if the auto apply option at the top is ticked, this will have immediately applied your filter, and you can close the tab – otherwise you’ll need to click Apply and then close the tab:
The filter is now applied, and this can be repeated for any table that holds both a road name, and either a location or start and end location against the record.
