Question

1
Replies
1112
Views
Close popover
Anuj Newrekar (AnujN348)
Infosys

Infosys
AU
AnujN348 Member since 2016 75 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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.