Gdtyjr

Who is flying the vertibirds?

Why is the BSI not using powers of two?

How can you use ICE tables to solve multiple coupled equilibria?

Professor being mistaken for a grad student

What approach do we need to follow for projects without a test environment?

Brexit - No Deal Rejection

Co-worker team leader wants to inject his friend's awful software into our development. What should I say to our common boss?

how to write formula in word in latex

Do the common programs (for example: "ls", "cat") in Linux and BSD come from the same source code?

PTIJ: Who should I vote for? (21st Knesset Edition)

Official degrees of earth’s rotation per day

Could the Saturn V actually have launched astronauts around Venus?

How difficult is it to simply disable/disengage the MCAS on Boeing 737 Max 8 & 9 Aircraft?

Why doesn't the EU now just force the UK to choose between referendum and no-deal?

how to draw discrete time diagram in tikz

Do I need to be arrogant to get ahead?

Why one should not leave fingerprints on bulbs and plugs?

Opacity of an object in 2.8

If I can solve Sudoku can I solve Travelling Salesman Problem(TSP)? If yes, how?

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

Can a druid choose the size of its wild shape beast?

Python if-else code style for reduced code

What is the rarity of this homebrew magic staff?

Do I need life insurance if I can cover my own funeral costs?

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 54 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 54 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 54 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 54 mins ago

ArthleteArthlete

976717

share|improve this question

asked 54 mins ago

ArthleteArthlete

976717

asked 54 mins ago

ArthleteArthlete

976717

asked 54 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 43 mins ago

sfdcfoxsfdcfox

259k12204447

• 
  
  
  

  
  

  
  
  
  
  
  

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

sfdcfoxsfdcfox

259k12204447

• 
  
  
  

  
  

  
  
  
  
  
  

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

sfdcfoxsfdcfox

259k12204447

• 
  
  
  

  
  

  
  
  
  
  
  

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

sfdcfoxsfdcfox

259k12204447

answered 43 mins ago

sfdcfoxsfdcfox

259k12204447

answered 43 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 40 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 40 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 40 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 40 mins ago

David ReedDavid Reed

37.3k82255

answered 40 mins ago

David ReedDavid Reed

37.3k82255

answered 40 mins ago

David ReedDavid Reed

37.3k82255