Apply boolean filter

Girish Kale shared this question 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.

The same question

Best Answer

Guest ●

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

Files:

Replies (1)

Guest ● ●

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

Files:

Reply URL

Girish Kale ●

Hi David,

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

Best,

Girish

URL

Guest ●

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

URL