Apply boolean filter

Girish Kale shared this question 11 months ago
Answered

I've a table that has column is_latest which will have values either 0 or 1 for each row.

In a report, I want to provide a filter such that it displays one value - "Show latest Data" and that means it applies filter - my_table.is_lateat = 1 in the generated SQL of a report. If I don't use the filter(it is not a mandatory filter) it will not apply the filter thus effectively return all records from a table. Can you please help here?

Also I'll prefer this filter (maybe a calculated field) defined at the view level so that I can use it in any report I create from this same view.


Thanks in advance.

Girish Kale

BMC Software.

Best Answer
photo

Hi Girish,

I have attached a short video to show you how to do this ("Apply_Boolean_filter.mp4").

Please take a minute to watch and then let me know whether that helps you meet your reporting requirements or not.

regards,

David

Comments (1)

photo
1

Hi Girish,

I have attached a short video to show you how to do this ("Apply_Boolean_filter.mp4").

Please take a minute to watch and then let me know whether that helps you meet your reporting requirements or not.

regards,

David

photo
1

Hi David,

Thanks a bunch for your advice. I solves the task at hand!


Best,

Girish

photo
1

that's great news Girish, thanks for letting me know!

photo