Questions tagged [dynamic-soql]
Dynamic SOQL refers to the creation of a SOQL string at runtime with Apex code.
399
questions
0
votes
1answer
19 views
SOQL injection issue on source scanner report
I am getting SOQL injection vulnerability on source scanner report. Please check one of the issue below. I tried string.escapeSingleQuotes() on query string. It is helping with removing this issue in ...
0
votes
1answer
43 views
How to use a SOQL query for Sobjects like Passing Sobject as Variable inside the quey
I'm trying to write a SOQL query, But this query have to work for all object in one query. I want to use same query but I want to change object name dynamically
public class Test {
public static ...
0
votes
1answer
24 views
System.QueryException: unexpected token: accountid
I run the following code in the scheduled class:
List<String> sObjFields = DynamicSOQL.getFields('Contact');
String query2 = 'SELECT ' + sObjFields + ' FROM Contact';
...
0
votes
1answer
25 views
Relationship query not returning any records
I have a batch class, in that I'm doing a dynamic relationship query my code is as follows
global class RBS_DeleteScheduleBillRunBatch implements Database.Batchable<sObject>{
global String ...
-2
votes
1answer
17 views
How to filter records on boolean field in Batch apex
Fields are as follows:-
Assistantname which is text
Level__c is a picklist field
prestigious_contact__c is a boolean field
When I run this query I keep getting Unexpected Token :-'&&' error ...
0
votes
0answers
12 views
Dynamic Soql for Parent record metadata [duplicate]
public static List<Sobject> Soql (String ObjectName, List<String> apiNames, Set<String> IdsToQuery )
{
String query;
String SobjectApiName = objectName;
...
0
votes
1answer
25 views
How to solve this: Multiple IN condition in SOQL - System.QueryException: Only variable references are allowed in dynamic SOQL/SOSL
Hi am getting an following error while running dynamic soql. how to over come this when we use multiple IN condtion in soql query dynamically
code:
String docid = 'hi asma US6775512356';
...
1
vote
1answer
24 views
SOQL Query for all Fields on Object and filter based on certain types
I am looking to make dynamic queries, but I want to avoid compound fields in the query. Is there any way to check if the fields is a compound or overall not updateable?
public List<Sobject> ...
1
vote
1answer
39 views
Dynamic comparison of Profile id and userid fails in trigger
How do i correctly assign the userid and profileid to make a dynamic comparison. ?
// if i hardcode the owner's profileid and userid the IF gets evaluated to true, however if i dynamically compare ...
1
vote
1answer
45 views
How to query multiple object records without using soql within a for loop
I have a
Map<String, String> objectNameWithQueryString;
objectNameWithQueryString consists of 'ObjectAPIName' as the key and a 'soql query string as the value'.
My requirement is to perform ...
-2
votes
1answer
34 views
Is it possible to pass string of ids in Where IN dynamic Soql the dynamic part should accept Set id's and Lis id's [duplicate]
I have a dynamic soql in where I pass a string of ids in the WHERE IN clause this thtrows me a error:
expecting a colon, found '{'
My where clause is as follows:
WHERE Id IN {x0x0o000000000xXXX}...
1
vote
1answer
33 views
SOQL Query With Running Tally or Running Totals
I have a Payments object with dates and corresponding payments. We can query the data via SOQL in our API and the data looks like this:
SELECT Date, Amount FROM Payments WHERE CreatedDate>2019-01-...
2
votes
1answer
149 views
SOQL Query For To Get the Tabs of Particular Application
I want Soql Query for to get the tabs(Navigation Items) under one application (App) in salesforce. Suppose
Application Name is Data Management under these We have Database,Table,Column tabs as Custom ...
1
vote
1answer
68 views
SOQL Query Question?
If I have 3 parent records which each have 3 child records, and I have a list of the parent Ids off the child records so there would be 3 duplicates of 3 ids, would the SOQL for the parent object such ...
1
vote
2answers
148 views
Issue with dynamic SOQL Query
I have a following method which returns result based on the dynamic SOQL query. It was running fine until I added additional filter criteria where I am checking
Id != : ClosedCleanupId
Below is the ...
0
votes
1answer
85 views
How to pass set<id> dynamically to soql [duplicate]
I have a dynamic Soql in which I want to pass a set.
I get an error:
System.QueryException: expecting a colon, found '{'
Anonymous window
Set<Id> idSet = new Set<Id> ();
idSet.add('...
1
vote
1answer
37 views
Using LAST_N_Months:3 on CreatedDate in databaseQuery
I am setting a string qryDate = 'Last_N_Months:' + x - so it could be Last__Months:3.
I create a string qryString = 'SELECT field1 FROM Case WHERE CreatedDate=: qryDate'
and then do: result = ...
0
votes
1answer
25 views
Hot to get value of relationship dynamic Soql
I am using the following string in a dynamic soql:
SELECT id, name, orderdate__c, status__c, sold_To_Customer__r.id, sold_To_Customer__r.name, sold_To_Customer__r.customerreference__c, ...
1
vote
1answer
43 views
Is there a simple way to get the values of a list in a comma separated string all in once
I have a custom metadata type in which I want to add the API names of some custom fields to use the values in a Dynamic Soql. I used a list to get the values of the custom metadata fields. Is there a ...
1
vote
0answers
28 views
getDescribe Failing on Individual Object Id in Tests (Data Protection and Privacy)
My tests of methods using dynamic SOQL queries stopped working after enabling Data Protection and Privacy. I receive the following Exception:
FATAL_ERROR caused by: System.SObjectException: Field
...
1
vote
0answers
26 views
Dynamic query variable binding weird behaviour [duplicate]
I was going through something, and I stumbled upon this weird behaviour.
if(true){
String var = 'GenePoint';
}
Account acc = Database.query('Select ID,Name FROM Account where name=:var');
System....
1
vote
1answer
34 views
Trying to solve SOQL injection vulnerability
I have followed this official guide: SOQL Injection and came up with this:
String query = 'Select FirstName, LastName, Phone, Email From Contact Where ';
if(String.isNotBlank(fName)) {
...
-1
votes
2answers
35 views
get a record from obj A which is created after 3 minutes of another record in another object obj B
I am unable to form a SOQL query to get a record for below scenario.
Get a record from obj A which is created after 3 minutes of another record in another object obj B.
And also i want to get first ...
-3
votes
1answer
40 views
how to use like in where clause of SOQL for string
for below query like is not working
static final String OrgUrl=system.URL.getSalesforceBaseUrl().toExternalForm();
string sl=[select Identity_Provider__c from Org_Url__mdt where label
like:'%'+...
2
votes
1answer
49 views
Dynamic SOQL in Map with unknow sobject?
is it possible to do SOQL for the unknown object without for loop as below
string theQuery = 'Select '+fiels+' From'+obj_frm +whr;
Map <Id, object> oppMap = new Map<Id, object>((List<...
0
votes
0answers
14 views
How to stay within governor limits using COUNT_DISTINCT in Batch Apex Class? [duplicate]
So I have the following query that I am running through Batch Apex. I get the error:
System.LimitException: Too many query rows: 50001
I am receiving this because COUNT_DISTINCT() is subject to ...
-1
votes
1answer
28 views
Dynamic SOQL Where IN Clause
Will the Where in Clause work with a list of Objects? In this case the list holds a list of IDs. Or do I need to cast this List of Objects to the ID datatype before my Dynamic SOQL.
List<Object&...
3
votes
1answer
82 views
Dynamic SOQL and Object Permissions
I am hoping someone can shed some light on this for me. I am beyond confused.
I have Lightning Component that has some strings to build out a dynamic query in SOQL. It is against a custom object ...
2
votes
0answers
26 views
are binding variables in dynamic soql not required to be in scope at the time of query? [duplicate]
This code works even though contactID is not in scope at the time of the query. Can anyone explain what is going on here?
String query = 'SELECT Id FROM Contact WHERE ';
if (true) {
String ...
0
votes
1answer
127 views
compositeRequest Invalid reference specified. No value
I'm trying to execute the following compositeRequest but I'm getting the error.
{
"allOrNone": true,
"compositeRequest": [
{
"method": "GET",
"url": "/services/data/v46.0/query/?...
0
votes
0answers
127 views
How to Query Knowledge Article based on Data category and Topics in Salesforce?
I have a Knowledge Article Type = AT1 and Data Category = DC1, DC2 and DC3 and Topics T1 and T2. I am trying to retrive Knowledge Article Version in apex class which contains Article Type AT1 and Data ...
0
votes
0answers
237 views
How to build the dynamic search query for multiple conditions in lightning
Hi can anyone help on this,
My requirement after users selection of field, operator and value on each row on click of button it will able to call a dynamic search query with all these selected fields,...
0
votes
1answer
62 views
What's the problem with this backslash in SOQL query?
I'm receiving a String query with query params (via URL), and one is mandatory and seven are optional. So if i don't receive a param, shouldn't be included in the query.
For instance:
My code is:
...
1
vote
1answer
54 views
SOQL with conditions on children
I'm unable to finish an easy query, I could use some help on this.
I got a junction object called Creche_Zone_de_Tarification__c that links two objects (Account and Zone_de_tarification__c and that ...
-2
votes
1answer
37 views
Optimize SOQL query
I have a condition where I need to get list of Contacts based on many conditions, which I'm able to do but now I need to limit the number of Contacts per Account.
For the new scenario I need to ...
3
votes
1answer
34 views
Should the user input be escaped in dynamic SOQL when using binding?
Given the following query:
public List<Account> selectById(Set<String> names)
{
String query = 'SELECT Id, Name FROM Account WHERE Name IN :names ORDER BY Name';
List<Account&...
0
votes
2answers
353 views
Cannot access the Parent field values from list<sObject> and Database.query
I have a dynamic SOQL that is being generated and then I am using database.query(querystring) to store the list of sObject in the dynamic sobject list.
Here's the code :
string queryString ='SELECT ...
0
votes
1answer
58 views
Most efficient way to get all child records for a specific record
I have an account record that I want to get every single possible child record - ideally as a list of IDs.
Currently I am doing the following:
for(Opportunity opp : [SELECT ID From Opportunity ...
0
votes
1answer
45 views
Can I convert this dynamic SOQL to static SOQL?
String queryString =
'SELECT Id,IsPersonAccount,RecordTypeId FROM Account WHERE LastModifiedDate < ' +
Ke.Job_Start_Date_Time__c.formatGmt('yyyy-MM-dd\'T\'HH:mm:ss\'Z\'') +
...
0
votes
0answers
31 views
Unable to retrieve records from the dynamic sObject list
I have written some dynamic code for selected object listview. I want to show all recods which belong to the dynamic sObject but I am getting this error ( Invalid field Title for Contact ) for every ...
0
votes
1answer
53 views
Can someone provide me the list of SOQL exceptions?
Can someone provide me the list of SOQL exceptions? a URL link which has all the exceptions and explanations. Thanks in advance
-1
votes
1answer
259 views
Error: Compile Error: Found punctuation symbol or operator '%' that isn't valid in Apex. at line 14 column 362
global class ABI_SFA_TAC_Removal_Batch implements Database.batchable<sObject>
{
// variable decleration.
public String Query;
/*
Method Name: Start
Description: This ...
1
vote
1answer
384 views
Forming a dynamic SOQL with multiple fields in WHERE clause
I have written a method to dynamically query an object and its fields.
As I want to keep it configurable, a fieldset is used to provide with which fields to query, and also the object.
The problem I ...
3
votes
1answer
44 views
Is Contact othergeocodeaccuracy a legitimate field?
Many of our Continuous Integration builds just failed with hundreds of this error:
System.QueryException: No such column 'othergeocodeaccuracy' on entity
'Contact'.
Our code does describe calls ...
2
votes
1answer
60 views
Is it possible to rebind for dynamic SOQL in a more scalable way?
I came to the realisation that it isn't difficult to create my own String Interpolation, like this:
public class XAP_UTIL_MapInterpolation implements XAP_UTIL_InterpolationIntf {
String template;
...
0
votes
2answers
781 views
System.QueryException: unexpected token: '<EOF>'
I have built dynamic query.but receiving below exception
01:16:56.0 (15683245)|USER_DEBUG|[335]|DEBUG|SetOfParentId--->{}
01:16:56.0 (15756602)|USER_DEBUG|[336]|DEBUG|Set1--->{}
01:16:56.0 ...
0
votes
0answers
23 views
get records based on recordtypeID and listviewID
I need to get records based on recordtypeid and listviewid but it is returning all records. I don't know where I'm doing it wrong.(it will return records based on listview but recordtypeid condition ...
1
vote
1answer
492 views
System.QueryException unexpected token
Trying to return all fields in object
System.QueryException: unexpected token: '('
when I run the Invocable class at the parents = assignment
public with sharing class AuditReportBulkifyClass {
...
1
vote
2answers
34 views
Query parsing error like clause
What is the correct syntax for a query that retrieves all Accounts that have __Civil_ in the Name?
SELECT Id FROM Account WHERE (Name LIKE '%_Civil_%')
1
vote
1answer
144 views
How to find SOQL syntax error?
I have an error somewhere in my SOQL string but can't figure out where because the only message I'm getting is 'Unknown error parsing query' if I try to execute it in the Query Editor of the dev ...
