JDBC source help

Ketan Pandey
Tera Expert

HI All.

 

We have created JDBC data source to fetch all site data store in a database.I have used the SQL Specific in my JDBC Source.We want to make on demand call based on the Site Name .

 

Example :-

 

SQL Statement 

 

select siteid from   siteMap where name=sitename

 

here sitename value i want to pass dynamically i.e the value selected by user on incident record.

please sugegst

1 REPLY 1

Omkar Mone
Mega Sage