Ability to Search on Concat Field
I have created a formula for a concat value "123 - Greenapple". The formula is concat(concat(to_string(id ), " - " ), name ). Rendering on a table I get the results no problem. However, when I try to use this field as a filter or search in the search bar, for "123" or "Greenapple" I get no results. I've tried to tune the indexing but not sure thats helping. Running version 4.3.
I narrowed down the pattern when there's different results between. It's not necessarily answer vs pinboard = different behavior.
Different results occur when:
- Search bar results vs filter box results
- Multiple filters (date, retailer) vs Single Filter (retailer)
The formula I have for retailer on the worksheet: concat(concat(to_string (id ), " - " ), name ) . Index for table.id and table.name set to PREFIX_AND_SUBSTRING. Index for worksheet.retailer also set to PREFIX_AND_SUBSTRING.
What retailer data looks like on Answer:
If I do a search in the search bar for retailer = "nord" I get what I expect.
If I do a filter on answer, this is what populates for everything:
Still in Answer, if I search within the filter box this is what I get for "nord". I would expect to see results for "nord". Recall search bar showed more results.
If I goto the pinboard. The results vary depending on if I have multiple filters. (Same behavior happens for answers with multiple filters). If I start with retailer as the first filter and look for "nor" I would expect to see Nordstrom in the results. Only some results return and do no include Nordstrom. There is no underlying filters on the worksheet that provides the filter for the pinboard.
On the pinboard, if I set a date filter and a retailer filter, search for "nor", only Nordstrom shows up in the results. This may be okay if the date filter is acting as a cascading filter. However I would expect Nordstrom to show up in the results when using 1 filter, similar to what returns when using the search bar for answers.
Pankaj - we can take this up on our webex tomorrow, but I wanted to posted in case others have similar issue.
Pankaj Ahire - I did one more additional test. I tested single field on a worksheet vs single field on worksheet with chasm trap.
Single field worksheet - same results for search bar and filter box regardless of multiple filters vs single filter.
Single field worksheet w/ chasm trap - different results for search bar and filter box for single filter.