Category
Chart Builder
Product Version
9.0
Improved table date conditions at view level (Condition Builder)
Idea Logged
You write in the documentation itself: "is useful to limit the result set in a view by a data condition. For example to return only the last 90 days data." and then offers two quite primitive possibilities.
1 concrete date
2 +/- x days
1 is not very dynamic and 2 shifts with the date information but does not cover the possibilities of date filters in reports.
Suggestion
Adopt the already existing date filters from reporting to offer large data sets to users in a restricted way.
Business Case:
We want our customers to be able to view at most the content since the beginning of last year in reports. Of course, the users can restrict it comfortably in the report itself, but data security looks different. We need/want to prevent access to older data.
I like this idea 
Hi Stefan,
I understand that we are trying to apply a condition at view level(Model) to restrict the data (for security reasons) - as in the below sceenshot:
To me that works fine.
Could you please provide more information in the statement : "2 shifts with the date information but does not cover the possibilities of date filters in reports."
May be screenshot/screen recording outline the exact possibilities that are not being covered when we use option 2 but are covered when we don't? It would really help. Because at report level, I see everything as expected(please refer to screenshots below):
Warm Regards,
Deepak
Hi Stefan,
I understand that we are trying to apply a condition at view level(Model) to restrict the data (for security reasons) - as in the below sceenshot:
To me that works fine.
Could you please provide more information in the statement : "2 shifts with the date information but does not cover the possibilities of date filters in reports."
May be screenshot/screen recording outline the exact possibilities that are not being covered when we use option 2 but are covered when we don't? It would really help. Because at report level, I see everything as expected(please refer to screenshots below):
Warm Regards,
Deepak
Replies have been locked on this page!