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
That search is not based on the value that you show to the user, but on the value stored in the DB. How do you implement that search?
Hi Stefan! Thanks for your response!
I’m not sure how the search is implemented because it's an automatic filter from the RecordType. I don’t understand where this configuration is set since there are no explicit filters applied, yet the search works for the other columns.
Where can I find more information about how this search mechanism works?
I think that "search" is not made to work with date fields. Did you consider to add a date range user filter?
Yes, the search box will not filter the dates. As Stefan mentioned, date range filter would help.
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.