X (TQL) - Revision history

Frank@tygron.nl at 11:55, 8 July 2026

2026-07-08T11:55:19Z

← Older revision		Revision as of 11:55, 8 July 2026
Line 1:		Line 1:
	Instead of specifying a clause parameter with a particular [[Item ID]], it is possible to use the 'X' character for its value. ~~The result of using~~ 'X' for ~~the clause value, is the automatic creation of multiple TQL statements, one with each~~ Item ID ~~for~~ that Clause Parameter ~~that can be found~~ in the project data. ~~Internally, the resulting TQL~~ statements are ~~placed in~~ a ~~single array; Similarly the result will be an~~ array of ~~TQL~~ results.		Instead of specifying a clause parameter with a particular [[Item ID]], it is possible to use the 'X' character for its value. Using 'X' automatically creates a TQL statement for every Item ID associated with that Clause Parameter in the project data. These statements are processed as an array, returning a corresponding array of results.

	==Example==		==Example==
Line 13:		Line 13:
	</pre>		</pre>

	The ~~TQL~~ statement		The statement
	<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_X</pre> is ~~internally replaced with a~~ list ~~of TQL statements, separated by comma's,~~		<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_X</pre> is expanded into the following comma-separated list:
	<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_1, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_4</pre>		<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_1, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_4</pre>
	Its result will be a list of names, separated by comma's, for example:		Its result will be a list of names, separated by comma's, for example:

Frank@tygron.nl: /* Clause Parameters */

2026-07-03T09:18:19Z

Clause Parameters

← Older revision		Revision as of 09:18, 3 July 2026
Line 29:		Line 29:
	*[[XK (TQL)]]		*[[XK (TQL)]]
	*[[ID (TQL)]]		*[[ID (TQL)]]
			\|api=*[[Api session event editor building query]]
	}}		}}


	{{TQL param nav}}		{{TQL param nav}}

Frank@tygron.nl: /* Clause Parameters */

2026-06-08T12:05:33Z

Clause Parameters

← Older revision		Revision as of 12:05, 8 June 2026
Line 28:		Line 28:
	*[[XC (TQL)]]		*[[XC (TQL)]]
	*[[XK (TQL)]]		*[[XK (TQL)]]
			*[[ID (TQL)]]
	}}		}}


	{{TQL param nav}}		{{TQL param nav}}

Frank@tygron.nl at 14:38, 15 May 2026

2026-05-15T14:38:44Z

← Older revision		Revision as of 14:38, 15 May 2026
Line 15:		Line 15:
	The TQL statement		The TQL statement
	<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_X</pre> is internally replaced with a list of TQL statements, separated by comma's,		<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_X</pre> is internally replaced with a list of TQL statements, separated by comma's,
	<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3, ~~SELECT_NAME_WHERE_NEIGHBORHOOD_IS_5~~</pre>		<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_1, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_4</pre>
	Its result will be a list of names, separated by comma's, for example:		Its result will be a list of names, separated by comma's, for example:
	<pre>"~~Mayfair~~", "~~Soho~~", "~~Marylebone~~", "~~Hyde Park~~"</pre>		<pre>"De Manege", "De Lancaster", "De Landstreken", "De Kruidentuin", "Golfresidentie"</pre>

	==Clause Parameters==		==Clause Parameters==

Frank@tygron.nl: /* Example */

2026-05-15T12:38:35Z

Example

@@ Line 2: / Line 2: @@
 ==Example==
 The TQL statement
 <pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_X</pre> is internally replaced with a list of TQL statements, separated by comma's,

Frank@tygron.nl at 12:14, 15 May 2026

2026-05-15T12:14:32Z

← Older revision		Revision as of 12:14, 15 May 2026
Line 13:		Line 13:
	{{article end		{{article end
	\|seealso=		\|seealso=
			*[[Y (TQL)]]
	*[[XA (TQL)]]		*[[XA (TQL)]]
	*[[XC (TQL)]]		*[[XC (TQL)]]
	*[[XK (TQL)]]		*[[XK (TQL)]]
	*[[Y (TQL)]]

	}}		}}

Frank@tygron.nl at 12:12, 15 May 2026

2026-05-15T12:12:25Z

← Older revision		Revision as of 12:12, 15 May 2026
Line 21:		Line 21:


	{{TQL nav}}		{{TQL param nav}}

Frank@tygron.nl at 12:12, 15 May 2026

2026-05-15T12:12:08Z

← Older revision		Revision as of 12:12, 15 May 2026
Line 1:		Line 1:
	Instead of specifying a clause parameter with a particular [[Item ID]], ~~this parameter can also be specific with~~ 'X'. The result of ~~placing an~~ X for ~~a parameter~~, is ~~that a single~~ TQL ~~statement is by mutliple TQL statement~~, one with each Item ID for that Clause Parameter that can be found in the project data. Internally, the resulting TQL statements are placed in a single array ~~and~~ the result will be an array of TQL results.		Instead of specifying a clause parameter with a particular [[Item ID]], it is possible to use the 'X' character for its value. The result of using 'X' for the clause value, is the automatic creation of multiple TQL statements, one with each Item ID for that Clause Parameter that can be found in the project data. Internally, the resulting TQL statements are placed in a single array; Similarly the result will be an array of TQL results.

	~~For example, the~~ TQL statement		==Example==
			The TQL statement
	<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_X</pre> is internally replaced with a list of TQL statements, separated by comma's,		<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_X</pre> is internally replaced with a list of TQL statements, separated by comma's,
	<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_5</pre>		<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_5</pre>

Frank@tygron.nl at 09:24, 15 May 2026

2026-05-15T09:24:45Z

← Older revision		Revision as of 09:24, 15 May 2026
Line 18:		Line 18:

	}}		}}


			{{TQL nav}}

Frank@tygron.nl at 09:24, 15 May 2026

2026-05-15T09:24:15Z

← Older revision		Revision as of 09:24, 15 May 2026
Line 1:		Line 1:
	Instead of specifying a clause parameter with a particular [[Item ID]], this parameter can also be specific with 'X'. The result of placing an X for a parameter, is that a single TQL statement is by mutliple TQL statement, one with each Item ID for that Clause Parameter that can be found in the project data. Internally, the resulting TQL statements are placed in a single array and the result will be an array of TQL results.		Instead of specifying a clause parameter with a particular [[Item ID]], this parameter can also be specific with 'X'. The result of placing an X for a parameter, is that a single TQL statement is by mutliple TQL statement, one with each Item ID for that Clause Parameter that can be found in the project data. Internally, the resulting TQL statements are placed in a single array and the result will be an array of TQL results.

	For example, the statement		For example, the TQL statement
	<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_X</pre> is internally replaced with		<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_X</pre> is internally replaced with a list of TQL statements, separated by comma's,
	<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_5</pre>		<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_5</pre>
	Its result will be an list of ~~name~~, ~~seperated~~ by comma's, for example:		Its result will be a list of names, separated by comma's, for example:
	<pre>"Mayfair", "Soho", "Marylebone", "Hyde Park"</pre>		<pre>"Mayfair", "Soho", "Marylebone", "Hyde Park"</pre>