Search and filters with contains

  • 2
  • Problem
  • Updated 3 years ago
  • In Progress
When I select a specific string field "Search Tax" the "Contains" option is missing.  When I select a different string field "Search Name" the "Contains" appears.  If I then select the first String Field "Search Tax" and save the "Contains" disappears.

https://drive.google.com/file/d/0B409lhd9sYDcX3p2RjladDRlTXM/edit
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb

Posted 3 years ago

  • 2
Photo of Irvin Waldman

Irvin Waldman, Champion

  • 9,006 Points 5k badge 2x thumb
Hey Bill, 

Is Search Tax a formula field? If memory recalls, formula fields are not searchable since they are calculated at runtime. 

Regards,
Irvin
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb
I have been using formula fields to create a field of concatenated data for my search field.  Then when I do my filter I can look in just one field.  I have built many searches in this manner.  As can been seen in the following picture.
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb
I noticed my first video did not play.  Here it is again.  I think it may have something to do with the length of the concatenated field.  I split the field into smaller fields and then query both fields and it works.  Is there limit on the length of field being searched?
https://drive.google.com/file/d/0Bw_R0LtXRtg3eHFLaURCYkVwcHM/view?usp=sharing
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Bill - what is the field type of the formula field.  The contains operator only works on certain field types. 
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb
It is a text formula field.  Everything seems to work fine if the concatenated field does not get to long.