Ir para o conteúdo principal

Aliasing Expressions with AS

em DPQL Reference
Lista de autores
Publicado: 22 de mai. de 2018|Última atualização: 3 de nov. de 2022

Sometimes one of the columns returned in the results of your report will be the result of a complex expression. For example, you might have a report with:

SELECT DPQL_PERCENT(tickets.total_to_first_reply < 3600)
copy

It’s not very readable to show this as the column header:

../_images/without-aliasing.png

You can change how the expression is displayed using AS.

After the expression, use AS 'string', where string is a readable name for the resulting column.

For example,

SELECT DPQL_PERCENT(tickets.total_to_first_reply < 3600) AS 'Percentage within 1 hour'
copy

This results in more readable output on the table:

../_images/with-aliasing.png

The readable name is also used on graphs.

ÚtilNão útil
próxima páginaArchived Status
página anteriorGeneral Expression Format

Por favor, faça login ou registre-se para enviar um comentário.