2 replies

Order By ability with Gelly

Hi,

I need to allow sorting on a data table that I'm returning. I have offset and limit applied to this Gelly view to be effecient and limit the amount of elements that return for speed purposes.

However, I am wanting to allow my user to sort their data table by a specific column. There are a lot of columns... So I'm hoping I can do a conditional

order by

order by

in my view. Is it possible to have multiple elements to order by and/or have conditional order by values?

For example

     order by
       if ($sortColumn == "customer" && $sortDirection == "ascending") customer.firstName asc, customer.lastName asc
       else if ($sortColumn == "customer" && $sortDirection == "descending") customer.firstName desc, customer.lastName desc
       else if ($sortColumn == "email" && $sortDirection == "ascending") customer.email asc
       else if ($sortColumn == "email" && $sortDirection == "descending") customer.email desc
       else if ($sortColumn == "survey" && $sortDirection == "ascending") survey.title asc
       else if ($sortColumn == "survey" && $sortDirection == "descending") survey.title desc

     order by
       if ($sortColumn == "customer" && $sortDirection == "ascending") customer.firstName asc, customer.lastName asc
       else if ($sortColumn == "customer" && $sortDirection == "descending") customer.firstName desc, customer.lastName desc
       else if ($sortColumn == "email" && $sortDirection == "ascending") customer.email asc
       else if ($sortColumn == "email" && $sortDirection == "descending") customer.email desc
       else if ($sortColumn == "survey" && $sortDirection == "ascending") survey.title asc
       else if ($sortColumn == "survey" && $sortDirection == "descending") survey.title desc

Gadget Developers•5mo ago•

2 replies

webzer33

Order By ability with Gelly

order by

order by

in my view. Is it possible to have multiple elements to order by and/or have conditional order by values?

For example

     order by
       if ($sortColumn == "customer" && $sortDirection == "ascending") customer.firstName asc, customer.lastName asc
       else if ($sortColumn == "customer" && $sortDirection == "descending") customer.firstName desc, customer.lastName desc
       else if ($sortColumn == "email" && $sortDirection == "ascending") customer.email asc
       else if ($sortColumn == "email" && $sortDirection == "descending") customer.email desc
       else if ($sortColumn == "survey" && $sortDirection == "ascending") survey.title asc
       else if ($sortColumn == "survey" && $sortDirection == "descending") survey.title desc

     order by
       if ($sortColumn == "customer" && $sortDirection == "ascending") customer.firstName asc, customer.lastName asc
       else if ($sortColumn == "customer" && $sortDirection == "descending") customer.firstName desc, customer.lastName desc
       else if ($sortColumn == "email" && $sortDirection == "ascending") customer.email asc
       else if ($sortColumn == "email" && $sortDirection == "descending") customer.email desc
       else if ($sortColumn == "survey" && $sortDirection == "ascending") survey.title asc
       else if ($sortColumn == "survey" && $sortDirection == "descending") survey.title desc

Order By ability with Gelly

Similar Threads

Order By ability with Gelly

Similar Threads

Similar Threads

Similar Threads