Question & Answer > View Question

Passing Current user Hash Variable in JDBC SQL Custom Query

Confluence User - 12 Jun, 2015

SQL Query works fine on SQL Developer
Select c_routeStatus, c_systemRouteId, c_Route_ID, c_businessUnit, c_qa_date, c_prod_date, c_currentUser, datemodified
from <Table_Name> where c_status like 'Draft%'
and c_businessUnit in (Select name from dir_group where id=ANY(Select groupId from dir_user_group where userId='andy_sa'))
SQL Query doesn't work on JDBC customer SQL DataList
Select c_routeStatus, c_systemRouteId, c_Route_ID, c_businessUnit, c_qa_date, c_prod_date, c_currentUser, datemodified
from <Table_Name>
where c_status like 'Draft%'
and c_businessUnit in (Select name from dir_group where id=ANY(Select groupId from dir_user_group where userId='#currentUser.id#'))

Can we pass Current User Hash Variable in JDBC Custom Queries like the Userview Key variables?

datalists

2

Confluence User •

17 Jun, 2015 •

confluenceUser •

1 •

confluenceUser •

Try this.

Select id, c_routeStatus, c_systemRouteId, c_Route_ID, c_businessUnit, c_qa_date, c_prod_date, c_currentUser, datemodified 
from <Table_Name> 
where c_status like 'Draft%' 
and c_businessUnit in (Select name from dir_group where id=ANY(Select groupId from dir_user_group where userId='#currentUser.id#'))

Confluence User •

17 Jun, 2015 •

confluenceUser •

•

confluenceUser •

Thanks Walter, This worked perfectly fine.

1

CSV | Excel | XML | PDF

Your answer

Print

Passing Current user Hash Variable in JDBC SQL Custom Query

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-c7a8f55a-fc8a-449f-84e2-4d3bee5d0870{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-4f8a2073-3d10-4d07-8d9f-635ab6e51bdd{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer