CAP where clause to filter dates in an As Projection Variant entity service

[jr_golive]

Hello community. 

I'm currently trying to use a where clause to filter by dates (only to show a list of items created in a 30 days range from the current day), in my entity service created using the As Projection Varian approach. The problem is that I'm not sure how to have that value date dynamically calculated into a sort of variable, so the filter can occur.

The OData service is being consumed by an 3rd party app, in which the user can post items in the table. But also the external app is getting the list of items created, but they need to be filtered using the criteria described above (today - 30days).

Any insight would be highly appreciated.

The model:

The entity service exposed with the where clause incomplete

[Dinu]

Try using pseudo variable $now.

https://cap.cloud.sap/docs/guides/domain-modeling#pseudo-variables

[jr_golive]

Hey Dinu. Thanks for your reply.

That could have been an option. The problem is that I need to have some calculations in place (not just the usage of the pseudo variable). The approach we have gone to is service handler implementation in js. That way we can make sure we can restrict using any different complex calculation