Forum Discussion

Roger667's avatar
Roger667
New Contributor III
2 years ago
Solved

Passing Pipeline Parameters in Salesforce Soql Snap

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

 

 

  • manichandana_ch's avatar
    manichandana_ch
    2 years ago

    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's avatar
    SpiroTaleski
    2 years ago

    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 

3 Replies

  • manichandana_ch's avatar
    manichandana_ch
    New Contributor III
    2 years ago

    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's avatar
    SpiroTaleski
    Valued Contributor
    2 years ago

    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