Hello, in my report I have add a filter on a date (selected by user) field with the between condition, but I can not include the initial and final date.
For example, my user choose:

min date=2/01/2023
max date=5/03/2023

With this inputs I got all values from 3/01/2023 to 4/03/2023, but I need even the days 2/01/2023 and max date=5/03/2023.

How can I do it with the between condition?

Hi, thanks I understand the problem.
Unfortunately I can not modify the database datas...Can I set some rule in the filter values so that the selected day will be automatically 31/12/1997 23:59:59 like in your example?

Thank you, its working for most of my cases but I am stuck in particular situation.
I have a report with 2 different Sources and 2 different models for two peoduct A and B.

In my case I have DB_A and DB_B, the column I have to use in the DBs have these names and I can not change them:
-For DB_A: ProductionDate_A and OrderDate_A
-For DB_A: ProductionDate_B and OrderDate_B

My two models perform data manipulation on Productions and Orders for both products in the same report.
I need to perform the same task you give me but on both products.

I have try to add the OR condition like this:

var restr = report.AllRestrictions.First(i => i.SQLColumn == "Orders.OrderDate_A" || i.SQLColumn == "ProductionDate_A");

Add another variable to manage the two cases:

var restrA1 = report.AllRestrictions.First(i => i.SQLColumn == "Orders.OrderDate_A");

restrA1.Date1 = restrA1.Date1.AddDays(1);

var restrA2 = report.AllRestrictions.First(j => j.SQLColumn == "ProductionDate_A");

restrA2.Date1 = restrA2.Date1.AddDays(1);

And create for different task for each case but it gives me this error: "Sequence contains no matching element"

I have check multiple times and the column name are corrects, no space, underlines,ec...
I have already try to change the execution time of the task but nothing changes...
What can be the problem?

I have manage to "resolve" partially the problem...I had to modify all my filter parameter to the same name "Date".
Now only the first filter work.

What I can not understand is why I am getting that problem...In order to use:
@{
ReportTask task = Model;
Report report = task.Report;
var restr = report.AllRestrictions.First(i => i.SQLColumn == "Orders.OrderDate");


restr.Date1 = restr.Date1.AddDays(1);
//or Date2 for a between
}

like you suggested, "Orders.OrderDate" must be without dots, underscore or other particular characters?


Another question, I was not able to use your debug instruction...where and how I should use it? For example, in the original script you give me, where I should put and use it?

Last one, is possible to write a task only for a specific model?
For example, in my report I have model1, model2, model3,...,model6, can a task only work for model1, another only on model5, etc..?

Edited by user Tuesday, October 17, 2023 10:49:40 AM(UTC)  | Reason: Not specified

Hi, thank you a lot for your fast reply.
Can I ask you to explain a little what your script do? I am not quite familiar with razor script...

Especially I do not understand if you have inserted in this script all the aswer at the questions (this is not a complaint), or just to the main one regarding the debug instructions.