How to Pass a Parameter into SOQL Query?
I have a SOQL query in my server side controller Like
SELECT Id,PDCN__r.Id,PDCN__r.Name,PDCN__r.Brand_Trademark_Name__c,PDCN__r.Package_Standard_Name__c
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = 'aBmq00000008UIUCA2'
ORDER BY createdDate DESC
This Query Returns results when I specify PDCN_Group__c = 'aBmq00000008UIUCA2'. Now I have a method which takes a parameter groupId, when I write that groupId in SOQL Query I get Error-:
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = '+groupId+'
^
ERROR at Row:2:Column:70
invalid ID field: +groupId+
public static list < PDCNGrpJunc__c > fetchJunction(String groupId)
System.debug('****groupId****'+groupId);
List < PDCNGrpJunc__c > objJuncList = new List < PDCNGrpJunc__c > ();
List < PDCNGrpJunc__c > objJunc = [SELECT Id,PDCN__r.Id,PDCN__r.Name,PDCN__r.Brand_Trademark_Name__c,PDCN__r.Package_Standard_Name__c
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = '+groupId+'
ORDER BY createdDate DESC ];
// play for loop on objJunc and add each Junction to objJuncList List.
for (PDCNGrpJunc__c c: objJunc)
objJuncList.add(c);
// return the List of Junctions
return objJuncList;
Could Someone Tell Me what I might be doing Wrong and How to pass the parameter into SOQL Query. Thanks!!
apex soql
add a comment |
I have a SOQL query in my server side controller Like
SELECT Id,PDCN__r.Id,PDCN__r.Name,PDCN__r.Brand_Trademark_Name__c,PDCN__r.Package_Standard_Name__c
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = 'aBmq00000008UIUCA2'
ORDER BY createdDate DESC
This Query Returns results when I specify PDCN_Group__c = 'aBmq00000008UIUCA2'. Now I have a method which takes a parameter groupId, when I write that groupId in SOQL Query I get Error-:
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = '+groupId+'
^
ERROR at Row:2:Column:70
invalid ID field: +groupId+
public static list < PDCNGrpJunc__c > fetchJunction(String groupId)
System.debug('****groupId****'+groupId);
List < PDCNGrpJunc__c > objJuncList = new List < PDCNGrpJunc__c > ();
List < PDCNGrpJunc__c > objJunc = [SELECT Id,PDCN__r.Id,PDCN__r.Name,PDCN__r.Brand_Trademark_Name__c,PDCN__r.Package_Standard_Name__c
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = '+groupId+'
ORDER BY createdDate DESC ];
// play for loop on objJunc and add each Junction to objJuncList List.
for (PDCNGrpJunc__c c: objJunc)
objJuncList.add(c);
// return the List of Junctions
return objJuncList;
Could Someone Tell Me what I might be doing Wrong and How to pass the parameter into SOQL Query. Thanks!!
apex soql
What is the error you are getting. Help us help you
– Eric
Aug 25 '18 at 9:16
Apologies, I added the Error
– Thomas Pete
Aug 25 '18 at 9:20
add a comment |
I have a SOQL query in my server side controller Like
SELECT Id,PDCN__r.Id,PDCN__r.Name,PDCN__r.Brand_Trademark_Name__c,PDCN__r.Package_Standard_Name__c
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = 'aBmq00000008UIUCA2'
ORDER BY createdDate DESC
This Query Returns results when I specify PDCN_Group__c = 'aBmq00000008UIUCA2'. Now I have a method which takes a parameter groupId, when I write that groupId in SOQL Query I get Error-:
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = '+groupId+'
^
ERROR at Row:2:Column:70
invalid ID field: +groupId+
public static list < PDCNGrpJunc__c > fetchJunction(String groupId)
System.debug('****groupId****'+groupId);
List < PDCNGrpJunc__c > objJuncList = new List < PDCNGrpJunc__c > ();
List < PDCNGrpJunc__c > objJunc = [SELECT Id,PDCN__r.Id,PDCN__r.Name,PDCN__r.Brand_Trademark_Name__c,PDCN__r.Package_Standard_Name__c
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = '+groupId+'
ORDER BY createdDate DESC ];
// play for loop on objJunc and add each Junction to objJuncList List.
for (PDCNGrpJunc__c c: objJunc)
objJuncList.add(c);
// return the List of Junctions
return objJuncList;
Could Someone Tell Me what I might be doing Wrong and How to pass the parameter into SOQL Query. Thanks!!
apex soql
I have a SOQL query in my server side controller Like
SELECT Id,PDCN__r.Id,PDCN__r.Name,PDCN__r.Brand_Trademark_Name__c,PDCN__r.Package_Standard_Name__c
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = 'aBmq00000008UIUCA2'
ORDER BY createdDate DESC
This Query Returns results when I specify PDCN_Group__c = 'aBmq00000008UIUCA2'. Now I have a method which takes a parameter groupId, when I write that groupId in SOQL Query I get Error-:
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = '+groupId+'
^
ERROR at Row:2:Column:70
invalid ID field: +groupId+
public static list < PDCNGrpJunc__c > fetchJunction(String groupId)
System.debug('****groupId****'+groupId);
List < PDCNGrpJunc__c > objJuncList = new List < PDCNGrpJunc__c > ();
List < PDCNGrpJunc__c > objJunc = [SELECT Id,PDCN__r.Id,PDCN__r.Name,PDCN__r.Brand_Trademark_Name__c,PDCN__r.Package_Standard_Name__c
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = '+groupId+'
ORDER BY createdDate DESC ];
// play for loop on objJunc and add each Junction to objJuncList List.
for (PDCNGrpJunc__c c: objJunc)
objJuncList.add(c);
// return the List of Junctions
return objJuncList;
Could Someone Tell Me what I might be doing Wrong and How to pass the parameter into SOQL Query. Thanks!!
apex soql
apex soql
edited Aug 25 '18 at 9:19
Thomas Pete
asked Aug 25 '18 at 9:10
Thomas PeteThomas Pete
285
285
What is the error you are getting. Help us help you
– Eric
Aug 25 '18 at 9:16
Apologies, I added the Error
– Thomas Pete
Aug 25 '18 at 9:20
add a comment |
What is the error you are getting. Help us help you
– Eric
Aug 25 '18 at 9:16
Apologies, I added the Error
– Thomas Pete
Aug 25 '18 at 9:20
What is the error you are getting. Help us help you
– Eric
Aug 25 '18 at 9:16
What is the error you are getting. Help us help you
– Eric
Aug 25 '18 at 9:16
Apologies, I added the Error
– Thomas Pete
Aug 25 '18 at 9:20
Apologies, I added the Error
– Thomas Pete
Aug 25 '18 at 9:20
add a comment |
1 Answer
1
active
oldest
votes
public static list < PDCNGrpJunc__c > fetchJunction(String groupId)
System.debug('****groupId****'+groupId);
List < PDCNGrpJunc__c > objJuncList = new List < PDCNGrpJunc__c > ();
List < PDCNGrpJunc__c > objJunc = [SELECT Id,PDCN__r.Id,PDCN__r.Name,PDCN__r.Brand_Trademark_Name__c,PDCN__r.Package_Standard_Name__c
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = :groupId
ORDER BY createdDate DESC ];
// play for loop on objJunc and add each Junction to objJuncList List.
for (PDCNGrpJunc__c c: objJunc)
objJuncList.add(c);
// return the List of Junctions
return objJuncList;
You have to use parameters as PDCN_Group__c = :groupId.
Accessing Variables in SOQL Queries
SOQL statements in Apex can reference Apex code variables and
expressions if they are preceded by a colon (:). The use of a local
variable within a SOQL statement is called a bind.
This example shows how to use the targetDepartment variable in the WHERE clause.
String targetDepartment = 'Wingo';
Contact techContacts = [SELECT FirstName,LastName
FROM Contact WHERE Department=:targetDepartment];
Thanks A Lot!! That Solved It. How to mark this as Best Answer?
– Thomas Pete
Aug 25 '18 at 9:22
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
);
);
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f230115%2fhow-to-pass-a-parameter-into-soql-query%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
public static list < PDCNGrpJunc__c > fetchJunction(String groupId)
System.debug('****groupId****'+groupId);
List < PDCNGrpJunc__c > objJuncList = new List < PDCNGrpJunc__c > ();
List < PDCNGrpJunc__c > objJunc = [SELECT Id,PDCN__r.Id,PDCN__r.Name,PDCN__r.Brand_Trademark_Name__c,PDCN__r.Package_Standard_Name__c
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = :groupId
ORDER BY createdDate DESC ];
// play for loop on objJunc and add each Junction to objJuncList List.
for (PDCNGrpJunc__c c: objJunc)
objJuncList.add(c);
// return the List of Junctions
return objJuncList;
You have to use parameters as PDCN_Group__c = :groupId.
Accessing Variables in SOQL Queries
SOQL statements in Apex can reference Apex code variables and
expressions if they are preceded by a colon (:). The use of a local
variable within a SOQL statement is called a bind.
This example shows how to use the targetDepartment variable in the WHERE clause.
String targetDepartment = 'Wingo';
Contact techContacts = [SELECT FirstName,LastName
FROM Contact WHERE Department=:targetDepartment];
Thanks A Lot!! That Solved It. How to mark this as Best Answer?
– Thomas Pete
Aug 25 '18 at 9:22
add a comment |
public static list < PDCNGrpJunc__c > fetchJunction(String groupId)
System.debug('****groupId****'+groupId);
List < PDCNGrpJunc__c > objJuncList = new List < PDCNGrpJunc__c > ();
List < PDCNGrpJunc__c > objJunc = [SELECT Id,PDCN__r.Id,PDCN__r.Name,PDCN__r.Brand_Trademark_Name__c,PDCN__r.Package_Standard_Name__c
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = :groupId
ORDER BY createdDate DESC ];
// play for loop on objJunc and add each Junction to objJuncList List.
for (PDCNGrpJunc__c c: objJunc)
objJuncList.add(c);
// return the List of Junctions
return objJuncList;
You have to use parameters as PDCN_Group__c = :groupId.
Accessing Variables in SOQL Queries
SOQL statements in Apex can reference Apex code variables and
expressions if they are preceded by a colon (:). The use of a local
variable within a SOQL statement is called a bind.
This example shows how to use the targetDepartment variable in the WHERE clause.
String targetDepartment = 'Wingo';
Contact techContacts = [SELECT FirstName,LastName
FROM Contact WHERE Department=:targetDepartment];
Thanks A Lot!! That Solved It. How to mark this as Best Answer?
– Thomas Pete
Aug 25 '18 at 9:22
add a comment |
public static list < PDCNGrpJunc__c > fetchJunction(String groupId)
System.debug('****groupId****'+groupId);
List < PDCNGrpJunc__c > objJuncList = new List < PDCNGrpJunc__c > ();
List < PDCNGrpJunc__c > objJunc = [SELECT Id,PDCN__r.Id,PDCN__r.Name,PDCN__r.Brand_Trademark_Name__c,PDCN__r.Package_Standard_Name__c
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = :groupId
ORDER BY createdDate DESC ];
// play for loop on objJunc and add each Junction to objJuncList List.
for (PDCNGrpJunc__c c: objJunc)
objJuncList.add(c);
// return the List of Junctions
return objJuncList;
You have to use parameters as PDCN_Group__c = :groupId.
Accessing Variables in SOQL Queries
SOQL statements in Apex can reference Apex code variables and
expressions if they are preceded by a colon (:). The use of a local
variable within a SOQL statement is called a bind.
This example shows how to use the targetDepartment variable in the WHERE clause.
String targetDepartment = 'Wingo';
Contact techContacts = [SELECT FirstName,LastName
FROM Contact WHERE Department=:targetDepartment];
public static list < PDCNGrpJunc__c > fetchJunction(String groupId)
System.debug('****groupId****'+groupId);
List < PDCNGrpJunc__c > objJuncList = new List < PDCNGrpJunc__c > ();
List < PDCNGrpJunc__c > objJunc = [SELECT Id,PDCN__r.Id,PDCN__r.Name,PDCN__r.Brand_Trademark_Name__c,PDCN__r.Package_Standard_Name__c
FROM PDCNGrpJunc__c WHERE PDCN_Group__c = :groupId
ORDER BY createdDate DESC ];
// play for loop on objJunc and add each Junction to objJuncList List.
for (PDCNGrpJunc__c c: objJunc)
objJuncList.add(c);
// return the List of Junctions
return objJuncList;
You have to use parameters as PDCN_Group__c = :groupId.
Accessing Variables in SOQL Queries
SOQL statements in Apex can reference Apex code variables and
expressions if they are preceded by a colon (:). The use of a local
variable within a SOQL statement is called a bind.
This example shows how to use the targetDepartment variable in the WHERE clause.
String targetDepartment = 'Wingo';
Contact techContacts = [SELECT FirstName,LastName
FROM Contact WHERE Department=:targetDepartment];
edited Aug 25 '18 at 9:23
answered Aug 25 '18 at 9:17
sanket kumarsanket kumar
2,5352322
2,5352322
Thanks A Lot!! That Solved It. How to mark this as Best Answer?
– Thomas Pete
Aug 25 '18 at 9:22
add a comment |
Thanks A Lot!! That Solved It. How to mark this as Best Answer?
– Thomas Pete
Aug 25 '18 at 9:22
Thanks A Lot!! That Solved It. How to mark this as Best Answer?
– Thomas Pete
Aug 25 '18 at 9:22
Thanks A Lot!! That Solved It. How to mark this as Best Answer?
– Thomas Pete
Aug 25 '18 at 9:22
add a comment |
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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.
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f230115%2fhow-to-pass-a-parameter-into-soql-query%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
What is the error you are getting. Help us help you
– Eric
Aug 25 '18 at 9:16
Apologies, I added the Error
– Thomas Pete
Aug 25 '18 at 9:20