db2907 Posted January 15, 2018 Share Posted January 15, 2018 Hi thereHi wonder if it is possible to create a dblink connection using parameter in Jasper. Something like this: SELECT *FROM ( SELECT * FROM dblink('dbname=db port=5432 host=dbhost user=dbuser password=dbpassword','SELECT column_1, column_2, date_in FROM table t WHERE t.date_in >= $P{start_date}') as check_table(column_1 integer, column_2 text, date_in date) ) as b order by checkout_number [/code]Using de $P{start_date} parameter as an internal filter to improve the performance of my query.I have made some test and looked for some approaches, but so far anything haven't t worked. Anyone has any idea about how to reach this, or this is definitly not allowed? Regards Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now