AnsweredAssumed Answered

Troubles using lsEnd sort variable when list of tickets is very large

Question asked by Gutis Champion on Nov 21, 2018
Latest reply on Jan 3, 2019 by Paul_Coccimiglio

I would like to have default Ticket list sorting  by particular field and for particular role. I try to use lsEnd sort attribute for this purpose, but when list of tickets is very large, It seems that only about 500 top tickets are sorted properly, the other appears at the right positions only if i do the sorting by this field manually.

Any suggestions on this?



if i modify domset it works fine 


DOMSET in_list_web_active_only "zimportance=zimportance.sym, open_date ASC, id DESC, mintime=min(attached_slas.time_to_violation), mintgt=min(target_times.target_time), status=status.sym, priority=priority.sym DESC, ref_num" "" STATIC
WHERE "active=1" ;



But if i try to do this on form level the results are wrong


<PDM_MACRO name=lsEnd isticketfactory=1 sort="zimportance=zimportance.sym ASC">