Query modifiers can modify either the query behavior or and the result format
Construct | Modifier | DomainValue | Description | |||||
---|---|---|---|---|---|---|---|---|
Query | ||||||||
var | Store name for the result containerstring: comma-separated list of prefixes | Declares custom variable prefixes | ||||||
Documentation | string | Description of the query | ||||||
Storage | string or structure | Definition or simple name of TQL storage (DB name and connection parameters) | ||||||
Find | ||||||||
using | string or structure | List of namespace hintnamespaces hint or additional type/model definitions | ||||||
as | string in the form Nr:Nrs[:Ni] where Nx can be a dot-separated QName or one of $none, $Sid$sid, $Name$name | Updates Defines the container hierarchy of the result set | ||||||
format | string: comma-separated list of version, current , timestamp, qname, fname, order, order+, datetime, meta, all | shows additional meta-data associated with each attribute | ||||||
Only | string | List of attributes to fetch. Comma-separated list of attribute names with optional predicates | ||||||
Distinct | Sequence | colon separated attribute liststring: model name or model-level variable name | ||||||
nested | string "*" | expand all references to unlimited depth | ||||||
orderBy | string: list of qualified attribute names | |||||||
From | string | Dot-delimited path to source container | ||||||
Create | ||||||||
format | string: comma-separated list of version, current, timestamp, qname, fname, order, order ,timestamp+, datetime, meta, all | shows additional meta-data associated with each attribute | ||||||
As | same as in find except only two first parts are used | |||||||
Only | same as in find; creates only given attributes, ignores the rest | List of attributes to store | ||||||
nested | string "*" recursively split given structure by defined references and replaces content with reference value | |||||||
Save | ||||||||
format | string: comma-separated list of version, current, timestamp, qname, fname, order, order+, timestampdatetime, meta, all | shows additional meta-data associated with each attribute | ||||||
As | same as in find except only two first parts are used | |||||||
Only | ssame as in find; creates only given attributes, ignores the rest | List of attributes to store | ||||||
nested"*" | same as in Create | |||||||
Update | ||||||||
format | string: comma-separated list of version, current, timestamp, qname, fname, order ,timestamp, order+, datetime, meta, all | shows additional meta-data associated with each attribute | ||||||
As | same as in find except only two first parts are used | |||||||
Only | same as in find; updates only given attributes, ignores the rest | List of attributes to update | ||||||
From | same as in Find/Create | Dot-delimited path to source container | ||||||
Delete | ||||||||
using | ||||||||
as $none, ContainerName | same as in find except only two first parts are used | Updates the container hierarchy of the result set | ||||||
format | string: comma-separated list of version, current , timestamp, qname, fname, order, order+, datetime, meta, all | shows additional meta-data associated with each attribute | ||||||
Only | same as in find; deletes only given attributes, ignores the rest | List of attributes to delete | Distinct | |||||
DeleteAll | follows the same syntax as Find; all found instances are deleted; | |||||||
using | same as in Find | |||||||
as $none, ContainerName | same as in find except only two first parts are used | Updates the container hierarchy of the result set | ||||||
format | string: comma-separated list of version, current , timestamp, qname, fname, order, order+, datetime, meta, all | shows additional meta-data associated with each attribute | ||||||
Only | same as in find; delete only given attributes, ignores the rest | List of attributes to delete | ||||||
DistinctFrom | string | Dot-delimited path to source container | ||||||