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.
Discussion posts and replies are publicly visible
Did you check this?
docs.appian.com/.../fnc_system_a_recordfilterdaterange.html
Hi Luis Miguel ,
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
Luis Miguel 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)
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?
Thank you so much, But this statement contains now() and it gives me the same error
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.
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()
Just out of curiosity, why do you want to apply the filter at source level on the record?
.... and for what purpose?
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.