Search results

Jump to navigation Jump to search

Page title matches

  • ID query (Excel)
    [[File:ExcelIDs.jpg|framed|right|The <code>ID</code> in the query will be replaced with the specific AREA the file is applied to, and thus th ...es|Zoning permit calculation]]. In these situations, you may likely want a query which refers to whatever element the Excel is applied to.
    1 KB (247 words) - 15:25, 3 March 2021

Page text matches

  • ID query (Excel)
    [[File:ExcelIDs.jpg|framed|right|The <code>ID</code> in the query will be replaced with the specific AREA the file is applied to, and thus th ...es|Zoning permit calculation]]. In these situations, you may likely want a query which refers to whatever element the Excel is applied to.
    1 KB (247 words) - 15:25, 3 March 2021
  • How to find the ID of specific data in your project
    ...in a project. In these cases it is neccesary to be able to determine the [[ID]] of data to either connect the right functionalities or relate the right o ...m one of the menus in the [[Current Situation]] tab or making use of the [[Query tool]].'''
    1 KB (215 words) - 14:58, 30 January 2024
  • ID
    ID stands for Identifier, and is a property through which data can be uniquely ...allow referring to data unambiguously, all data in a Project has a unique ID.
    2 KB (331 words) - 11:15, 5 October 2022
  • Select id (TQL)
    ...TQL|tabletype=row|attribute=ID|unit=Item ID|description=Returns the unique ID of an [[Item]] as an Integer|fixed=No|polygon=false|}}</onlyinclude> ...is particular useful when applying [[Template Panel]]s to obtain the Item ID of an [[item]] a particular [[Panel]] is related to.
    1 KB (143 words) - 14:40, 28 February 2023
  • Grid (TQL Param)
    ...|attribute=GRID|type=Item ID|description=[[Grid]] of [[Grid Overlay]] with ID|polygon=false|}} ...arameter requires that you know the grid's ItemID. If you want to create a query that is used in multiple projects, you can also opt for [[Grid with attribu
    588 bytes (85 words) - 14:32, 28 February 2023
  • Version 2021.8.7
    * Added X-Query for existing (pre testrun) buildings. * Limited X-Query to 64K rows and Y-Query to 16K columns.
    984 bytes (136 words) - 12:46, 5 February 2021
  • Select (TQL)
    ...of a [[project]]. By adding various clauses to a selection statement, the query can be made more specific. ===Composition of a Select Query===
    2 KB (367 words) - 06:57, 22 December 2023
  • How to edit Global properties
    ...at are created in the project. The global's Name is the name of the Global ID which is used in queries.'' ...made visual in the project, instead of the Name that is used as the global ID. This is the case when for example, a point is set in the 3D Visualization,
    2 KB (433 words) - 13:30, 30 January 2023
  • Version 2018.3.0
    * New query clause for measures: to get their name, id and state.
    660 bytes (97 words) - 14:28, 22 May 2018
  • X query (Excel)
    [[File:Xquery.jpg|thumb|right|x150px|Example of what will happen with an X query with 3 neighborhoods.]] ...stating each individual [[Neighborhood]] for which to retrieve data, an X query can be used to indicate that, across multiple rows, the data of all [[Neigh
    14 KB (2,391 words) - 09:59, 1 March 2023
  • How to configure a Template Panel
    ...resulting [[Panel]]. Excel [[Template Panel]]s can use [[ID query (Excel)|ID queries]] to make use of properties of the related [[Item]] in the related
    2 KB (261 words) - 13:33, 30 January 2024
  • Version 2020.3.0
    ...ws users to define an overlay based on a specific attribute instead of the ID.
    913 bytes (140 words) - 18:46, 6 December 2019
  • Global
    ...than for a specific component. The name of the global is also the global [[ID]] that can be used in queries. By using a <code>SELECT_GLOBAL_WHERE_NAME_IS_GLOBALID</code> query you can obtain the value of a global. This global's value can then be used
    3 KB (506 words) - 10:22, 1 March 2023
  • Tygron Query Language
    ...lauses provide a means to filter the data the interaction is applied to. A query always consists of exactly 1 statement and 0 or more clauses. Each clause a ...d [[grid overlay|grid]]s. Depending on what kind of statement is used, the query will interact with its clauses treating them as items or as polygons.
    7 KB (1,098 words) - 16:41, 1 February 2024
  • Version 2021.8.4
    * Added support for Y Query, allowing TQL labels in excels to go both per row and column. * All Items (e.g. buildings, areas) now have their ID visible in the Editor Interface.
    1 KB (152 words) - 13:37, 22 January 2021
  • Version 2020.5.5
    * BAG Buildings have a IDENTIFICATION attribute linking to the BAG id. * Fixed BBOX query issue where not all buildings are loaded from BAG.
    1 KB (160 words) - 16:18, 7 February 2020
  • Water stress (Indicator)
    ...indicator approximates the built area of a neighborhood using the [[Tygron Query Language#Construction polygons|LOTSIZE]] function. Then, it measures the pa ...verlay]], its [[ID]] can be retrieved through the [[Query Tool]] using the query sequence SELECT_ID_WHERE_OVERLAY_IS_<Rainfall>.
    5 KB (837 words) - 10:36, 3 February 2023
  • Update building attribute (TQL)
    ...vided values for a specific [[Building]] or all buildings intersecting the query polygons|fixed=No|polygon=true|}}</onlyinclude> ...r neighborhood. (In this example, the [[neighborhood]] in question has the ID 1.)
    2 KB (283 words) - 14:36, 17 February 2023
  • Indicator
    ...sheet is also able to obtain information from a project using [[TQL|Tygron Query Language (TQL)]] statements. For more in depth information on indicator exc * Stakeholder id: <code>SELECT_ID_WHERE_INDICATOR_IS_17_AND_RELATION_IS_OWNER</code>
    7 KB (1,086 words) - 09:19, 12 February 2024
  • Trigger
    ...cutes, it sends a web request to a specified url. The web request includes query parameters which the receiving server can use to interact with the requesti The following query parameters are relevant:
    5 KB (681 words) - 10:48, 19 December 2023
  • TQL tutorial
    ...sult can be output as well, which will be useful in demonstrating specific query structures. ...s", which can be interpreted as questions asked of the [[Project]]. Such a query is composed of a statement, which embodies the requested information, and a
    24 KB (3,705 words) - 09:17, 20 March 2024
  • Panels (template panels) tutorial
    ==ID-queries== ...TQL called an “ID” query. A specific [[ID]] in a query can be replaced by “ID” to mean as much as “(of) the item concerned”. The following will dem
    14 KB (2,291 words) - 10:52, 3 March 2023
  • Excel
    ...e sheet, as well as contain some project-specific adjustments when "X" or "ID" queries were used. For this reason, we advise not to re-upload Excel files ===ID queries===
    15 KB (2,518 words) - 16:41, 21 February 2023
  • Template Panel
    ...e [[Panel]]s refer to same [[Excel]]. Using [[Tag]]s or [[ID query (Excel)|ID queries]], the content of the panel can include data of the specific relate * [[ID query (Excel)]]
    10 KB (1,655 words) - 12:13, 23 February 2023
  • Troubleshooting calculation performance
    ...le query can lead to hundreds of queries, if there are hundreds of valid [[ID]]s. Depending on how many X-queries are added to a single excel sheet, it's
    12 KB (1,926 words) - 10:34, 1 March 2023
  • HTML
    ...form that allows an end-user to change the value of a [[Global]] with an [[ID]] of 0, to some value which the end-user can set. ...d 1. This is because the "global_set_value" requires 2 pieces of data: the ID of the global to modify, and the value to set the global to.
    21 KB (3,733 words) - 08:43, 10 January 2024
  • Indicators Tutorial
    ...] statements, i.e. statements which reference specific [[Item]]s, with one query per [[Item]]. However, for the sake of flexibility and scalability, for [[E In the editor, open the [[Query tool]].
    23 KB (3,856 words) - 07:46, 19 April 2024
  • API tutorial
    * Notice the response. The response is the newly created area's ID. ** The ID returned by the ADD event, to indicate the area you wish to modify
    42 KB (6,394 words) - 15:55, 2 March 2023
  • Data preparation
    ...set with measurement locations and values. A name could be for example the id of the measurements. However more informative would be to have the location File:Measurements_name1.JPG|ID of the measurement as name
    9 KB (1,569 words) - 11:19, 2 November 2022
  • Geo Plugin
    ; Layer id ; Id attribute
    9 KB (1,602 words) - 07:25, 7 December 2023
  • Version 2018.1.0
    * Included a new TQL statement XA that allows users to select Items in de TQL query based on an attribute. ( e.g. SELECT_ID_WHERE_AREA_IS_X would show all Area * Option to load specific Items with the X-query: use XA to select only Items with a specific attribute and add SORT to sort
    17 KB (2,705 words) - 07:13, 14 June 2019
  • Web interface tutorial
    ...o the panel to make the relevant element visible. The element has both the id and class "custom", and is styled by its class with "display:none". Change ...and the stakeholder's web token. The session token is equal to the session id, and is unique for each concurrently running session. The webtoken is a pro
    30 KB (4,886 words) - 09:53, 1 March 2023
Retrieved from "https://support.tygron.com/wiki/Special:Search"