Free Hand SQL with Optional Filter

Tal Mickel shared this question 3 years ago
Answered

Hi,


I am trying to build a free hand SQL report with 2 filters - one mandatory and one optional.


Is there a way to use an optional filter in a freehand SQL report?


Thanks!

Best Answer
photo

Hi Tal,


no, unfortunately at the moment there isn't. So I guess you might have to use a Co-Display report and have one of the reports missing out the optional filter, and the other co-display report containing both of the filters.

It sounds like a good enhancement request so please raise it as an Idea in our Yellowfin Community.


regards,

David

Comments (3)

photo
1

Hi Tal,


no, unfortunately at the moment there isn't. So I guess you might have to use a Co-Display report and have one of the reports missing out the optional filter, and the other co-display report containing both of the filters.

It sounds like a good enhancement request so please raise it as an Idea in our Yellowfin Community.


regards,

David

photo
1

Thanks!

photo
1

no worries Tal. I will mark this ticket as "Answered" now, but if you think it is not really Answered then just reply and your reply will automatically change the status back to "In Progress" thus making it appear in the Support work list.