Meta-parameter

Independent of the TQL query we want to run, we may want to tell TQL to present the data in a certain way or to run a limited form of the query, e.g. to test it before putting it into operation. This is where meta-parameters come in. Meta-parameters are optional instructions that you can add to your query. They generally affect the behavior of TQL, rather than operating directly on the data.

In our query the meta-paramter is limit 30, telling TQL to only show 30 results:

la s.id, t.e.userInput, t.e2.answerText:  t.e.userInput != "" limit 30

limit a query to 30 results

The three meta-parameters available in TQL are:

Meta-parameter name Description
order by Sort results by a certain property or variable, either ascending or descending
limit Limit the query to n results (to save processing time, if you don't need to see all the results)
sample Show a sample of results (to save processing time, also when first testing your queries, to confirm that it does get results)

Meta parameters are added to the end of valid TQL query with no separator (comma). An exception is the meta-parameter sample which is placed at the beginning of the query.

Was this page helpful?