AnsweredAssumed Answered

Is There a way to append String value to the sql query

Question asked by nagandla on Aug 25, 2016
Latest reply on Aug 26, 2016 by nagandla

 

below is my query 

 

select Id, product, prodDesc,compId, count
FROM Account WHERE ID=:1 AND AC.RBTCUST_BO_ID= CO.BO_ID
And ROWNUM <:2 order by :3

 

so if you see I can pass id or prodId as order by critera..

 

If I am doing so in database profile the value is added as below i.e the end query is below because I am currently using it as bind variable,

 

select Id, product, prodDesc,compId, count
FROM Account WHERE ID='Test' AND AC.RBTCUST_BO_ID= CO.BO_ID
And ROWNUM <51 order by 'prodId'

 

but what I required is

 

select Id, product, prodDesc,compId, count
FROM Account WHERE ID='Test' AND AC.RBTCUST_BO_ID= CO.BO_ID
And ROWNUM <51 order by prodId

 

and above can be achieved in java or any programming language by appending the string values dynamically value.similarly is there any way of doing same in Boomi ?

 

 

 

Outcomes