I have a table Reports with a field phrases. The phrase field has a list of texts, like “was identified for” or “was shown by”.
How can I search reports where a chunk of text contains at least one of these phrases?
A text block might be something like “James was identified for eating crisps”. The report that contains a phrase “was identified for” should therefore be shown in a RG for this piece of text.
I’m running into a dead end with advanced filters, which appear to only let you check ONE item is contained within a block of text (see screenshot).
Many thanks for advice!