Jump to content
  • 0

filtering by 'contains' not working for similar values even with quotes




I'm trying to figure out how to filer records with a text field that contains comma delimited values.  The problem is the search doesn't actually recognize 'delimited' in a field and so 'contains' will bring up records that I need to filter out. 

For example, if a record's text field has a value of 1,2,3,4,12,22 the user might do a search/filter; "‘contains 2” (it can’t do = 2 because the actual value of the field is “1,2,3,4,12,22” and “2” won’t be equal to it).  But the ‘contains’ function will bring up records with not only ‘2’ in them but also ’12’ and ’22’ etc. 

I tried using "" in the search box so "2" would bring up records with just 2 and not 12 or 22, etc, but this doesn't work either. Does anyone know how to deal with this? I can't use List for data type as these records are imported and you can't import to List fields. The value 1,2,3,4,12,22 denotes a multi-record, meaning that record is related to 6 different records in another table. 

Thanks for any help!

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hello @DesiLogi

To implement this you may change your table design.

You have two tables. Table 1 is the parent table and Table 2 is the child table. Unique id's of the first table are "a", "b" and "c". Unique id's of the first table are "1", "2", "3", "4", "5", "6" and "7".
You need to create third table to connect these tables. 
tabe1_id   table2_id
a                    1
a                    2
a                    5
b                    3
b                    4
b                    6
c                    2
c                    6
c                    7

Then, you may create a View to gather all the data and use this View as the source for your Reports.
Here you can find helpful information related to Many-to-Many relationship - 


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...