Storage of multi-value fields

  • Resolved Content2Value

    (@martendijkstra)


    7 months, 2 weeks ago

    I really like this plugin, but what I really don’t understand, why are the values that someone selects in a checkbox or multiselect, stored in the database separated with a pipeline character (“|”) and not as a serialized array?

    So if someone for example picks 3 values: Fries, Pasta and Pizza, then in the database I see that they are stored like:

    Fries | Pasta | Pizza

    While it would make much more sense to store them like:

    a:3:{i:0;s:5:”Fries”;i:1;s:5:”Pasta”;i:2;s:5:”Pizza”;}

    They way values are stored now, makes it pretty much impossible to use filters on my website. I used several filtering plugins, but instead of getting each “food type” as separate choices to filter on, I get 1 filter choice of “Fries | Pasta | Pizza” if user A picked that, another option of “Sushi | Fries | Pancakes” if user B picked that, etc.

    Even if I match the WPUF fields with ACF fields, the values are still stored using the pipeline character, instead of a serialized array (which ACF would normally do).

    Is there a way I can make filtering work, when using fields that can store multiple values?

Viewing 1 replies (of 1 total)
  • Plugin Support Md. Anower Hossain

    (@anowerhossain16)

    7 months, 2 weeks ago

    Hi @martendijkstra,

    Thanks for your valuable feedback and for sharing your thoughts with us.

    Currently, our plugin saves multiple field values using the pipeline (|) separator, and this structure has been in place since the very beginning. Changing it would affect many existing features and user data, so it isn’t something we can adjust immediately.

    That said, we understand your point about filtering and integration with plugins like ACF. If more users request this improvement, we’ll consider adding a more flexible storage option (like serialized or JSON format) in future updates. We have already added your request to our feature request queue.

    In the meantime, you can use a custom snippet to split the stored values by the “|” symbol and convert them into an array to make them compatible with your filtering plugin. You might need help from a developer to customize. WP User Frontend is fully customizable.

    I hope this information helps.
    Have a nice day.

Viewing 1 replies (of 1 total)

The topic ‘Storage of multi-value fields’ is closed to new replies.