Activity Forums Salesforce® Discussions How to pass Dynamic parameter in SOQL where clause, while mapping in Webmerge?

  • Ankit

    Member
    March 30, 2018 at 9:39 am

    Hi Adarsh,

    You need to follow this kind of formatting - ':API_NAME_FIELD'  for getting dynamics values in where clause.

    Hope it may help you 🙂

  • Adarsh

    Member
    March 30, 2018 at 10:22 am

    Hi Ankit,

    Is it necessary to have this kind of formatting?

  • Archit

    Member
    March 30, 2018 at 11:12 am

    Yes, it is necessary to have  this kind of formatting because it shows uniqueness.

  • Adarsh

    Member
    March 30, 2018 at 11:39 am

    Hi Archit,

    Here what is the meaning of 'uniqueness', when we work on SOQL?

  • Archit

    Member
    March 30, 2018 at 12:09 pm

    uniqueness a common word that everyone understand but here the uniqueness determines the specific field or object for which you want to fetch related data like

    if there is any custom field Date is there in any object which call as date__c in soql so in terms of soql you can determine "date__c" as unique. If you try to fetch the related records by using any other word it will not help you for your findings.

    Hope It Would be helpful !

  • Adarsh

    Member
    April 2, 2018 at 6:54 am

    Hi Archit,

    Thanks, it was very much informative and helpful.

Log In to reply.

Popular Salesforce Blogs