Cannot Add Custom Field of Type Array to Search Filter

[alasdaircr]

reported here: http://forum.espocrm.com/bug-reports/2913-cannot-add-custom-field-of-type-array-to-search-filter?routestring=forum/bug-reports/2913-cannot-add-custom-field-of-type-array-to-search-filter

Leaving this as placeholder as I need this and so will make up a PR

[yurikuzn]

How are you going to convert list of items into SQL expression?

[alasdaircr]

Not sure. Do have any ideas?

[yurikuzn]

To create complex expression like

(field_name LIKE '%'{VALUE_1}'%') OR (field_name LIKE '%'{VALUE_2}'%')

This looks bit hard coded.

P.S. I think it should be coded in Base SearchManager.

[alasdaircr]

Not really hard coded though as it's a generated query from the search parameters.

[alasdaircr]

Also doesn't need % fuzzy search as the parameters to the query come from the field declaration, so 100% match only

[alasdaircr]

Hmm forget that last comment :)

[alasdaircr]

But anyway, this feature should be there, even if not perfect. The field type is allowed, so searching MUST be allowed otherwise it's pretty useless.

[alasdaircr]

Sent pull request