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()
Go to Solution.
@PSan1979 , when you create a connection in the advance option you can give a query
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.