Extract records that have all of these tags

[NAOYA_WASHIZAWA]

I am creating a patient education program.
There are 20 tags in the tag master.
Each patient has 0 to 20 tags, which are stored in an array.
I specified multiple tags on the search screen and stored them in an array.
I would like to extract patient records that have all of these tags.
What steps should I take?
Please let me know if you know of any good templates or videos.

[MaximeBaker]

Can you show me what you have done so far, so I or another person can send you the specific solution for you ?

[NAOYA_WASHIZAWA]

Thank you so much !

I’m performing an OR search using tags.
If I select dog and bicycle, records that have those tags will be displayed.
If I select bicycle and book, records that have those tags will be displayed.
I would like to perform an AND search using the same mechanism.

[ThinhDinh]

I think you can try something like this:

• Cast the TagSearch column to the table you’re storing the patient records, using a Single Value column.
• Create an array from the single value “tag search” by splitting it using a Split Text column.
• Add a Make Array column, combine the patient’s array with the search array.
• Use a column to find duplicated items in the combined array.
• Use 2 columns to check the array length of the duplicated items and the tag search. If those lengths match, that record matches your search.