Forum Discussion

PSan1979's avatar
PSan1979
Helper II
5 years ago
Solved

filter condition based on query

Hi Experts,

 

I have a query given by user as below. how can I restrict this condition (a.enddate>=sysdate()) before loading into reporting layer.

select * from a left join b on a.id=b.id and a.enddate>=sysdate()

1 Reply