1 Reply Latest reply on Mar 6, 2014 9:22 AM by Dylan Snyder

    filter a field that contains multiple data elements per value -- 20 possible individual elements in any combination

    Roger Stephens

      I need to be able to create a filter on a field that contains multiple data elements built from 20 possible individual elements in any combination. For example --  [Arm - Left Leg - Right Torso - Lower Head].  There is no designated delimiter in the field. If there were, the example would read [Arm - Left; Leg - Right; Torso - Lower; Head]. I have created a custom list of the individual body parts named 'Parts' for the filter to key on. I want to be able to filter on the presence of the word "Arm" or "Torso" or whatever other general body part may be listed in the 20 standards, such that any record that has the word 'ARM' in it is selected regardless of the additional content in the field. I have tried to do this with a parameter, but am having no luck. Any suggestions would be appreciated.