Page 1 of 1

Table column Sort with nulls, change to space?

PostPosted: Mon Jun 24, 2019 4:14 pm
by joe26
Hi,

Is there a way within Query Builder to perform an operation on columns that results in the display of spaces?

When a column is resorted by selection, all null items appear at the top of the sort. In the case of nulls, those null values sort first.
Real data always shows at the bottom of the table. Can calculations be used?

Has anyone seen and resolved this issue?

thanks,
--Joe.

Re: Table column Sort with nulls, change to space?

PostPosted: Fri Jul 05, 2019 9:25 am
by rgansevles
Joe,

This may be achieved by changing the collation on your database.

You cannot use calculations in QueryBuilder.

In QueryBuilder, you could sort on values using the nullif function:
Code: Select all
query.sort.add(query.columns.mycol.nullif('').asc)


Hope this helps,

Rob