A ClientQuery offers the possibility

• to generate data on the client side or
• to process data records from incoming nodes or
• to connect data from queries with constant iterations.

The ClientQuery is based on an in-memory SQLite database (Version 3.38.5). The data records from the incoming nodes are stored in tables for this purpose.

 

Attributes:

Attribute	Required	Description
Id	Yes	Unique Id in the query tree
DependsOn	No	Optional dependency on on or more query nodes. These are provided with their Id as name as SQLite table.
ConstantIterations	No	Identifier for constant iterations
Parameters	No	Optional "named" SQLite Parameter. Only the variant with the colon is supported.
Statement	Yes	SQLite query
ResultFilters	No	List of result processing

 

Select Syntax as Graph

 

Examples

Example 1 – Date Calculation:

--- !ClientQuery
Id: Dates
Statement: Select
    date('now') as Today,
    date('now', 'start of month', '+1 month', '-1 day') as LastOfMonth

Result:

Today	LastOfMonth
2022-12-22	2022-12-31

 

Example 2 – Parameter:

--- !ClientQuery
Id: Parameter
Parameters:
   Foo: Bar
Statement: Select :Foo as Name

Result:

Name
Bar

 

Beispiel 3 – Fill constant iterations with the current date:

In this example, the test case has 4 variables: Var1, Var2, Var3 and Date.
Var1, Var2 and Var3 are filled using constant iterations. The result column Date is to be filled with the current date.

Data of the existing constant iterations:

Date	Var1	Var2	Var3
2023-12-31	x	xx	xxx
2023-12-31	y	yy	yyy
2023-12-31	z	zz	zzz

 

--- !ClientQuery
Id: Root
ConstantIterations: Iterations
Statement: Select date() as Date, 
                  Var1, Var2, Var3 from Iterations

Ergebnis:

Date	Var1	Var2	Var3
2024-06-04	x	xx	xxx
2024-06-04	y	yy	yyy
2024-06-04	z	zz	zzz

 

For further SQLite features see also: SQLite additional features