Questions tagged [dynamic-soql]
Dynamic SOQL refers to the creation of a SOQL string at runtime with Apex code.
441
questions
0
votes
1answer
28 views
APEX Aggregate Query - Query to get Sum of Amount of all opportunities of Account when stage is Closed Won
I am having trouble making the query to get Sum of Amount of all opportunities of Account when stage is Closed Won. Please help me out. This is the Query I wrote.
Select SUM(AMOUNT) , ID , Name from ...
0
votes
0answers
33 views
Valid SOQL that returns results does not return when run dynamically
I have an Apex class that runs a dynamic SOQL query. The logs say "Aggregations:0". However, when I copy/paste the executed query directly from the log into developer console, it returns ...
0
votes
1answer
45 views
dynamically created query in APEX and Update the Value
Dynamically created query in APEX and Update the Value. Trying to update field value by
string objectName = 'Account';
list<sobject> recordsList;
string condition = 'id IN:' + recId;
...
0
votes
1answer
21 views
I'm using a dynamic query to fetch records, how to treat '%' if given as input in like query to be treated as a string and not another wildcard char?
I have a LWC component which takes 4 input from the user and fetches the matching records based on the conditions in the query. In the below apex method to fetch records, the parameter 'c' which is a ...
0
votes
2answers
29 views
lwc lookup component not returning what I search for
I found a lookup component that I am using and so far was ok until last week. The user would like to type a word and all products with that word will be displaying.
example: when a user type CPC in ...
0
votes
0answers
22 views
Trying to query a limit of 100 orders that are broken up into multiple records based on the item
I need some assistance with creating a query that will get all the records that correspond to the first 100 orders. For example the table looks something like this:
I know I can use GROUP BY grab the ...
0
votes
1answer
27 views
Query involving parent and child objects in where, group by and order by clause
I have an object called SRC which has account as lookup in it. SRC content will be as shown below:
SRC ID
Account__c
Status
City__c
LastModifiedOn
1
1
Yes
Delhi
12-Apr
2
1
No
Cochin
13-Apr
3
2
No
...
0
votes
1answer
137 views
Avoid untrusted/unescaped variables in DML query error
I'm building dynamic queries in few of my apex methods. When I run the PMD code review, i'm running into the "Avoid untrusted/unescaped variables in DML query" error. Running into 3 dynamic ...
0
votes
3answers
102 views
How to Query all fields of grand parent record with SOQL?
I have a App__c with n number of fields.
Page__c is another custom object has few fields and a field App_Id__c which is Master-Detail to App__c object.
Field__c is another custom object has fields and ...
1
vote
3answers
158 views
using today date in Database.getQueryLocator query String throwing errors
I am running a batch class. I am providing query in string format. I am facing issue with using a filter criteria
StartDate__c>=:System.today()
In a direct query, i could write something like
List&...
0
votes
2answers
102 views
Second order SOQl/SOSL injection error during checkmarx scan
I am getting SOQL injection at line originalObjectQuery += ' WHERE Id = '' + originalId + '''; How can i reslove this?
public static Id close(Id originalId) {
//** Build query to return the full ...
0
votes
0answers
34 views
Create a dynamic query for each item in for loop
Hi I want to create a dynamic query for each item in for loop , but again I don't want to execute that query in the for loop, right now since I am creating a query in for loop, I am no option but ...
1
vote
2answers
78 views
History field is blank for this query, Please help :)
I am new to salesforce, please help me out with this one:
I am trying the following SOQL query to retrieve the changes made to the teacher object but I am getting nothing in the history tab.
I turned ...
0
votes
2answers
51 views
Reference Set<Id> in the WHERE clause of a Dynamic SOQL in Batch class
I have a Batch class and I am trying to reference a Set in the WHERE clause of a dynamic SOQL query but I have an error:
System.QueryException: expecting a colon, found '{kA09E0000005mCySAI}'
when ...
0
votes
1answer
35 views
What is the syntax of including not null value in dynamic soql and how to include a number variable in dynamic soql
var s = "Select Account_vod__c from Event_Speaker_AZ__c where ";
s = s + " Medical_Event_AZ__c = '" + "{!Medical_Event_vod__c.Id}" + "' "
+"...
0
votes
0answers
152 views
Apex to return custom metadata and dynamic object data
I am looking to have a lightning web component that returns data from an object based on the record I am on that i can display on a lightning record page . I am exploring programmatically pulling a ...
0
votes
0answers
44 views
Transforming a read-only map<String,Object> criteria of a RemoteObjectController.retrieve into workable Apex SOQL?
How can a visualforce page (or the page's controller) access the NON-paginated results size of a Remote Object Model's RemoteController.retrieve query?
Here is the relevant part of my override method,...
0
votes
1answer
25 views
SOQL to Pull LastLoginDate from past 2 hours but not last 30 minutes
Here is the scenario that I'm running in to. I need to able to pull users that logged in past 2 hours but not last 30 Minutes. I tried every possible way to filter this in but since we can't Use ...
0
votes
2answers
48 views
SOQL query for more than one field to exclude null values
I have around 12 fields. Trying to write a SOQL query for more than one field to exclude null values.
For single field which is not null, I am able to get the records. I want to a SOQL to get the ...
1
vote
1answer
53 views
Database.Query does not return fields with null value - Reasking
This was asked previously here however the answer isnt useful.
Using an invocable class with a dynamic database query. If any of the fields in the query return a null value then the field is dropped ...
1
vote
1answer
102 views
Dynamic Queries on Dynamic Objects at Volume
We are trying to create a mechanism that would process user dynamically created queries and create "Contributors" for each matching record.
The object model is as follows:
Account -< PO ...
0
votes
1answer
54 views
Try to solve a dynamic SOQL query [closed]
String lvQueryUp = 'SELECT Id, StartDate__c, Name FROM CustomObject__c WHERE';
for(String lvindex : myIndexListName) {
lvQueryUp += ' ( Name = ';
lvQueryUp += '\'' + lvIndex + '\'';
...
0
votes
1answer
33 views
Select all fields in a custom object dynamically in a specific order
I have a custom object that I need to select all fields from in a specific order to create a text file in a specific format.
So far, I've been dynamically accessing all the fields I need via .getMap()....
1
vote
0answers
24 views
Is that possible to use query plan for dynamic SOQL queries?
I know we can verify straightforward SOQL in query plan. Now, I am trying to find a way to use query planner for a dynamic SOQL queries. My SOQL query depends on several Ids (list of Ids) and binding ...
4
votes
2answers
157 views
Security Review - False Positive for SOQL Injection - Configuration Data (Input only by System Admin User)
I am using a dynamic query in one of our AppExchange products.
There is an LWC component within our app, which has a property called filterLogic as below:
<targetConfig targets="...
0
votes
1answer
30 views
Test data not visible by Dynamic SOQL
I have an seemingly simple aura enabled class for agreement lookup which returns maximum 8 records using dynamic SOQL. This class works fine from UI perspective. No issues so far while testing.
My ...
0
votes
1answer
33 views
unexpected token: BillingState
Im learning more about Batch Apex class and I find it pretty cool and helpful. When I remove the Where BillingSate='TX' everything works as expected. Yet when I use the Where condition I get the ...
4
votes
2answers
235 views
If I Use a Loan Pattern is Salesforce smart enough to do a SOQL for loop?
As we know, Salesforce does some magic when you do something like:
for (List<Account> accountList: [SELECT Id, Name FROM Account WHERE Name LIKE 'Acme%']) {
// do stuff
}
... such that the ...
-2
votes
1answer
242 views
How can i convert apex method into batch?
public void addVisibilite() {
Map<Id, List<Id>> accountContactRelationIdsMap = new Map<Id, List<Id>>();
for (AccountContactRelation accountContactRelation : (List<...
0
votes
1answer
59 views
get count of all the fields containing data in a specific object
public static Map<String, decimal> getFieldsCount(String objectName){
Map<string,Schema.SObjectField> get_F_name=Schema.getGlobalDescribe().get(objectName).getDescribe()....
2
votes
1answer
126 views
How To use security enforcement with dynamic database.query in apex?
String objkey='Opportunity';
string recordID = '0061k000007Pyuf';
string soqlQueryCurrent='Id, Name, currency_Culture__c';
string queryStr ='SELECT '+soqlQueryCurrent+' FROM '+objkey+ ' WHERE id=:...
0
votes
1answer
50 views
How to Ignore Not Existing Field in SOQL Dynamic Query
String objkey='Opportunity';
string recordID = '0061k000007Pyuf';
string soqlQueryCurrent='Id, Name, currency_Culture__c';
string queryStr ='SELECT '+soqlQueryCurrent+' FROM '+objkey+ ' WHERE id=:...
0
votes
2answers
60 views
SOQL - ignore custom field if non existent in object
String objkey='Opportunity';
string recordID = '0061k000007Pyuf';
string soqlQueryCurrent='Id, Name, currency_Culture__c';
string queryStr ='SELECT '+soqlQueryCurrent+' FROM '+objkey+ ' WHERE id=:...
1
vote
2answers
106 views
How to remove SOQL Query from the for loop by Queueable in apex
I need to retrieve the field value given subject. But the only way I find to do it is by doing a dynamic query in a For or loop. Did anyone have a solution to avoid the query in the loop? Or any other ...
0
votes
1answer
33 views
I have got the Exception [DEBUG|Exception: System.QueryException: Only variable references are allowed in dynamic SOQL/SOSL. ] on SOQL Query
When i have executed my code i got the exception System.QueryException: Only variable references are allowed in dynamic SOQL/SOSL. . Kindly assist me.
string query3 ='select id, accountId, ...
1
vote
1answer
92 views
Dynamic query using In with a List with multiple fields
I have an array of this class
global with sharing class JiraTimeLog {
public Long worklogId;
public String jiraIssue;
public String milestone;
public String resource;
public Date ...
0
votes
1answer
331 views
Iterating over child records dynamically in apex
I have a requirement where in lightning web components , I am using design attributes so that admin can enter the objectApiname and fieldApiname.In fieldApiname,admin can give direct fieldapiname of ...
1
vote
2answers
500 views
Fetching Parent field value with dynamic SOQL
I am performing a dynamic query on case feed and fetching few fields including CaseNumber. queryResult is storing the results but it does not contain casenumber. I am able to retrieve caseNumber with ...
1
vote
1answer
469 views
get second highest salary of employee using soql
I need to calculate second highest or 4th highest salary etc.. what is the way to calculate it.
select salary__c from Staff_Details__c order by salary__c desc
I am getting the salary in desc order but ...
0
votes
1answer
521 views
Create lookup field on VF page + dynamic search based on lookup field value
I have VF page, build to perform search on Case object. I am already performing search based on Case Status, Case Number.
I want to add one more search based on field "Product". Product(...
0
votes
1answer
74 views
save button not working on pageblockTable column
I have added inlineEditSupport and save function to pageblocktable on Case object.
I want to save values in inputField "Case Review Notes" field (Case_Comments_On_VFReport__c). When I click ...
1
vote
0answers
66 views
ContentDocumentLink Limitations when querying using LinkEntityId as filter
my apologies if this has been asked somewhere else. I didn't find any answer hence I have to post this question.
USE CASE:
I am using database.query(queryString);
In queryString = 'SELECT id,...
3
votes
1answer
151 views
Dynamic csv generation for a dynamic soql query in apex
When constructing a csv via apex how do we avoid hardcoding the recordString assignment within the query loop?
Note I have a dynamic List<String> fieldsList that represent field names. For ...
-2
votes
2answers
738 views
OR condition check in dynamic SOQL query for multiple picklist value
Getting error while executing SOQL query. We have Address_Type__C is a picklist field having multiple value. We are checking for the multiple value's in the OR condition. Is the Query seems correct?? ...
0
votes
1answer
250 views
SOQL query to get the first and last day of the current month?
i need to pass SOQL query to get the first and last day of the previous month.
Example Query:
Select Name, ID
FROM Audit__C
WHERE Audit_Month__C BETWEEN 'previous month start date (2020-04-01)' AND '...
0
votes
1answer
18 views
Dynamic Soql throwing an error [duplicate]
String str = 'hellotest';
String qry = 'select id,Products__c from Account where End_Date__c > :system.today() and Start_Date__c < :system.today() and IsValid__c = true and Approved__c =' + '\'' ...
0
votes
2answers
140 views
Soql to return results on the basis of multiple filters
I am trying to return the account records on the basis of some search keywords like AccountName, Billing Street, BillingState, BillingCity and PostalCode.
I am able to return the results but not able ...
0
votes
1answer
349 views
Unable to pass object Name in the SObject for loop to call methods Dynamically
I am trying to optimize my code, instead of using object Name in if else I want to pass the SObject parameter and combine below code
Instead of using separate objects I am trying to merge if else ...
0
votes
1answer
93 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
77 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 ...
