Question

Dataset OQL wrestling

1

I have the following dataset: for this report: This is an entity with a date, an integer and a reference just to do some testing. I want chart with the days at x axis and to sum the integers on that day. And the user must be able to give a date range. Everything works but whatever I enter in the datarange the chart shows all the entries and not the date range. I must be doing something wrong but I do not get an error.

asked 2011-09-06

Ronald Catersels

1 answers

Alexander Willemsen · Accepted Answer · 2011-09-06

You're not using the input parameter in your report query. You should add a WHERE-clause to your query that looks something like this:

WHERE Rapportage.Test/Datum IN $Datum