Hello,
I am using open source BI Helical insight enterprise edition version 6.0. I am using canned report module to create few reports.
My question is how can the ALL option be handled in the filter UI so that the report returns all records when ALL is selected? A the filter level I can see that ALL option is present and I want to make it work.
Thanks,
Vema.
Hello,
In the filter UI, users see the option ALL, but internally the value passed to the SQL query is all. Since the database column does not contain the value all, using a direct equality condition will not return any records.
To handle this properly, the report query should include a condition that checks whether all is selected.
Example:
select * from "travel_details"
where "travel_medium"= ${travel_medium} OR '_all_' in (${travel_medium})
When a specific value is selected, the query returns only the matching records.
When ALL is selected (internally passed as all), the condition ‘all’ IN (‘all’) becomes true, so the filter is ignored and all records are returned.
This approach helps in handling the ALL option correctly in report filters.
You can refer to this video for better understanding
Thanks,
Helical Insight.