Esri ArcGIS Enterprise UK Data Loader - Property has field value
- What is it? This calculation will check if a specified field exists or matches the given value for the property identified by the supplied UPRN (or its parent).
Setup
The formula requires Esri ArcGIS Enterprise UK Data Loader integration to be configured. This can be done under Settings > Integrations > Esri ArcGIS Enterprise UK Data Loader.
Inputs
This formula requires 5 inputs to be passed through to it:
| Field | Description |
|---|---|
| UPRN | the UPRN of the property to look up |
| Check Parent | whether or not to return a value from the Parent property (if there is one) |
| Field Name | the name of the field on the property record to compare a value for |
| Field Value | the value of the field on the property record to compare with |
| Accept any value | whether or not to ignore Field Value and return 'true' if the field with the given Field Name exists for the property record |
Return values
| Value | Description |
|---|---|
| true | If the property (or parent property) exists and has the given field value |
| false | If the property (or parent property) does not exist, does not have the given field value, or if there was an error fetching the results |
Formula Logic
-
A check is made to see if the integration has been enabled in the Settings > Integrations page. If the integration is not enabled the logic returns 'false'.
-
The property is fetched from Esri using the supplied UPRN value.
-
If the property has a Parent and the Check Parent option is set to 'Yes', the value of the field with the specified Field Name is fetched for the Parent property.
-
Otherwise, the value of the field with the specified Field Name is fetched for the property identified by UPRN.
-
If Accept any value option is set to 'Yes', 'true' is returned if any value is fetched in the previous step.
-
Otherwise, compare the fetched value to the Field Value and return the result of comprasion 'true' if the two values are equal and 'false' otherwise.
If the property or the Field Name field is not found, 'false' will be returned.