Predefined Calculation: Northgate M3PP / Assure - Count property assets of type(s) with attribute of value(s)
This calculation will count the number of assets that are of a type specified and have the attribute of a specified value, for a particular property in M3PP / Assure.
The formula requires connection to a Jadu hubIS instance, which can be configured in the Integrations page. Your Jadu hubIS instance should be configured to connect to your M3PP / Assure instance. For help setting up and configuring hubIS, contact Jadu Support.
This formula requires the following inputs to be passed through to it:
- the name of the M3PP / Assure instance as configured in Jadu hubIS
- the UPRN of the property to check
- the asset type(s) to count
- the attribute code
- the accepted value(s) to include
The mapped value for the UPRN must come from an address lookup question, using the property_identifier variable option.
|integer||The number of assets matching one of the specified asset types, that have a matching attribute with one of the accepted values|
|false||If an error occurs|
Note: return values are case sensitive
A check is made to see if the integration has been enabled in the Settings > Integrations page. If the integration is not enabled the formula returns false.
A call is made to GetAssets passing in the UPRN input. This returns all the assets set on a property. If the call fails, the result is false.
A count variable is initialised to 0.
All returned assets are examined to find any with an ASSETTYPE matching the asset type input.
The attributes of any assets with a matching ASSETTYPE are examined, to find any attributes matching the attribute code input.
Any matching attributes are examined, to find any where the value matches one of the accepted value(s) input.
If any attributes with a matching value are found, the count is incremented by 1, and the next asset is examined.
The count is returned as the result once all assets are examined.