I have a custom report saved with no filter criteria. When calling it, I populate the criteria through the URL, so that the final URL looks something like:
This works fine and fills in up to 10 filter criteria. However, I don’t seem to be able to use the bool_filter parameter to configure custom logic. From my understanding, the format should look like
bool_filter=(1+OR+2)+AND+3. When this parameter is in the URL, I am directed to the Customize Report screen instead of displaying the report itself, and none of my criteria are reflected.
It seems possible to me that this might be a result of my report having no criteria in place initially, and maybe therefore “1 and 2” don’t have any reference for bool_filter. Anyone have any experience with this?
I figured it out. The bool_filter parameter can only refer to criteria rows that are saved in the Report. My “template” report was saved with no criteria, so that I could add them one at a time. So when bool_filter refers to
1 AND (2 OR 3), those filter rows don’t exist in the saved report, and it doesn’t know what to do.
Solution for me: I saved the report with 10 filter rows, each of which is
Created Date not equal ''. Then I change what fields and values those filter rows are pointing to, and make sure the bool_filter parameter includes all integers 1 through 10. The final URL looks like this: