en EN de DE
topbar test
en EN de DE
Search site...
Wie können wir Ihnen helfen?
< Zurück
Drucken

ClientQuery

Veröffentlicht17. April 2023
Geändert5. June 2024
VonAlexandra Klettenhofer

A ClientQuery offers the possibility

  • to generate data on the client side or
  • to process data records from incoming nodes.

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:

AttributeRequiredDescription
IdYesUnique Id in the query tree
DependsOnNoOptional dependency on on or more query nodes. These are provided with their Id as name as SQLite table.
StatementYesSQLite query
ParametersNoOptional "named" SQLite Parameter. Only the variant with the colon is supported.
ResultFilters NoList 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:

TodayLastOfMonth
2022-12-222022-12-31

 

Example 2 – Parameter:

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

Result:

Name
Bar

 

For further SQLite features see also: SQLite additional features

Tags:
Inhaltsverzeichnis