Issue with Date Column Search in RecordType from Interface

Question

Hi everyone, 
 I'm encountering an issue when performing searches on a RecordType through an interface. The searches work perfectly for all columns except for one that is of type date . I&rsquo;ve tried changing the format to match the database format ( yyyy-MM-dd ), but even then, the search returns no results when I query by that date column. 
 Does anyone know why this might be happening or how I can resolve this issue? 
 Thanks in advance! a!gridColumn( label: "Fecha", sortField: 'recordType!{...}.....fields.{....}fecha', value: text(fv!row['recordType!{....}....fields.{....}fecha'], "yyyy-dd-MM"), align: "START", width: "AUTO" ),

Soma · Answer

lumi29 
 The search box allows users to search for records only based on the Text and Number fields referenced in the record list. 
 https://docs.appian.com/suite/help/24.1/filter-the-record-list.html#search 
 You can have a separate filter for date ranges. 
 Or you can try adding a custom record field to change the datetime field as a text (if you are okay with sync time evaluation). I do not guarantee that it will work.

Issue with Date Column Search in RecordType from Interface

Top Replies