filter condition based on query

[PSan1979]

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()

[amitchandak · Accepted solution]

@PSan1979 , when you create a connection in the advance option you can give a query