cancel
Showing results for 
Search instead for 
Did you mean: 

Passing Pipeline Parameters in Salesforce Soql Snap

Roger667
New Contributor III

Roger667_0-1695937782668.png

When i am passing pipeline parameters 'time_column' and 'object_name' i am getting Error. Same with Salesforce read Snap

 

 

2 ACCEPTED SOLUTIONS

manichandana_ch
New Contributor III

Hi Roger,

Please click and highlight the equals sign below 'SOQL Query'* in order to use the pipeline parameters in SOQL query. We need to make sure we enable the '=' to use expression language. Also please remove semicolon at the end or add it within quotes. (_object_name+';')

Thanks !

View solution in original post

SpiroTaleski
Valued Contributor

@Roger667 

The query should looks like below: 

"Select max("+_time_column+") maxtime from "+_object_name+""

But as @manichandana_ch mentioned please make sure you enabled the "=" button. 

BR,

Spiro Taleski 

View solution in original post

3 REPLIES 3

manichandana_ch
New Contributor III

Hi Roger,

Please click and highlight the equals sign below 'SOQL Query'* in order to use the pipeline parameters in SOQL query. We need to make sure we enable the '=' to use expression language. Also please remove semicolon at the end or add it within quotes. (_object_name+';')

Thanks !

SpiroTaleski
Valued Contributor

@Roger667 

The query should looks like below: 

"Select max("+_time_column+") maxtime from "+_object_name+""

But as @manichandana_ch mentioned please make sure you enabled the "=" button. 

BR,

Spiro Taleski 

Roger667
New Contributor III

Thanks @SpiroTaleski and @manichandana_ch . It worked