Does anyone know if there is a way to customize the svySearch module so it can do wildcard searches against a calculated field?
We have users that want the values of child records rolled up and displayed in a grid column as a comma separated list on the parent, and then be able to search the list. The real value on the child records is numeric with a valuelist for the display values so if I add the related child field it has to be searched for by the exact number, not the display value. And If I add substitute values, the user still has to enter the display text exactly vs entering only a portion of the text.
Example, the parent record may be "ABC Store" and the child records have a few items (no more than 10-15). The child records have numbers that indicate the product (1=Coffee, 2=Tea, 3= Soda, 4=Milk, etc). The parent record would display "Tea, Soda, Milk, etc" in one of the grid columns. The user wants to be able to search for "Tea" as if the calculated field is an actual DB value.
Any direction would be greatly appreciated.
Louis