Skip to main content
Known Participant
Jul 2, 2024 4:29 PM UTC
Question

how to dynamically filter date in record type

Hi there,

 I have a record type, just want to show the recent 7 days data, so in "Data Model" tag, I added a filter like this:

a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "verifiedon",
operator: ">",
value: todatetime(today() - 7)
)
},
ignoreFiltersWithEmptyValues: true
)

but seems it did NOT dynamically sync, after just set the filter, I manually sync, I just saw the last 7 days data. but for today, it's supposed to just see the data since 6/24. but I still see the data older than that.

so do I need to set the sync options to do the sync every day? or any better way to do this?

regards,

L

4 replies

New Participant
Nov 7, 2024 6:15 AM UTC

Hi 

Record type should be sync enabled   and apply source on verifiedOn  > today ()-7 and in sync options have scheduled sync to Sync all of your source data once each day at the specified time

somasundaram.d
Employee
Nov 7, 2024 7:53 AM UTC
stefanhelzle0001
Brainy
Nov 7, 2024 8:19 AM UTC

"Syncing" is not the same as "showing" the data. Did you consider to use a grid with a query filter to just show the right data?

linp0001Author
Known Participant
Nov 7, 2024 3:54 PM UTC

hi it has been resolved, like someone mentioned here, need to enable sync. regards,