How to Pass a Parameter into SOQL Query?
Clash Royale CLAN TAG#URR8PPP
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;
up vote
2
down vote
favorite
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 |Â
up vote
2
down vote
favorite
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 at 9:16
Apologies, I added the Error
â Thomas Pete
Aug 25 at 9:20
add a comment |Â
up vote
2
down vote
favorite
up vote
2
down vote
favorite
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
edited Aug 25 at 9:19
asked Aug 25 at 9:10
Thomas Pete
265
265
What is the error you are getting. Help us help you
â Eric
Aug 25 at 9:16
Apologies, I added the Error
â Thomas Pete
Aug 25 at 9:20
add a comment |Â
What is the error you are getting. Help us help you
â Eric
Aug 25 at 9:16
Apologies, I added the Error
â Thomas Pete
Aug 25 at 9:20
What is the error you are getting. Help us help you
â Eric
Aug 25 at 9:16
What is the error you are getting. Help us help you
â Eric
Aug 25 at 9:16
Apologies, I added the Error
â Thomas Pete
Aug 25 at 9:20
Apologies, I added the Error
â Thomas Pete
Aug 25 at 9:20
add a comment |Â
1 Answer
1
active
oldest
votes
up vote
5
down vote
accepted
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 at 9:22
add a comment |Â
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
5
down vote
accepted
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 at 9:22
add a comment |Â
up vote
5
down vote
accepted
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 at 9:22
add a comment |Â
up vote
5
down vote
accepted
up vote
5
down vote
accepted
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 at 9:23
answered Aug 25 at 9:17
sanket kumar
1,289117
1,289117
Thanks A Lot!! That Solved It. How to mark this as Best Answer?
â Thomas Pete
Aug 25 at 9:22
add a comment |Â
Thanks A Lot!! That Solved It. How to mark this as Best Answer?
â Thomas Pete
Aug 25 at 9:22
Thanks A Lot!! That Solved It. How to mark this as Best Answer?
â Thomas Pete
Aug 25 at 9:22
Thanks A Lot!! That Solved It. How to mark this as Best Answer?
â Thomas Pete
Aug 25 at 9:22
add a comment |Â
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
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
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
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
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
What is the error you are getting. Help us help you
â Eric
Aug 25 at 9:16
Apologies, I added the Error
â Thomas Pete
Aug 25 at 9:20