Kdtyjb

May I change the held type in a std::variant from within a call to std::visit

A sequence that has integer values for prime indexes only:

What's causing this power spike in STM32 low power mode

Hacking a Safe Lock after 3 tries

In a future war, an old lady is trying to raise a boy but one of the weapons has made everyone deaf

Opacity of an object in 2.8

A link redirect to http instead of https: how critical is it?

Logical notation

Is it normal that my co-workers at a fitness company criticize my food choices?

Are all passive ability checks floors for active ability checks?

Why do passenger jet manufacturers design their planes with stall prevention systems?

What are substitutions for coconut in curry?

How to terminate ping <dest> &

How Could an Airship Be Repaired Mid-Flight

Is it possible to upcast ritual spells?

How to simplify this time periods definition interface?

Should we release the security issues we found in our product as CVE or we can just update those on weekly release notes?

Unexpected result from ArcLength

The difference between「N分で」and「後N分で」

Audio processing. Is it possible to directly access the decoded audio data going into the analog input of a computer

How to read the value of this capacitor?

Do I need to be arrogant to get ahead?

Fibers of the morphism from the free Heyting algebra to the free Boolean algebra

What exactly is this small puffer fish doing and how did it manage to accomplish such a feat?

SOQL: Populate a Literal List in WHERE IN Clause

Split a single field into 2 columns for a VF pageSOQL query problem, need assistanceSOQL query with Dataloader using List Literal in WHERE ClauseNot able to escape quote in visualforce page?Where do I find this related list API name to access in query?System.QueryException: unexpected token: :SOQL - Use the size of the list of inner child query in the WHERE clauseCheck field's data availability in WHERE clauseDatetime in WHERE clauseSOQL WHERE IN query

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.

soql list where

share|improve this question

asked 36 mins ago

ArthleteArthlete

976717

add a comment | 

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.

soql list where

share|improve this question

asked 36 mins ago

ArthleteArthlete

976717

add a comment | 

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

asked 36 mins ago

ArthleteArthlete

976717

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 question

asked 36 mins ago

ArthleteArthlete

976717

share|improve this question

asked 36 mins ago

ArthleteArthlete

976717

asked 36 mins ago

ArthleteArthlete

976717

asked 36 mins ago

ArthleteArthlete

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

answered 25 mins ago

sfdcfoxsfdcfox

259k12204447

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you, that's what I was looking for!
  
  – Arthlete
  25 mins 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
  20 mins ago
  

  
  
  
  

add a comment | 

3

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

answered 22 mins ago

David ReedDavid Reed

37.3k82255

add a comment | 

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

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

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

Name

Email

Required, but never shown

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

answered 25 mins ago

sfdcfoxsfdcfox

259k12204447

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you, that's what I was looking for!
  
  – Arthlete
  25 mins 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
  20 mins ago
  

  
  
  
  

add a comment | 

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

answered 25 mins ago

sfdcfoxsfdcfox

259k12204447

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you, that's what I was looking for!
  
  – Arthlete
  25 mins 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
  20 mins ago
  

  
  
  
  

add a comment | 

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

answered 25 mins ago

sfdcfoxsfdcfox

259k12204447

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

answered 25 mins ago

sfdcfoxsfdcfox

259k12204447

answered 25 mins ago

sfdcfoxsfdcfox

259k12204447

answered 25 mins ago

sfdcfoxsfdcfox

259k12204447

3

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

answered 22 mins ago

David ReedDavid Reed

37.3k82255

add a comment | 

3

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

answered 22 mins ago

David ReedDavid Reed

37.3k82255

add a comment | 

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

answered 22 mins ago

David ReedDavid Reed

37.3k82255

... 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]

share|improve this answer

answered 22 mins ago

David ReedDavid Reed

37.3k82255

answered 22 mins ago

David ReedDavid Reed

37.3k82255

answered 22 mins ago

David ReedDavid Reed

37.3k82255