Record filters
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, enter an SQL statement in the Record Filter field. You can use a simple SQL statement in this case because the GIS data is publicly available. A formula is used to filter the Infor Public Sector data because of security concerns.
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.