Skip to main content
L
luismiguelf0003
June 4, 2024
Question

Filter by dates in the records' source filters

  • June 4, 2024
  • 10 replies
  • 0 views

Good morning,
I need to create a source filter in a record to retrieve those modified in the last half hour.
I tried using the now() function, but you mentioned it’s not valid for this type of filter.
Does anyone know another way to achieve this?
Thank you very much.

10 replies

davidj137213
davidj137213
Brainy
June 4, 2024

Did you check this?

docs.appian.com/.../fnc_system_a_recordfilterdaterange.html

jayaprakashr0001
jayaprakashr0001
Participating Frequently
June 4, 2024

Hi [mention:87eecc1977894a198f80167e0ff7fff9:e9ed411860ed4f2ba0265705b8793d05] ,

By using source filters you can filter by dates not with minutes. Try having custom record fields  a!customFieldDateDiff() and filter the data. It will help

shubhama926776
shubhama926776
Brainy
June 4, 2024

[mention:87eecc1977894a198f80167e0ff7fff9:e9ed411860ed4f2ba0265705b8793d05] You can't use now(), loggedInUser(), rule or constant in record source filter.
I would recommend you wherever you want data you can query using filter.

 a!subtractDateTime(startDateTime:now(),minutes:30)

शुभम्
    L
    luismiguelf0003Author
    June 4, 2024
    Thank you so much,

But this statement contains now() and it gives me the same error
    shubhama926776
    shubhama926776
    Brainy
    June 4, 2024

    Do not use this in source filter.
    When you are querying record data that time you can use this in filter value of column.
    While using in this functions a!queryRecordType() or a!recordData()

    शुभम्
    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 4, 2024

    Would this fit? Not exactly "30 minutes".

    https://docs.appian.com/suite/help/24.2/records-data-sync.html#keep-data-available-at-high-volumes

    What do you want to achieve?

    L
    luismiguelf0003Author
    June 4, 2024


    Hello,
    I want to ensure that when I change the key field by which I am filtering the record,
    there is a kind of delay of about 5 or 10 minutes before the record does not pick it up.

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 4, 2024

    .... and for what purpose?

    konduruc733182
    konduruc733182
    June 4, 2024

    Just out of curiosity, why do you want to apply the filter at source level on the record?

    peter.lewis
    peter.lewis
    Employee
    June 4, 2024

    I echo others - can you give us more context on what you're trying to do?

    I don't think this is going to achieve what you're trying to do. The source filter only applies during syncs (either full syncs or syncs from a smart service), and full syncs only run once per day. Part of the reason we restrict the source filter from using now() is that it doesn't really make sense to use now() if the sync only occurs once per day.

    Terms & ConditionsAccessibility statement