Search behaviour within Records for integers

(nothing jumped out at me in the documentation but i might being going blind!)

Even we are facing the same issue. I tried changing it to the Grid layout but still the partial search does not work

Is your record process backed or data backed? We're just going to change the CDT and cast it in the view..

Adjustments in the grid display won't have any affect since the user facets re-query the data from the source.

I suggest casting from integer to text in the record's underlying DB view. You can then use "includes" as the operator in the a!queryFilter defining the User Filter, assuming you are either (1) using an expression-backed entity querying the view or (2) using an entity-backed entity on v 16.1+ .

Our record is Entity backed.
@Jamie,
Is there anyway that we can make this work without changing the data type?
I am not sure whether we can change the data type for this requirement alone.

Sanjay - to be clear, you are trying to essentially search "includes" on number, right? E.g., get 12367 as a result of searching "123" or "36"?

I am not aware of any way to do this aside from adjusting the data source--the DB view in your case--because the queryFilter can't query against a manipulated value. The view is the most appropriate place to make such a data manipulation, unless the table should be changed based on your use case for populating the field.

If the view is being referenced by other objects (which isn't recommended; generally, each record list should have its own dedicated DB view), then you could ADD a column instead of REPLACE the existing column. Either way, the definition of the column would essentially be the following, for Oracle:
cast NUMBER_FIELD as VARCHAR2(255)

I recommend you investigate whether the DB index on this column (hoping that one exists) would still be used by the DB's cost-based optimization (CBO). If the CBO won't use the index because of the type-cast, then you may want to explore other options such as changing that field's data type in the underlying table.

Sanjay - to echo Jamie, this is the action we took - as he DB view was dedicated to the record listview this is literally a 10 minute update.

Note - even if you don't have a dedicated CDT for the listview, its not huge effort to create a copy of one now..

Chris, I have done the changes by using a different CDT(same structure and different datatype as we are retrieving the the data from multiple tables and writing view is not an option for me) just for the records and retrieve the data. It worked.
I was just curious to know if there is any other way to make this work without changing the datatype or creating the new CDT for records.
I tried using conversion functions in the list view but of no luck.

Thanks Jamie and Chris for your clarification.