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.
Can you show me what you have done so far, so I or another person can send you the specific solution for you ?
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.
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.