Apply boolean filter
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.