Can standard ORDER BY be configured to list NULL items at the end

Hi Jeff,

Try this query in Order By clause:

dragSortOrder, companyName = "", companyName

Let me know if this works for you.

Thanks!

Hi Damon

Just to be certain that I have put this in the correct place: this should go in the Order By field, under the Sorting Tab in the Section Editor, is that right?

Thanks for your idea, but unfortunately it didn't work.

Just to be certain that I have put this in the correct place: this should go in the Order By field, under the Sorting Tab in the Section Editor, is that right?

Thanks for your idea, but unfortunately it didn't work.

Yes, the query goes in the Order By field under the Sorting tab.

It worked for me. Not sure what the issue may be. 

Did you get an error message?

Did the sorting change at all?

Hi Damon. No error, but no change. Were you using it in combination with dragsortorder? I was, so maybe that was the issue? I'll try again on Monday. Not sure how to remove dragSortOrder without receiving an error - but that's another issue!

Hi again,

Hi Damon. No error, but no change. Were you using it in combination with dragsortorder? I was, so maybe that was the issue? I'll try again on Monday. Not sure how to remove dragSortOrder without receiving an error - but that's another issue!

Yes, I was using it with dragSortOrder and it worked for me.

If you don't need dragSortOrder and want to remove it, here are the steps to remove dragSortOrder:

1. Go to the Admin > Section Editor or CMS Setup > Section Editor, depending on what version of CMS Builder you are using.
2. Click you modify link for the Section Editor that you want to remove the dragSortOrder field.
3. Click the erase link for the dragSortOrder field.
4. Next, remove dragSortOrder from the ListPage Fields (under the General tab), then click the Sorting tab and remove it from the Order By field. Click the Save Details button.

That's it.

Can you try this again and if it doesn't work, copy and paste in your forum reply exactly what you have in the Order By field?

Thanks!