X (TQL) - Revision history

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>

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

2026-05-15T09:23:03Z

← Older revision		Revision as of 09:23, 15 May 2026
Line 3:		Line 3:
	For example, the statement		For example, the 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
	<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0~~<br>~~SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2~~<br>~~SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3~~<br>~~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 an list of name, seperated by comma's, for example:
	<pre>"Mayfair", "Soho", "Marylebone", "Hyde Park"</pre>		<pre>"Mayfair", "Soho", "Marylebone", "Hyde Park"</pre>

Frank@tygron.nl: Created page with "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

SELECT_NAME_W..."

2026-05-15T09:22:27Z

Created page with "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 <pre>SELECT_NAME_W..."

New page

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
<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_X</pre> is internally replaced with
<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0<br>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2<br>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3<br>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_5</pre>
Its result will be an list of name, seperated by comma's, for example:
<pre>"Mayfair", "Soho", "Marylebone", "Hyde Park"</pre>

==Clause Parameters==
The X value can be used in the following TQL Clause parameters:

{{article end
|seealso=
*[[XA (TQL)]]
*[[XC (TQL)]]
*[[XK (TQL)]]
*[[Y (TQL)]]

}}