Record search criteria

Another option for an entity backed record is to create a view and map the record to that view rather than simply using the table. You'll then be able to add custom fields in that view (and related CDT) just for searching, and use the (officially unsupported) method to enable them as searchable.

A good example of this is dates. Add a field to the database view that casts a date (eg a start date) to text using a date format function so that you get a text field containing values such as "24 November 2016", add it to the record via the concat() method, and your record will be searchable using values like "nov 2016" or "24 nov".

Another option for an entity backed record is to create a view and map the record to that view rather than simply using the table. You'll then be able to add custom fields in that view (and related CDT) just for searching, and use the (officially unsupported) method to enable them as searchable.

A good example of this is dates. Add a field to the database view that casts a date (eg a start date) to text using a date format function so that you get a text field containing values such as "24 November 2016", add it to the record via the concat() method, and your record will be searchable using values like "nov 2016" or "24 nov".