Skip to main content
Known Participant
July 2, 2024
Question

how to dynamically filter date in record type

  • July 2, 2024
  • 4 replies
  • 9 views

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
November 7, 2024

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
November 7, 2024
stefanhelzle0001
Brainy
November 7, 2024

"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
November 7, 2024

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