AnsweredAssumed Answered

I am trying to order an NSQL with the "order by" statement but I do not get results.

Question asked by RnFernandez on Jul 11, 2018
Latest reply on Jul 15, 2018 by nick_darlington

this is my query

 

SELECT @SELECT:DIM:USER_DEF:IMPLIED:HORAS:T.res_id:id@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:HORAS:T.full_name:name_resource@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:HORAS:T.resource_email:resource_email@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:HORAS:T.team_lider:team_lider@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:HORAS:T.team_lider_email:team_lider_email@,
@SELECT:DIM:USER_DEF:IMPLIED:PERIODO:T.fecha:Fecha@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:HORAS:T.activo_n:activo_n@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:HORAS:T.role_full_name:role_full_name@,
@SELECT:METRIC:USER_DEF:IMPLIED:case when T.obsn = 0 then 'ok' else '.ERR' end:Obs@

FROM

( ...
) T

 

where
@FILTER@
ORDER BY team_lider

 

I execute it via xog

I get an order by T.res_id

Outcomes