Sort Order Including "Null" Items

This topic contains 3 replies, has 3 voices, and was last updated by  identity 5 years, 1 month ago.

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

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • #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

    #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?

    #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.

    #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

Viewing 4 posts - 1 through 4 (of 4 total)

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

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount