Skip to main content
Question

IFS Cloud 24R2 U4 datasource designer how to filter last 7 days

  • March 24, 2026
  • 2 replies
  • 31 views
S
Hero (Customer)
Forum|alt.badge.img+11

Hi I have the following projection based datasource designer

Projection - ManufacturingMaterialHistoryHandling 

Data Root - MaterialHistory

I have the following set as the filter which is working

Contract eq 'RAL' and 
MaterialHistoryActionDb eq 'SCRAPPRODWIP' or MaterialHistoryActionDb eq 'UNSCRAPPRODWIP' or MaterialHistoryActionDb eq 'SCRAPCOMPWIP' or MaterialHistoryActionDb eq 'UNSCRAPCOMPWIP' 

now I want to restrict the data to the last 7 days, can I do this as the syntax for TimeStamp I’ve tried I keep getting errors.

Thanks in advance for help, always appreciated.

2 replies

Udara Hasantha
Do Gooder (Customer)
Forum|alt.badge.img+4
  • Udara Hasantha
  • Do Gooder (Customer)
  • March 25, 2026

Hi ​@sholmes 

Yes, you can restrict the data to the last 7 days in the Projection Data Source Designer. Since this uses OData filter syntax, the way you write the timestamp condition is important.

Try this 

Contract eq 'RAL' and 
(MaterialHistoryActionDb eq 'SCRAPPRODWIP' or 
 MaterialHistoryActionDb eq 'UNSCRAPPRODWIP' or 
 MaterialHistoryActionDb eq 'SCRAPCOMPWIP' or 
 MaterialHistoryActionDb eq 'UNSCRAPCOMPWIP') and 
YourTimeStampField ge now() add(-7, 'day')


Thanks 
Udara.

S
Hero (Customer)
Forum|alt.badge.img+11
  • sholmes
  • Author
  • Hero (Customer)
  • March 26, 2026

​@Udara Hasantha - thanks for the reply, unfortunately when I’ve just tried this I get an error. We are applying U16 next week so I’ll try again after that.

Terms & ConditionsCookie settingsAccessibility statement