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

6 posts by 2 authors in: Forums > CMS Builder
Last Post: September 26, 2016   (RSS)

By Damon - September 22, 2016

Hi Jeff,

Try this query in Order By clause:

dragSortOrder, companyName = "", companyName

Let me know if this works for you.

Thanks!

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By JeffC - September 23, 2016

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.

Jeff

By Damon - September 23, 2016

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?

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By JeffC - September 23, 2016 - edited: September 23, 2016

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!

Jeff

By Damon - September 26, 2016

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!

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/