TQL Query Modifiers

Query modifiers can modify the query behavior and the result format

Construct	Modifier	Value	Description
Query
	var	string: 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 namespaces 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, $name	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
	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+, 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+, 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, 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	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

DeleteAll			follows the same syntax as Find; all found instances are deleted;
	using	same as in Find
	as	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
	From	string	Dot-delimited path to source container

TQL Docs

TQL Query Modifiers

Related pages