How to add dynamic date field as a user filter on record type?

Certified Senior Developer

 Hi,

I want to have a dynamic date filter on record type as a user filter. Any suggestions welcome. Scenario is user wants to filter records on date range. Thanks

  Discussion posts and replies are publicly visible

  • In Appian there is no date field specific on record facts, so you can create a facet item like "Last 7 days","Last 30 days" etc,
    so whenever user click on the facet item you get the value like {7,30,etc}, On the query entity you can use between (Filter option ) to get the range
    Ex
    For Last 7 days
    {today{}-7,today()}
  • HI Jagadeeshs,

    1) As commented by Vinay the only option you have in the record to look for information using user filters facets is giving the user the option to filter the information using a dropdown.
    2) The second option(not using records) is to create a Report using the same layour of the record there will be lot easier to apply the data range, here you can add links to the records and get your Related actions.
    3) You always have the option to query the information using an Expression as the datasource and play with the rsp!query and parse the search and get all the filters you want .

    Jose
  • 0
    Certified Lead Developer
    I agree with on option 2. A report would be better to capture this feature so the user can enter specific dates where they can filter on since Appian doesn't support that feature in records.