Dynamic SOQL refers to the creation of a SOQL string at runtime with Apex code.

learn more… | top users | synonyms

1
vote
1answer
14 views

how to specify dynamic query field values to custom setting fields?

I have a dynamic query which has the where condition like this: ' WHERE (Contract_State__c=\''+'Complete Activated'+'\''+'OR Contract_State__c=\''+'Partially Terminated'+'\''+')'+' AND ...
0
votes
1answer
21 views

Using variable in Query

Can I use variables for objects in my SOQL query? I have the variable like: public sObject objectvar; Which gets a record of type Account. How can I use this variable in my SOQL query like: Select ...
0
votes
1answer
33 views

List Result is null

StaticResource sr = [select body from StaticResource Where Name = 'kalpak']; String contents = sr.body.toString(); LIST<String> alOne =new LIST<String>(); List<String> arrrrr = ...
0
votes
1answer
19 views

SOQL Dynamic Query on objects ( Dynamic sobject name in soql )

String str = 'Order'; List<SObject> listData = [Select Id From str ]; Can we query like this, I want to query dynamically
3
votes
1answer
149 views

Dynamic Visualforce page not showing Checkbox values correct after page reload

I have the following Visual force page: <apex:form id="mainForm" > <apex:actionFunction name="renderConsolePage" action="{!renderConsolePage}" rerender="out1"/> ...
0
votes
2answers
31 views

Retrieving Dynamic SOQL results. Runtime error - “Invalid field Owner.Name for…”

I had a question in regards to dynamically retrieving the results of Dynamic SOQL that I have set up in my controller. I want to be able to access fields on the Lead object (Lead.Name) itself as well ...
0
votes
1answer
21 views

Getting compile error while creating dynamic SOQL

queryStr+ = 'AND Sales_Order__r.sales_year__c =' +\'' +:strYear+\''; This is my string.strYear is the year value which i want to add dynamicaly. I am getting an error "Compile Error: unexpected ...
0
votes
1answer
46 views

How to Format the numbers entered in the Input Text Fields

When i try to search with 1000000 and 1500000 in Price Min and Max fields.the soql query is executing fine.but when i enter the values seperated with commas like SFmin=10,00,000 and ...
1
vote
1answer
31 views

A brief about Dynamic SOQL concept

can you give a complete manual/page for referring Dynamic SOQL where as https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_dynamic_soql.htm never providing considerable ...
0
votes
0answers
18 views

use dynamic mapping object for web service

i am trying to write a GET web service to fetch a parent object say delivery and its child say delivery line. This is my first experience with web service.and the requirement is like i have to write ...
6
votes
3answers
292 views

Why I can not use Map in dynamic query

Map<Id, Account> maps = new Map<Id, Account>(); for(Account acc : [Select Id from Account]) { maps.put(acc.Id, acc); } String s = 'Select Id from Account Where Id IN : ...
0
votes
1answer
44 views

Dynamic Query String Where clause concatenation

I am newbie & trying to create a dynamic querystring on the basis of some conditions, & even when it does not satisfies any condition, the query should be able to run properly with where ...
1
vote
3answers
73 views

Upsert failed in apex

I'm trying to do upsert and I get duplicate error on Unique field. Shouldn't upsert take care of whether to update an existing record or to add a new record? Error: caused by: ...
6
votes
1answer
190 views

Undelete error: entity is deleted

I'm trying to undelete records using apex and it is throwing me an error: entity is deleted List<MyObject__c> undeleteObj = [select id, Unique_Id__c from MyObject__c where ...
1
vote
2answers
34 views

Binding variables in dynamic soql

I am trying to dyanically attach a WHERE clause to a base query string by following this guide. https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_dynamic_soql.htm I am ...
1
vote
0answers
28 views

Get the number of Opportunities for each User in the org (the count must include the records to which the User has atleast read access)

I need to get the count of Opportunity record for every User in the org where the User has atleast read access on the Opportunity record. I need to store the data obtained per User for every month in ...
4
votes
1answer
104 views

Dynamically using Field

I have a function as below: public PageReference resendEmails() { List<ts2__Placement__c> selectedPlacements = new List<ts2__Placement__c>(); List<Timecards__c> timecards = new ...
4
votes
2answers
48 views

Semi Join on String

I have a junction object called Trip_meeting__c to connect Event to Business_trips__c. Because you can't create a lookup to Event, I am using a text field Meeting__c to hold the Event Id and will ...
1
vote
1answer
49 views

create a map with keys = fields names and values = query result

I am trying to create a map from a result of a SOQL query, this map contains the name of the fields as keys and the values of the query as values for example: List accounts = [SELECT Name, Email ...
1
vote
1answer
57 views

Using multiple variable with same name in dynamic SOQL

Good day everyone I have some problem in regards with using dynamic query with too many variables. To explain further below is some part of my code. String QueryString = ''; ...
0
votes
2answers
55 views

How to get the records using dynamic soql for the date field which is equal to NULL

I have a requirement where the user should be able to include the records where the due date is not populated when i uncheck the checkbox field in the vf page.In my case that date field is named as ...
0
votes
1answer
76 views

How to get the records for null value in the picklist field using dynamic soql

I have a picklist field Executed__c with None,Yes,No values in it.The query which i have written is fetching the records when the user selects yes or No.But when user selects None,null value is ...
3
votes
2answers
87 views

Query non existing custom object

I'm on a developer org on which I have a managed package that I manually install on customers orgs. Each customer's org is a bit different, with different requests/requirements. The code is as ...
0
votes
1answer
40 views

SOQL not working

I have a dynamic SOQL query where in I am using order by clause.I want to sort it by product Style SOQL soql = 'select id, name,Warehouse__c,Product_Reference__r.gii__ProductStyle__r.name, ...
0
votes
2answers
43 views

Dynamic SOQL error

I am getting the following error while running my dynamic query.But when i make it normal query it works.Error is : Didn't understand relationship 'gii__Product__r' in field path. If you are ...
1
vote
1answer
33 views

Call dynamic SOQL from other method in apex

Good Day everyone, I have a problem in regards with calling a method that contain a dynamic SOQL. To explain further, below is a sample code: public class commonFunction { public static String ...
1
vote
1answer
29 views

How to find a value in all column of an object?

How to find field_name/api_name name for any object that contains a value? I'm working on a object that has dozens of fields but I'm after finding out particular value belongs to which field name. ...
1
vote
2answers
29 views

SOQL - ignore custom field if non existent

I want to run a query like this - select id from lead where inactive__c = false limit 1 If the org doesn't have the custom field inactive__c, it throws an error. Is there any way to ignore the ...
0
votes
0answers
23 views

Hitting Governor limits because of the size of the single object being updated - is batch class the best answer?

I am new to SF apex coding. For legacy reasons we have a custom object that has about 400 numeric fields. We need to aggregate (sum) these 400 fields across different records into an aggregator ...
0
votes
1answer
66 views

List<id> at IN clause in Dynamic SOQl

I am fetching all the field from sObject and querying using Database.query(). When I query with List of id's it is throwing Invalid ID ('id', 'id', ...) error. for example at static soql we can query ...
7
votes
4answers
678 views

Genuine SOQL Injection issue or False Positive?

Trying to work out if this a valid issue with my code, or just a false positive I can note in report for Security Review. I have provided a slightly simplified version below. The Id I am querying for ...
-3
votes
2answers
79 views

Dynamic Search Function Test Method on QueryString

I am having a problem testing a queryString within a Dynamic Search function. For example, I have a list of strings related to Contact record. Within the VisualForce page, I run a Search Function to ...
2
votes
1answer
286 views

How to SOQL query contacts by phone number when there are more than 100,000 contacts

I am receiving a System.QueryException when searching for contacts by phone number in an APEX class: An error occurred at element myRule_1_A2 (FlowActionCall). An Apex error occurred: ...
1
vote
1answer
67 views

Get Network.getLoginUrl via SOQL dynamically

I would like to get the getLoginUrl information of a Network sObject. what is the be way to get this information dynamically via SOQL? since static methods can't be invoked dynamically. Thanks
-1
votes
2answers
87 views

How to count active workflows in one object

Requirement:-I need to count total Active workflows for each object . Like For account object how many active workflows are there.. Is there any quick way to achieve this(query or something like ...
3
votes
1answer
107 views

How to safely run User-generated SOQL query strings

Background Context: I'm building a small feature similar to Andrew Fawcett's Declarative Lookup Rollup Summary tool. We will allow users to enter in details for their own WHERE clauses for the ...
2
votes
3answers
229 views

Adding space in Dynamic SOQL

Can some one please to add the space before FROM in Dynamic SOQL. string query ='SELECT ' + qFields + 'FROM contact'+ ' WHERE user_num__c = \'' + ...
5
votes
2answers
332 views

Accessing child records returned from SOQL via generic SObject

I'm currently querying the records of a custom object, including some related child records. Unfortunately the parent object is unknown, so the returned results from the query is a list of SObjects. ...
-1
votes
1answer
46 views

i have records to be processed in vCommonRecords. i am not receiving the emails with expected results

My actual task is : 1.I have Account object it is having 2 child objects contacts and Orders. 2. need to process the account records with record type = Branch Integrated 3. need to send email ...
4
votes
3answers
126 views

SObject row was retrieved via SOQL without querying the requested field: Contract.Account

i'm trying to build query Dynamically for Contract object. public Contract con {get;set;} ConId=ApexPages.CurrentPage().getParameters().get('ConId'); Map<String,Schema.SObjectType> ...
3
votes
1answer
392 views

SOQL Dynamic Query building using Map.get(List)

I have a doubt. Suppose I want to query on Account object filtering based on a given list of IDs. Below snippet works fine when I have a list of Ids. List<String> accountIds = new ...
3
votes
1answer
68 views

How to use soql queries on multiple look up relationship object to retrieve specific data

I have 4 custom objects (as shown in the schema diagram). And they are associated using a lookup relationship. Now the objective of my question is to retrieve Product profile(product) for a given ...
1
vote
1answer
192 views

Select Count() with dynamic SOQL - how to stay in Governor Limits?

I am trying to fix my code so I don't hit any governor limits on my SOQL queries. Long story short: I am just learning on how to use maps, but I'm trying to figure out how I can do a SelectCount ...
0
votes
1answer
32 views

How to update the custom field using soql with limit?

I have to update Description__c field in Account object where BusinessUnit__c having BU1 to BU1000. I have the records BusinessUnit__c field contains BU1 to BU2000. I need to update Description field ...
0
votes
1answer
162 views

no viable alternative at character '\' dynamic soql issue

I have below method which gets called from page by supplying the search keywords: public PageReference runIntermediariesSearch() { soql = intermediariesSoql + ' where Name != null '; if ...
0
votes
0answers
155 views

Building Dynamic filters and displaying in VF page

I need to create a VF page(very simple). And i have a requirement where i need to build custom filter criteria in VF page on specific object(let's say Account).That's again not so difficult, As i can ...
0
votes
0answers
20 views

dynamically build a subquery [duplicate]

Setup: I have an Object Parent__c connected to Child__c . I have two relationships from Child to parent- mother__c , and father__c. In real life, these objects could be anything, so I need dynamic ...
2
votes
1answer
602 views

How to get data type of any object's field in SOQL

how to i get datatype of any filed in SOQL?
3
votes
2answers
795 views

isDeleted=True is not working in SOQL query

Wondering why this query will retrieve ZERO records when executed in Workbench and Developer console. (Though i have records in Recycle Bin) Select Id, IsDeleted FROM Account WHERE IsDeleted = TRUE ...
3
votes
2answers
330 views

BillingAddress in query generate error

I have a query like below in an Apex Class in Sandbox. query = 'SELECT Id, Name, BillingAddress, BillingLatitude, BillingLongitude FROM Account WHERE Name = \''+ name +'\' AND '; query += ...