Sort Order Including "Null" Items

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: fields, sort order

Author

Posts
October 29, 2019 at 7:43 pm #515297

identity
Lifetime Member

Post count: 445

Bug?

I’ve setup a number of different sort orders, including a Pricing field.

When I select the sort order: Price Low>High, the archive page resorts the listings.

However, those listings that have not provided any Price information actually end up ahead of those listings that have provided information.

I would think that the handling of listings in this case would either be one of two ways:

1) Sort based on criteria (including secondary sort criteria), excluding any listings that are null or empty for that criteria field.

2) Sort based on criteria (including secondary sort criteria), then include null or empty criteria field listings following those that do included that criteria, again based on secondary sort criteria.

Being placed “after all others” or not at all for a sorting provides a nice incentive for both including the additional detail (even for free listings) as well as upgrading to packages that include those additional fields.

Cheers

October 30, 2019 at 9:32 am #515320

Kor
Moderator

Post count: 16516

Hi there,

Thanks for your post. Could you share your Website URL here in question so that we could check on it?

October 30, 2019 at 11:07 am #515330

Alex Rollin
Moderator

Post count: 27815

Hello,

Null and 0 are treated the same in that case because a number field’s value is actually 0. The only workaround is to use a text field.

October 30, 2019 at 4:35 pm #515379

identity
Lifetime Member

Post count: 445

What I’m using is the Price Range field. I guess I wouldn’t have thought it dealt with numbers specifically, but more like a select field.

Thanks
Author

Posts