How to use the Query Tool to test queries from an Excel Indicator spreadsheet
Jump to navigation
Jump to search
The Query Tool can be used to check the validity of queries that were created outside the Tygron Platform. For example, consider the following query:
SELECT_FLOORSIZE_WHERE_CATEGORY_IS_OFFICES_AND_STAKEHOLDER_IS_MUNICIPALITY_AND_TERRAIN_WITH_ATTRIBUTE_IS_SAFE_ZONE
Although this query appears logical (requesting floor sizes for municipal offices in a safe zone), it will cause an error when uploaded to an Excel Indicator spreadsheet. If the user first attempts to recreate the query in the Tygron Platform Query Tool, he will notice that the clause STAKEHOLDER_IS_MUNICIPALITY is incorrect. The Tygron Platform assigns fixed numbers to stakeholders, in this case a '0'. The correct clause should read STAKEHOLDER_IS_0, and the full Query should be
SELECT_FLOORSIZE_WHERE_CATEGORY_IS_OFFICES_AND_STAKEHOLDER_IS_0_AND_TERRAIN_WITH_ATTRIBUTE_IS_SAFE_ZONE.
How to use the Query Tool to test queries from an Excel Indicator spreadsheet:
- Create a query outside of the Tygron Platform (e.g. on a spreadsheet)
- Load or create a project with the project area in the Editor
- Select Editor → Tools → Query Tool
- Recreate the query from the spreadsheet in the Tygron Platform Query Tool
- Observe if the Query from the tool matches the query created outside the Tygron Platform
- Observe if the output result matches expectations