Page 1 of 1

Column sort shows empty information first

PostPosted: Tue Nov 27, 2018 2:20 am
by joe26
Hi guys!

Sorting a column header shows empty information first.

I use Query Builder to build composite tables. Clicking on the table header shows empty information first.

I'm aware of SHOW NULLS FIRST | LAST as per another forum post, and it may be related to locale or collate settings on the db side.

I've reset some records to be blank instead of null, but perhaps, Postgres sees that as null information as well.

What is the recommended way to collate the table information to the top of the table?