Forum Discussion

darktiger7's avatar
darktiger7
New Member
2 years ago
Solved

Getting different output when selecting dates and check in null values

Hello All, I am trying to create a report using Power BI Builder i want to run the report with selecting dates and without dates.   issue with the Submission Tracker, reported by one of...
General Comment
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi darktiger7 ,

    Thanks for reaching out to us with your problem. According to your description, it seems like you’re experiencing discrepancies in the number of rows returned by your Oracle SQL query when you select dates and when you don’t. Please check if the parameter :i_actual_dt_from and :i_actual_dt_to has been set the suitable dates... If both of them are NULL, then the following conditions will always true. It will return the rows with unlimited dates. 

    and (trunc(vm.act_dt) >= to_date(:i_actual_dt_from) OR to_date(:i_actual_dt_from) is NULL)
    and (trunc(vm.act_dt) <= to_date(:i_actual_dt_to) OR to_date(:i_actual_dt_to) is NULL)

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi darktiger7 ,

Thanks for reaching out to us with your problem. According to your description, it seems like you’re experiencing discrepancies in the number of rows returned by your Oracle SQL query when you select dates and when you don’t. Please check if the parameter :i_actual_dt_from and :i_actual_dt_to has been set the suitable dates... If both of them are NULL, then the following conditions will always true. It will return the rows with unlimited dates. 

and (trunc(vm.act_dt) >= to_date(:i_actual_dt_from) OR to_date(:i_actual_dt_from) is NULL)
and (trunc(vm.act_dt) <= to_date(:i_actual_dt_to) OR to_date(:i_actual_dt_to) is NULL)

Best Regards