Forums › Forums › Search & Filter Pro › Order Options Problem?

Tagged: 

Viewing 10 posts - 1 through 10 (of 15 total)
1 2
  • Anonymous
    (Private)  January 22, 2020 at 7:12 am #231791

    Hello,

    I have a Choice-Dropdown on an ACF Field.
    It has entries like
    01-17 with Label 17-01
    02-17 with Label 17-02
    03-17 with Label 17-03
    01-16 with Label 16-01
    02-16 with label 16-02
    01-15 with Label 15-01

    Although i set diffent Order Options nothing changes in this order.
    I want to have “Label DESC Alphabetical” like 15-01, 16-01, 16-02,17-01, ….
    This ACF Field is a text field

    Anonymous
    (Private)  January 22, 2020 at 7:12 am #231792

    DESC or ASC doesn’t matter:)

    Trevor
    (Private)  January 22, 2020 at 8:10 am #231793
    This reply has been marked as private.
    Anonymous
    (Private)  January 22, 2020 at 9:46 am #231809
    This reply has been marked as private.
    Trevor
    (Private)  January 22, 2020 at 11:08 am #231813

    Any annotated screenshots you can make to help me would be appreciated. You will need to upload images to an external file sharing site, like dropbox, and share the link(s) with me.

    In the form UI, for the field set up of the Post Meta for the ACF Custom Field, did you set the source to be manual (where you can manually arrange the values)?

    Anonymous
    (Private)  January 22, 2020 at 1:33 pm #231827
    This reply has been marked as private.
    Trevor
    (Private)  January 22, 2020 at 1:57 pm #231829

    In the database, they do or do not have these labels stored? Or, are the labels stored only in the Form UI manual entry? The 4th screenshot suggests that they are only stored in the Form UI, which is why they cannot be sorted by label.

    With ACF, certain field types can have both value and label defined, in the Field group field definitions. See this as an example:

    https://www.screencast.com/t/QRjopEV2kBUs

    Anonymous
    (Private)  January 22, 2020 at 2:19 pm #231831
    This reply has been marked as private.
    Trevor
    (Private)  January 22, 2020 at 2:29 pm #231833

    Indeed, the only entry in the actual WordPress database, in the postmeta table, are the 01-17 type entries, as they are stored as the plain text fields. Thus that is all you can use for that sort.

    The list is also very long. That will cause the search to be very slow, as Search and Filter has to build that long list and perform counts on it. Having a really long list like this would not be a good end user experience.

    Do these represent years and months?

    Do you have a lot of posts already?

    Anonymous
    (Private)  January 22, 2020 at 2:33 pm #231835

    What are then the other entries? For me they all seem the same?
    I have about 25.000 posts.
    They represent “Year-Edition” – this newspaper has about 50 editions per year

  • Author
    Posts
Viewing 10 posts - 1 through 10 (of 15 total)
1 2