Query modifiers can modify either the query behavior or and the result format
| Construct | Modifier | DomainValue | Description | ||||
|---|---|---|---|---|---|---|---|
| Query | |||||||
| var | Temporary 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 | string: model name or model-level variable name | ||||||
| Sequence | colon separated attribute list | 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+, timestampdatetime, 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, timestamporder+, datetime, 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, timestamporder+, 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 | |||||
| Distinct | From | string | Dot-delimited path to source container | ||||