Record filters

You may want to filter the records that are included in the synchronization process. For example, you might be working with a GIS layer that includes multiple asset types. Each asset type is stored in a separate table in Infor Public Sector, so you would need to filter the GIS data by asset type.

There are two types of record filters that you can define for your GIS mappings. To filter the records coming from the Infor Public Sector database, you can specify a formula in the IPS Record Filter Formula field. This formula uses the Hansen.Core.DBOperativeCollection object to construct an SQL statement that selects the records that you want to work with. For example, this formula will only get addresses on Main Street:

oCondition = new DBOperativeCollection()
oCondition.add(New IDOperativeByCommonID("Property", "Address.StreetName", 
      ComparisonOperator.Equal, "Main"))

To filter the records coming from the GIS, you can enter an SQL WHERE clause in the Record Filter field. For example, to get only addresses on Main Street you might enter STRNAME='Main'.

Note: You can use a simple SQL clause to filter the records coming from the GIS because the GIS data is publicly available. A formula is used to filter the Infor Public Sector data to keep the data secure.

A Validate link appears to the right of both filter fields. Click this link to test your filter. Infor Public Sector will run the formula or SQL statement and indicate how many records it returned.