• Registered: 2020-10-04
  • Posts: 8

Topic: Order by multiple items with ascending and descending order

Hi all,
I'm trying to order table grid by two items (columns) but I'm not sure what is syntax. For example, ORDER BY customers.date_registered - DESCENDING; customers.name ASCENDING.
I'll attach screenshot from my example.

Thanks in advance,

Vladimir

Post's attachments

Attachment icon order by.png 12.75 kb, 86 downloads since 2020-10-04 

amadeus.games's Website

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,675

Re: Order by multiple items with ascending and descending order

Hi,
Try it like this (see attached).
Separate your columns with a comma and specify desc for descending (ascending is the default so is not required).
Derek.

Post's attachments

Attachment icon tablesort.zip 336.52 kb, 205 downloads since 2020-10-04 

  • Registered: 2020-10-04
  • Posts: 8

Re: Order by multiple items with ascending and descending order

Hi my man, this works great. Thanks for help.

Vladimir

amadeus.games's Website