Question

1
Replies
1059
Views
AnujN348 Member since 2016 73 posts
Infosys
Posted: July 5, 2017
Last activity: July 5, 2017
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 ?

Low-Code App Development Data Integration Java and Activities
Moderation Team has archived post
Share this page LinkedIn