Closed
Passing a table name dynamically in a Connect Sql
I have a query in a connect sql used in RDB-list in an activity :
select count (pxCommitDateTime) from XX_CPE_WORK where {.pxCommitDateTime} >= to_date({.CalculationStart},'yyyy-mm-dd hh:mi:ss AM')
I have the table names in a property in a pagelist. I dont want to hardcode the table name. Instead i want to pass it dynamically.
How can i do this and what is the exact syntax for passing the table name dynamically ?
Posted: 7 years ago
BUPA
BUPA
AU
Hi Anuj,
You can use {Class: XXX-WWW-WWW-EEE} in place of hardcoded table name and there should be Data-Admin-DB-Table instance mapped to that table XX_CPE_WORK