Ggtkuk

Why do Australian milk farmers need to protest supermarkets' milk price?

How to read the value of this capacitor?

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

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

Could the Saturn V actually have launched astronauts around Venus?

It's a yearly task, alright

Opacity of an object in 2.8

Time travel from stationary position?

How to simplify this time periods definition interface?

If curse and magic is two sides of the same coin, why the former is forbidden?

Sailing the cryptic seas

Unexpected result from ArcLength

How to write cleanly even if my character uses expletive language?

How to deal with taxi scam when on vacation?

Recruiter wants very extensive technical details about all of my previous work

Brexit - No Deal Rejection

compactness of a set where am I going wrong

Is it true that good novels will automatically sell themselves on Amazon (and so on) and there is no need for one to waste time promoting?

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

Why one should not leave fingerprints on bulbs and plugs?

A sequence that has integer values for prime indexes only:

How to make healing in an exploration game interesting

Are all passive ability checks floors for active ability checks?

Existence of subset with given Hausdorff dimension

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

4

1

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 5 hours ago

ArthleteArthlete

981717

add a comment | 

4

1

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 5 hours ago

ArthleteArthlete

981717

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 5 hours ago

ArthleteArthlete

981717

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 5 hours ago

ArthleteArthlete

981717

share|improve this question

asked 5 hours ago

ArthleteArthlete

981717

asked 5 hours ago

ArthleteArthlete

981717

asked 5 hours ago

ArthleteArthlete

981717

2 Answers
2

active

oldest

votes

3

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 5 hours ago

sfdcfoxsfdcfox

259k12204447

• 
  
  
  

  
  

  
  
  
  
  
  

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

  
  
  
  

add a comment | 

5

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 5 hours 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

3

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 5 hours ago

sfdcfoxsfdcfox

259k12204447

• 
  
  
  

  
  

  
  
  
  
  
  

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

  
  
  
  

add a comment | 

3

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 5 hours ago

sfdcfoxsfdcfox

259k12204447

• 
  
  
  

  
  

  
  
  
  
  
  

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

sfdcfoxsfdcfox

259k12204447

answered 5 hours ago

sfdcfoxsfdcfox

259k12204447

answered 5 hours ago

sfdcfoxsfdcfox

259k12204447

5

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 5 hours ago

David ReedDavid Reed

37.3k82255

add a comment | 

5

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 5 hours 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 5 hours 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 5 hours ago

David ReedDavid Reed

37.3k82255

answered 5 hours ago

David ReedDavid Reed

37.3k82255

answered 5 hours ago

David ReedDavid Reed

37.3k82255