Skip to main content
L
luciam
September 3, 2024
Question

Issue with Date Column Search in RecordType from Interface

  • September 3, 2024
  • 5 replies
  • 1 view

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.

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"
),

5 replies

stefanhelzle0001
stefanhelzle0001
Brainy
September 3, 2024

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?

L
luciamAuthor
September 3, 2024

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?


stefanhelzle0001
stefanhelzle0001
Brainy
September 3, 2024

I think that "search" is not made to work with date fields. Did you consider to add a date range user filter?

    somasundaram.d
    somasundaram.d
    September 5, 2024

    [mention:6b905e9a23224b10ad37b79eb1eea628:e9ed411860ed4f2ba0265705b8793d05] 

    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.

      Terms & ConditionsAccessibility statement