How to use the Query Tool to test queries from an Excel Indicator spreadsheet: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(4 intermediate revisions by the same user not shown)
Line 6: Line 6:
:<code>SELECT_FLOORSIZE_WHERE_CATEGORY_IS_OFFICES_AND_STAKEHOLDER_IS_0_AND_TERRAINTYPE_IS_SAFE_ZONE</code>.
:<code>SELECT_FLOORSIZE_WHERE_CATEGORY_IS_OFFICES_AND_STAKEHOLDER_IS_0_AND_TERRAINTYPE_IS_SAFE_ZONE</code>.
<br>
<br>
{{Editor steps|title=use the Query Tool to test queries from an Excel Indicator spreadsheet|Create a query outside of the {{software}} (e.g. on a spreadsheet)|Load or create a project with the project area in the Editor|Select Editor &#8594; Tools &#8594; Query Tool|Recreate the query from the spreadsheet in the {{software}} Query Tool|Observe if the Query from the tool matches the query created outside the {{software}}|Observe if the output result matches expectations}}
{{Editor steps|title=use the Query Tool to test queries from an Excel Indicator spreadsheet
[[Category:TQL]][[Category:How-to's]][[Category:Indicator]]
|Create a query outside of the {{software}} (e.g. on a spreadsheet)
|Load or create a project with the project area in the Editor
|Select [[Editor]] &#8594; [[Tools]] &#8594; [[Query Tool]]
|Recreate the query from the spreadsheet in the {{software}} Query Tool
|Observe if the Query from the tool matches the query created outside the {{software}}
|Observe if the output result matches expectations}}
 
{{article end
|howtos=
* [[How to configure a Query for an Excel Indicator]]
* [[How to implement an Excel Indicator]]
* [[How to make the Green Garden Indicator]]
* [[How to manually adjust Indicators in Excel]]
|seealso=
*[[Query Tool]]
}}
[[Category:TQL]][[Category:How-to's]][[Category:Indicator]][[Category:Panel]]

Latest revision as of 16:23, 30 January 2024

Query error message

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_TERRAINTYPE_IS_SAFE_ZONE

This query seems to look good on paper, the string makes sense: Give the floor size of all municipal offices that are located in the safe zone. However, when uploading the query in a spread sheet for an Excel Indicator, the query will result in an error. 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_TERRAINTYPE_IS_SAFE_ZONE.


How to use the Query Tool to test queries from an Excel Indicator spreadsheet:
  1. Create a query outside of the Tygron Platform (e.g. on a spreadsheet)
  2. Load or create a project with the project area in the Editor
  3. Select Editor → Tools → Query Tool
  4. Recreate the query from the spreadsheet in the Tygron Platform Query Tool
  5. Observe if the Query from the tool matches the query created outside the Tygron Platform
  6. Observe if the output result matches expectations

How-to's

See also

Retrieved from "https://support.tygron.com/w/index.php?title=How_to_use_the_Query_Tool_to_test_queries_from_an_Excel_Indicator_spreadsheet&oldid=58491"