Yhyjyk

Professor being mistaken for a grad student

Is a party consisting of only a bard, a cleric, and a warlock functional long-term?

Happy pi day, everyone!

Brexit - No Deal Rejection

Science-fiction short story where space navy wanted hospital ships and settlers had guns mounted everywhere

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

Use void Apex method in Lightning Web Component

how to write formula in word in latex

How to use deus ex machina safely?

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

What is the rarity of this homebrew magic staff?

Can I use USB data pins as power source

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

Does Mathematica reuse previous computations?

Could the Saturn V actually have launched astronauts around Venus?

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

Declaring defaulted assignment operator as constexpr: which compiler is right?

how to draw discrete time diagram in tikz

Min function accepting varying number of arguments in C++17

Define, (actually define) the "stability" and "energy" of a compound

How to explain that I do not want to visit a country due to personal safety concern?

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

Existence of subset with given Hausdorff dimension

What is this large pipe coming out of my roof?

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 1 hour 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 1 hour 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 1 hour 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 1 hour ago

ArthleteArthlete

976717

share|improve this question

asked 1 hour ago

ArthleteArthlete

976717

asked 1 hour ago

ArthleteArthlete

976717

asked 1 hour 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 49 mins ago

sfdcfoxsfdcfox

259k12204447

• 
  
  
  

  
  

  
  
  
  
  
  

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

  
  
  
  

add a comment | 

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

answered 46 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 49 mins ago

sfdcfoxsfdcfox

259k12204447

• 
  
  
  

  
  

  
  
  
  
  
  

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

sfdcfoxsfdcfox

259k12204447

• 
  
  
  

  
  

  
  
  
  
  
  

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

sfdcfoxsfdcfox

259k12204447

answered 49 mins ago

sfdcfoxsfdcfox

259k12204447

answered 49 mins ago

sfdcfoxsfdcfox

259k12204447

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

answered 46 mins ago

David ReedDavid Reed

37.3k82255

add a comment | 

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

answered 46 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 46 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 46 mins ago

David ReedDavid Reed

37.3k82255

answered 46 mins ago

David ReedDavid Reed

37.3k82255

answered 46 mins ago

David ReedDavid Reed

37.3k82255