Jump to content
We've recently updated our Privacy Statement, available here ×

Parameter in Dblink Connection


db2907

Recommended Posts

Hi there

Hi 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

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...