When we use TQL to get information for us, we have to tell it which bits of information we want. This mandatory part of the query is called the selection. The selection indicates which properties are displayed by the query.
In our query the selection part is s.id, t.e.userInput, t.e2.answerText:
la s.id, t.e.userInput, t.e2.answerText: t.e.userInput != "" limit 30
The query generates a list of entries in which the session ID, user input, and answer text of a single transaction are displayed.
In the query results, each column is given a default name that matches the property queried. So the column with session ID is labelled s.id, just as it appears in the query:
You also have the option of adding more meaningful header labels to your results using the following format:
la s.id as "session ID", t.e.userInput as userInput, t.e2.answerText as "answer text": t.e.userInput != "" limit 30
When adding labels to query selections you can apply multi-word labels in double quotes or a single word without quotes. The advantage when not using quotation marks is that you can refer to the single word label in other parts of the query, for example:
la t.e.userInput as userInput: t.e.userInput != "" order by userInput.
Was this page helpful?