SOQL: Populate a Literal List in WHERE IN Clause












3















I need to query for an object based on 2 string variables. The first one is a constant but the second one gets passed to the class constructor.



So in the end I want to achieve something like this:



public class MyClass {
private final String STRING_ONE = 'STRING ONE';

public MyClass(String stringTwo) {
List<Object__c> objects = [
SELECT Id
FROM Object__c
WHERE Name IN :{STRING_ONE, stringTwo}
];
}
}


This is the part that I can't get the syntax right of WHERE Name IN :{STRING_ONE, stringTwo}. I know I've seen this somewhere but can't find it on google.










share|improve this question



























    3















    I need to query for an object based on 2 string variables. The first one is a constant but the second one gets passed to the class constructor.



    So in the end I want to achieve something like this:



    public class MyClass {
    private final String STRING_ONE = 'STRING ONE';

    public MyClass(String stringTwo) {
    List<Object__c> objects = [
    SELECT Id
    FROM Object__c
    WHERE Name IN :{STRING_ONE, stringTwo}
    ];
    }
    }


    This is the part that I can't get the syntax right of WHERE Name IN :{STRING_ONE, stringTwo}. I know I've seen this somewhere but can't find it on google.










    share|improve this question

























      3












      3








      3








      I need to query for an object based on 2 string variables. The first one is a constant but the second one gets passed to the class constructor.



      So in the end I want to achieve something like this:



      public class MyClass {
      private final String STRING_ONE = 'STRING ONE';

      public MyClass(String stringTwo) {
      List<Object__c> objects = [
      SELECT Id
      FROM Object__c
      WHERE Name IN :{STRING_ONE, stringTwo}
      ];
      }
      }


      This is the part that I can't get the syntax right of WHERE Name IN :{STRING_ONE, stringTwo}. I know I've seen this somewhere but can't find it on google.










      share|improve this question














      I need to query for an object based on 2 string variables. The first one is a constant but the second one gets passed to the class constructor.



      So in the end I want to achieve something like this:



      public class MyClass {
      private final String STRING_ONE = 'STRING ONE';

      public MyClass(String stringTwo) {
      List<Object__c> objects = [
      SELECT Id
      FROM Object__c
      WHERE Name IN :{STRING_ONE, stringTwo}
      ];
      }
      }


      This is the part that I can't get the syntax right of WHERE Name IN :{STRING_ONE, stringTwo}. I know I've seen this somewhere but can't find it on google.







      soql list where






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked 3 hours ago









      ArthleteArthlete

      976717




      976717






















          2 Answers
          2






          active

          oldest

          votes


















          2














          It's like normal SOQL, but you put the colons before each item in the list:



          public class MyClass {
          private final String STRING_ONE = 'STRING ONE';

          public MyClass(String stringTwo) {
          List<Object__c> objects = [
          SELECT Id
          FROM Object__c
          WHERE Name IN (:STRING_ONE, :stringTwo)
          ];
          }
          }





          share|improve this answer
























          • Thank you, that's what I was looking for!

            – Arthlete
            2 hours ago






          • 1





            @Arthlete You're welcome! I know it's pretty unusual syntax, so glad you asked so people could find the answer to this.

            – sfdcfox
            2 hours ago



















          4














          You can supply string variable values using Apex binding. When you're not using Dynamic SOQL, as you're not here, you can even use complex Apex expressions in the bind. The following options are all legit.



          ... WHERE Name IN (:STRING_ONE, :stringTwo)

          ... WHERE Name IN :new List<String>{STRING_ONE, stringTwo}

          ... WHERE Name = :STRING_ONE OR Name = :stringTwo

          List<String> names = new List<String>{STRING_ONE, stringTwo};
          [SELECT ... FROM Account WHERE Name IN :names]


          Dynamic SOQL doesn't allow complex bind expressions, so creating new Lists and similar are verboten in that context.






          share|improve this answer























            Your Answer








            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "459"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: false,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: null,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f254106%2fsoql-populate-a-literal-list-in-where-in-clause%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            2














            It's like normal SOQL, but you put the colons before each item in the list:



            public class MyClass {
            private final String STRING_ONE = 'STRING ONE';

            public MyClass(String stringTwo) {
            List<Object__c> objects = [
            SELECT Id
            FROM Object__c
            WHERE Name IN (:STRING_ONE, :stringTwo)
            ];
            }
            }





            share|improve this answer
























            • Thank you, that's what I was looking for!

              – Arthlete
              2 hours ago






            • 1





              @Arthlete You're welcome! I know it's pretty unusual syntax, so glad you asked so people could find the answer to this.

              – sfdcfox
              2 hours ago
















            2














            It's like normal SOQL, but you put the colons before each item in the list:



            public class MyClass {
            private final String STRING_ONE = 'STRING ONE';

            public MyClass(String stringTwo) {
            List<Object__c> objects = [
            SELECT Id
            FROM Object__c
            WHERE Name IN (:STRING_ONE, :stringTwo)
            ];
            }
            }





            share|improve this answer
























            • Thank you, that's what I was looking for!

              – Arthlete
              2 hours ago






            • 1





              @Arthlete You're welcome! I know it's pretty unusual syntax, so glad you asked so people could find the answer to this.

              – sfdcfox
              2 hours ago














            2












            2








            2







            It's like normal SOQL, but you put the colons before each item in the list:



            public class MyClass {
            private final String STRING_ONE = 'STRING ONE';

            public MyClass(String stringTwo) {
            List<Object__c> objects = [
            SELECT Id
            FROM Object__c
            WHERE Name IN (:STRING_ONE, :stringTwo)
            ];
            }
            }





            share|improve this answer













            It's like normal SOQL, but you put the colons before each item in the list:



            public class MyClass {
            private final String STRING_ONE = 'STRING ONE';

            public MyClass(String stringTwo) {
            List<Object__c> objects = [
            SELECT Id
            FROM Object__c
            WHERE Name IN (:STRING_ONE, :stringTwo)
            ];
            }
            }






            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered 2 hours ago









            sfdcfoxsfdcfox

            259k12204447




            259k12204447













            • Thank you, that's what I was looking for!

              – Arthlete
              2 hours ago






            • 1





              @Arthlete You're welcome! I know it's pretty unusual syntax, so glad you asked so people could find the answer to this.

              – sfdcfox
              2 hours ago



















            • Thank you, that's what I was looking for!

              – Arthlete
              2 hours ago






            • 1





              @Arthlete You're welcome! I know it's pretty unusual syntax, so glad you asked so people could find the answer to this.

              – sfdcfox
              2 hours ago

















            Thank you, that's what I was looking for!

            – Arthlete
            2 hours ago





            Thank you, that's what I was looking for!

            – Arthlete
            2 hours ago




            1




            1





            @Arthlete You're welcome! I know it's pretty unusual syntax, so glad you asked so people could find the answer to this.

            – sfdcfox
            2 hours ago





            @Arthlete You're welcome! I know it's pretty unusual syntax, so glad you asked so people could find the answer to this.

            – sfdcfox
            2 hours ago













            4














            You can supply string variable values using Apex binding. When you're not using Dynamic SOQL, as you're not here, you can even use complex Apex expressions in the bind. The following options are all legit.



            ... WHERE Name IN (:STRING_ONE, :stringTwo)

            ... WHERE Name IN :new List<String>{STRING_ONE, stringTwo}

            ... WHERE Name = :STRING_ONE OR Name = :stringTwo

            List<String> names = new List<String>{STRING_ONE, stringTwo};
            [SELECT ... FROM Account WHERE Name IN :names]


            Dynamic SOQL doesn't allow complex bind expressions, so creating new Lists and similar are verboten in that context.






            share|improve this answer




























              4














              You can supply string variable values using Apex binding. When you're not using Dynamic SOQL, as you're not here, you can even use complex Apex expressions in the bind. The following options are all legit.



              ... WHERE Name IN (:STRING_ONE, :stringTwo)

              ... WHERE Name IN :new List<String>{STRING_ONE, stringTwo}

              ... WHERE Name = :STRING_ONE OR Name = :stringTwo

              List<String> names = new List<String>{STRING_ONE, stringTwo};
              [SELECT ... FROM Account WHERE Name IN :names]


              Dynamic SOQL doesn't allow complex bind expressions, so creating new Lists and similar are verboten in that context.






              share|improve this answer


























                4












                4








                4







                You can supply string variable values using Apex binding. When you're not using Dynamic SOQL, as you're not here, you can even use complex Apex expressions in the bind. The following options are all legit.



                ... WHERE Name IN (:STRING_ONE, :stringTwo)

                ... WHERE Name IN :new List<String>{STRING_ONE, stringTwo}

                ... WHERE Name = :STRING_ONE OR Name = :stringTwo

                List<String> names = new List<String>{STRING_ONE, stringTwo};
                [SELECT ... FROM Account WHERE Name IN :names]


                Dynamic SOQL doesn't allow complex bind expressions, so creating new Lists and similar are verboten in that context.






                share|improve this answer













                You can supply string variable values using Apex binding. When you're not using Dynamic SOQL, as you're not here, you can even use complex Apex expressions in the bind. The following options are all legit.



                ... WHERE Name IN (:STRING_ONE, :stringTwo)

                ... WHERE Name IN :new List<String>{STRING_ONE, stringTwo}

                ... WHERE Name = :STRING_ONE OR Name = :stringTwo

                List<String> names = new List<String>{STRING_ONE, stringTwo};
                [SELECT ... FROM Account WHERE Name IN :names]


                Dynamic SOQL doesn't allow complex bind expressions, so creating new Lists and similar are verboten in that context.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 2 hours ago









                David ReedDavid Reed

                37.3k82255




                37.3k82255






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Salesforce Stack Exchange!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f254106%2fsoql-populate-a-literal-list-in-where-in-clause%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    A CLEAN and SIMPLE way to add appendices to Table of Contents and bookmarks

                    Calculate evaluation metrics using cross_val_predict sklearn

                    Insert data from modal to MySQL (multiple modal on website)