Just wanted to know is there a way to filter with multiple values in Digital Clay, e.g. I wish to know Contacts who within their employment notes it is written that they know BOTH SQL and ASP?
Thanks,
Noam Kaplan
To register for the forums, please contact your Digital-Clay representative.
Multiple values within a filter
-
ZevToledano
- Posts: 722
- Joined: Fri Apr 03, 2009 2:29 pm
Re: Multiple values within a filter
You mentioned a Notes field, so I presume you are using a 'Contains' filter. Currently, you can add multiple values in the filter values listbox (right-click/Add Value), but they are combined with OR. If you need two 'Contains' values combined with AND, this will only be available in a future version.
-
ZevToledano
- Posts: 722
- Joined: Fri Apr 03, 2009 2:29 pm
Re: Multiple values within a filter
P.S.
Another option is to use a "Matches" filter operand instead of "Contains" and use wildcards to combine SQL/ASP. But, this will only be practical if you know the order of the keywords you are searching for (i.e. in what order they appear in the notes).
A third option is to add the Notes field twice by adding it as a custom function filter. The two notes field filters will then be combined with AND. But keep in mind that Notes fields in custom functions are limited to the first 2000 characters for SQL Server.
Another option is to use a "Matches" filter operand instead of "Contains" and use wildcards to combine SQL/ASP. But, this will only be practical if you know the order of the keywords you are searching for (i.e. in what order they appear in the notes).
A third option is to add the Notes field twice by adding it as a custom function filter. The two notes field filters will then be combined with AND. But keep in mind that Notes fields in custom functions are limited to the first 2000 characters for SQL Server.