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’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.
date
yyyy-MM-dd
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" ),
Discussion posts and replies are publicly visible
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.