Filter results

[rlautman]

I have a search that returns a 2 multivalue fields, product and productstatus - I have used mvzip to combine the results of these fields into one, productandstatus - I want to filter these results in the search so that only certain rows are returned: for example

Multivalued field productandstatus - I would only want Type1, regardless of status, to be returned

Type1,acknowledged
Type1,cancelled
Type2,completed
Type4,cancelled

[martin_mueller · Accepted solution]

That sounds like a job for mvfilter() together with match(), probably looking for "^Type1,".

[rlautman]

Works like charm, thank you! 🙂