Pipeline workaround - 'is contained within'

How can I accomplish this in a Pipeline? A- Search a table. Include a text field that is a list of items (semicolon deliminator). This search yields a handful of results. For each A: B...

Pipelines

MarkShnier__You

Qrew Legend

There is a Contains filter available in a Search. Can you explain why it can't be used?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

MikeTamoush

Qrew Commander

3 years ago

You can do: Contains

, but the reverse is not available.

is contained within the

.

I think my solution may be to reverse the order of my 2 searches. At least that's all I can come up with.

This essentially is regarding my other post. I had one i idea where I searched my subcontractors, all which have a field called 'missing dates'. So it might be like "1-1-2021; 3-1-2021'

Then I search a dates table which just has dates listed. I want to say, search the date table for where the single date is contained within the missing dates field.

I don't think that's possible, but I think i can search the date table FIRST. Somehow limit the dates to a manageable amount, then for each date find a subcontractor where missing dates contains that single date. Then finish my pipeline.

That's my only idea so far

------------------------------
Mike Tamoush
------------------------------

Forum Discussion

Pipeline workaround - 'is contained within'