Post Meta filter – Contains

Anonymous

#52292

Hi,

We are looking to use the option to search filter based on the Post Meta value.
However we would like to be able to say that the field should contain the search criteria, instead of an exact match to the value.

To illustrate this with an example;
Country filter list
Options:
United States
Canada
Mexico

Post Meta value examples:
United States
United States, Canada, Mexico
Canada

Currently the 2nd option wont display if we look for United States.

I understand we could structure the data differently using custom fields/field groups/Taxonomy but the data in this field is coming in through an integration and we bound by the way the data is delivered. We could change the delimiter but that is about it.

Is this something we can update by making a slight code change?

This change would be used for all our Post Meta options.

Trevor

#52299

This is not something the plugin can do at this time. What integration are you using to import the data?

Anonymous

#52312

We are pushing the data directly into the database from our CRM system using our integration platform. The challenge was that if we want to push it into the database as Taxonomy items we have to update a lot of different fields in a lot of tables, besides that it caused some other challenges which simply did not make the it worth the effort.

We are able to push into the Post Meta very easy, however as mentioned this causes some limitations on the search functionality.

Trevor

#52313

It is a shame you can’t use PHP to convert the string with comma separated values into an array to then push that into the meta as a number of values. As it is, I can’t see how to achieve what you want.

[Author]

Posts