TQL - Revision history

Rudolf@tygron.nl: Replaced content with "#REDIRECT Tygron Query Language"

2018-08-20T09:23:56Z

Replaced content with "#REDIRECT Tygron Query Language"

Daniel2@tygron.com at 09:15, 30 July 2018

2018-07-30T09:15:24Z

← Older revision		Revision as of 09:15, 30 July 2018
Line 173:		Line 173:
	\|-		\|-
	\| <code>TERRAINMULT</code>		\| <code>TERRAINMULT</code>
	\| Multiply the resulting surface area with the appropriate [[~~Land~~\|Land values]]		\| Multiply the resulting surface area with the appropriate [[terrain\|Land values]]
	\| Land value		\| Land value
	\| <code>TERRAINMULT_IS_GREEN_FACTOR</code>		\| <code>TERRAINMULT_IS_GREEN_FACTOR</code>

Daniel2@tygron.com at 09:14, 30 July 2018

2018-07-30T09:14:35Z

← Older revision		Revision as of 09:14, 30 July 2018
Line 168:		Line 168:
	\|-		\|-
	\| <code>TERRAIN</code>		\| <code>TERRAIN</code>
	\| The underlying surface is a specific [[~~Land~~\|Type of Land]]		\| The underlying surface is a specific [[terrain\|Type of Land]]
	\| Land Type		\| Land Type
	\| <code>TERRAIN_IS_BEACH</code>		\| <code>TERRAIN_IS_BEACH</code>

Rudolf@tygron.com: Redirected page to Tygron Query Language

2017-08-07T14:33:27Z

Redirected page to Tygron Query Language

← Older revision		Revision as of 14:33, 7 August 2017
Line 1:		Line 1:
			#REDIRECT [[Tygron Query Language]]

	{{learned\|file=TQL-Logo-v2-Q3-2015.jpg\|what the Tygron Query Language (TQL) is\|how to create TQL queries\|what type of queries you can create\|what TQL is currently used for}}		{{learned\|file=TQL-Logo-v2-Q3-2015.jpg\|what the Tygron Query Language (TQL) is\|how to create TQL queries\|what type of queries you can create\|what TQL is currently used for}}

Rudolf@tygron.com: /* Clauses */

2016-08-16T13:23:58Z

Clauses

← Older revision		Revision as of 13:23, 16 August 2016
Line 172:		Line 172:
	\| <code>TERRAINMULT</code>		\| <code>TERRAINMULT</code>
	\| Multiply the resulting surface area with the appropriate [[Land\|Land values]]		\| Multiply the resulting surface area with the appropriate [[Land\|Land values]]
	\| ~~Terrain Type~~		\| Land value
	\| <code>TERRAINMULT_IS_GREEN_FACTOR</code>		\| <code>TERRAINMULT_IS_GREEN_FACTOR</code>
	\|-		\|-

Rudolf@tygron.com at 13:22, 16 August 2016

2016-08-16T13:22:55Z

← Older revision		Revision as of 13:22, 16 August 2016
Line 166:		Line 166:
	\|-		\|-
	\| <code>TERRAIN</code>		\| <code>TERRAIN</code>
	\| ~~Surface area lies (partly) within~~ a specific [[~~Terrains~~\|~~Terrain~~]]		\| The underlying surface is a specific [[Land\|Type of Land]]
	\| ~~Terrain ID~~		\| Land Type
	\| <code>~~TERRAIN_IS_1~~</code>		\| <code>TERRAIN_IS_BEACH</code>
	\|-		\|-
	\| <code>~~TERRAINTYPE~~</code>		\| <code>TERRAINMULT</code>
	\| ~~Surface~~ area ~~lies (partly) within terrains~~ with ~~a specific~~ [[~~Terrains#Terrain_Type~~ \| ~~Type of Terrain~~]]		\| Multiply the resulting surface area with the appropriate [[Land\|Land values]]
	\| Terrain Type		\| Terrain Type
	\| <code>~~TERRAINTYPE_IS_SAFE_ZONE~~</code>		\| <code>TERRAINMULT_IS_GREEN_FACTOR</code>
	\|-		\|-
	\| <code>ZONE</code>		\| <code>ZONE</code>

Hansje@tygron.com at 08:47, 3 August 2016

2016-08-03T08:47:43Z

← Older revision		Revision as of 08:47, 3 August 2016
Line 8:		Line 8:

	Queries in TQL using the <code>SELECT</code> statement allow the user to describe the desired data, leaving the Tygron Engine responsible for planning, optimizing, and performing the physical operations necessary to produce the desired result as output.		Queries in TQL using the <code>SELECT</code> statement allow the user to describe the desired data, leaving the Tygron Engine responsible for planning, optimizing, and performing the physical operations necessary to produce the desired result as output.
	Queries using the <code>UPDATE</code> statement are used ~~for~~ calculations in [[Excel\|Excel]]. ~~The outcome of the calculations are used to change the data~~ of the project in the Tygron Engine.		Queries using the <code>UPDATE</code> statement are used together with calculations in [[Excel\|Excel]]. Data of the project in the Tygron Engine can be changed based on the outcome of those calculations using an <code>UPDATE</code> statement.

	When starting a query with the <code>SELECT</code> statement, a result parameter must follow after the <code>SELECT</code> keyword. Currently, one of the following result parameters can be selected:		When starting a query with the <code>SELECT</code> statement, a result parameter must follow after the <code>SELECT</code> keyword. Currently, one of the following result parameters can be selected:

Hansje@tygron.com: /* Queries */

2016-08-02T08:59:04Z

Queries

← Older revision		Revision as of 08:59, 2 August 2016
Line 5:		Line 5:

	==Queries==		==Queries==
	The main operation used in TQL is the query, which is performed with the declarative <code>SELECT</code> statement or <code>UPDATE</code> statement. A '''declarative''' statement tells the system which data is specifically required, after which the system will retrieve the data on it's 'own'. This is contrary to an '''imperative''' statement, where the system is told 'how' to obtain said data. A <code>SELECT</code> statement retrieves data from a running Tygron project session. An <code>UPDATE</code> statement changes data of a running Tygron project session. Queries using <code>SELECT</code> statements have no persistent effect on the project session itself~~. Queries using the <code>UPDATE</code> statement are used for calculations in [[Excel\|Excel]]. The outcome of the calculations are used to change the data of the project in the Tygron Engine~~.		The main operation used in TQL is the query, which is performed with the declarative <code>SELECT</code> statement or <code>UPDATE</code> statement. A '''declarative''' statement tells the system which data is specifically required, after which the system will retrieve the data on it's 'own'. This is contrary to an '''imperative''' statement, where the system is told 'how' to obtain said data. A <code>SELECT</code> statement retrieves data from a running Tygron project session. An <code>UPDATE</code> statement changes data of a running Tygron project session. Queries using <code>SELECT</code> statements have no persistent effect on the project session itself.

	Queries in TQL using the <code>SELECT</code> statement allow the user to describe the desired data, leaving the Tygron Engine responsible for planning, optimizing, and performing the physical operations necessary to produce the desired result as output.		Queries in TQL using the <code>SELECT</code> statement allow the user to describe the desired data, leaving the Tygron Engine responsible for planning, optimizing, and performing the physical operations necessary to produce the desired result as output.
	Queries using the <code>UPDATE</code> statement ~~allow~~ the ~~user~~ to ~~make use~~ of the ~~results of Excel calculations as an output~~ in the Engine ~~and in this way adapt the data in a project session~~.		Queries using the <code>UPDATE</code> statement are used for calculations in [[Excel\|Excel]]. The outcome of the calculations are used to change the data of the project in the Tygron Engine.

	When starting a query with the <code>SELECT</code> statement, a result parameter must follow after the <code>SELECT</code> keyword. Currently, one of the following result parameters can be selected:		When starting a query with the <code>SELECT</code> statement, a result parameter must follow after the <code>SELECT</code> keyword. Currently, one of the following result parameters can be selected:

Hansje@tygron.com: /* Queries */

2016-08-02T08:40:06Z

Queries

← Older revision		Revision as of 08:40, 2 August 2016
Line 5:		Line 5:

	==Queries==		==Queries==
	The main operation used in TQL is the query, which is performed with the declarative <code>SELECT</code> statement or <code>UPDATE</code> statement. A '''declarative''' statement tells the system which data is specifically required, after which the system will retrieve the data on it's 'own'. This is contrary to an '''imperative''' statement, where the system is told 'how' to obtain said data. A <code>SELECT</code> statement retrieves data from a running Tygron project session. An <code>UPDATE</code> statement changes data of a running Tygron project session. Queries using <code>SELECT</code> statements have no persistent effect on the project session itself. Queries using the <code>UPDATE</code> statement ~~do have an effect om the project session itself. The <code>UPDATE</code> statement is~~ used in ~~the~~ Excel ~~indicator calculations and the~~ outcome of the ~~calculation is redirected as output~~ to ~~update~~ the ~~key figures~~ in the ~~project~~.		The main operation used in TQL is the query, which is performed with the declarative <code>SELECT</code> statement or <code>UPDATE</code> statement. A '''declarative''' statement tells the system which data is specifically required, after which the system will retrieve the data on it's 'own'. This is contrary to an '''imperative''' statement, where the system is told 'how' to obtain said data. A <code>SELECT</code> statement retrieves data from a running Tygron project session. An <code>UPDATE</code> statement changes data of a running Tygron project session. Queries using <code>SELECT</code> statements have no persistent effect on the project session itself. Queries using the <code>UPDATE</code> statement are used for calculations in [[Excel\|Excel]]. The outcome of the calculations are used to change the data of the project in the Tygron Engine.

	Queries in TQL using the <code>SELECT</code> statement allow the user to describe the desired data, leaving the Tygron Engine responsible for planning, optimizing, and performing the physical operations necessary to produce the desired result as output.		Queries in TQL using the <code>SELECT</code> statement allow the user to describe the desired data, leaving the Tygron Engine responsible for planning, optimizing, and performing the physical operations necessary to produce the desired result as output.

Hansje@tygron.com: /* TQL Uses */

2016-08-02T08:29:34Z

TQL Uses

← Older revision		Revision as of 08:29, 2 August 2016
Line 336:		Line 336:

	==TQL Uses==		==TQL Uses==
	TQL is currently used ~~to communicate with~~ a (custom) Microsoft [[Excel\|Excel]] spreadsheet.		TQL is currently used for communication between a (custom) Microsoft [[Excel\|Excel]] spreadsheet and the Tygron Engine.