Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [dynamic-soql]

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

3
votes
1answer
13k 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 ...
8
votes
4answers
865 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 ...
-4
votes
2answers
825 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 ...
3
votes
1answer
2k 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: System....
1
vote
1answer
268 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
1k 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 this)....
3
votes
1answer
253 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
648 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 = \'' + String....
9
votes
2answers
2k 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. ...
-2
votes
1answer
53 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
573 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
1k 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 List<...
3
votes
1answer
562 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
1k 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 ...
-1
votes
1answer
83 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
892 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 (...
2
votes
1answer
3k views

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

how to i get datatype of any filed in SOQL?
4
votes
2answers
6k 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 ...
7
votes
2answers
1k 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 += '...
0
votes
1answer
2k views

Dynamic SOQL for getting all objects in Salesforce Org

I am creating a VF page which contains a Picklist of all objects in my Salesforce org including Custom Objects. I am getting an error 'unexpected token: 'null' when I select custom object. VF Page ...
2
votes
1answer
175 views

Showing matching keyword sentences from SOSL/SOQL results

We have a requirement to search in large text area field (for e.g. Description). We are using SOSL for the same. While showing results on the VF page we want to only few sentence from Description ...
0
votes
1answer
312 views

Custom field visibility error on managed package installation

I have a managed base package and an extension package. The base package had a remote site as one of the components but I had to remove it. Since I couldn't remove the remote site from a released ...
1
vote
1answer
202 views

Transfer SelectOption Values to Dynamin Query

Trying to get the values to my Controller that I can change the limit on the displayed List on my Page. I'm Using a dynamic query and everything is working fine but what's below. What am I'm missing? ...
2
votes
1answer
1k views

How to search for text in Rich Text area field in Apex

i want to search a text in Rich Text area field of a custom object. Since We can't use the RichTextArea field in the where clause of SOQL, I am looking for the way to search a text. Is there any way ...
0
votes
2answers
416 views

query as string type in controller class

Can any one explain me...what is the meaning of below lines. I get it from This link. String qryString = '<strong class="ph b">SELECT Id, title, UrlName, LastPublishedDate,LastModifiedById FROM ...
0
votes
1answer
1k views

Pass parameters from URL to SOQL query.

How can i pass parameters from URL to Controller? I want to pass URL parameters to My controller class where i can query to fetch data with the help of these parameters.
-1
votes
3answers
166 views

Trailing 12 Months Formula

All, **EDIT: Sorry for being too vague. I'm trying to add another field to my sales summary that displays on Account pages. I'm trying to grab the trades that fall within a date range of the past 12 ...
-1
votes
1answer
311 views

Count on sObject

EDIT: What I'm asking is, do I have to execute two separate query one for retrieving the information and one for count? is that possible to put both together in one query? in the .NET you just have ...
1
vote
2answers
196 views

common field between account table and contact table

I have Three questions 1.) Can you please let me know how to write a SOQL query to get the contact based on a specific record 2.)What is common column name between acount and contact table 3.)How ...
1
vote
1answer
653 views

I am getting Error “ Variable does not exist: queryResult”

Please Find the code <apex:page controller="SOQLController" > <apex:form> <apex:outputText value="Enter Name" /> <apex:inputText value="{!name}" /> ...
3
votes
1answer
160 views

custom setting SOQL vs methods

i often come across scenarios where we have some custom setting with lots of fields created which has rows for multiple purposes. So for a specific scenario, it is often needed to filter all the rows ...
9
votes
5answers
2k views

What's wrong with this SOQL

Declared a string and assigned SOQL value as shown below. While running I am getting an error. String country = 'United States'; String accountQuery = 'SELECT Id,BillingPostalCode,County_Name__c '+ ...
2
votes
1answer
2k views

How to filter query for specific types of parent lookup?

for (SObject deletedObject : [SELECT Id, isDeleted, LastModifiedDate, parentId FROM Attachment WHERE isDeleted = true AND LastModifiedDate >= :timestamp ALL ROWS]) { It appeared, that recently ...
1
vote
1answer
94 views

unexpeced token: ( with dynamic SOQL

The following gives an error on runtime: String queryString = 'select name,street_address__c from warehouse__c where' + 'DISTANCE(location__c,GEOLOCATION('+ lat + ',' + lon+ ' ),\'mi\') &...
1
vote
1answer
951 views

query sObject or Custom setting by multiple fields

i need to implement logic at couple of places which is like querying an sObject or a custom setting. There are input fields using which i need to create filter criteria to reach appropriate records in ...
0
votes
1answer
131 views

Retrieve earliest record from each Grand child object

I have 3 objects, Object A, Object B and Object C. Object B is a child of Object A, while Object C is a child of object B. I am trying to access the all the single earliest records of all records in ...
2
votes
1answer
2k views

What meant by DescribeFieldResult Class?

Can anyone clearly explain what exact use of DescribeFieldResult Class in Apex code. And also please provide an example.
2
votes
1answer
998 views

Getting SOQL/SOSL Injection error when I send my code for security review

I have send my code for security review I am getting error for SOQL/SOSL Injection. I have made the changes on the bases they have mention in report. But even I am getting issue with dynamic soql I am ...
7
votes
1answer
2k views

Force Dynamic Soql results to include fields with null value

So I've read a lot about this and it seems that queries run with Database.query(queryString) will skip over any field values set to null instead of returning the property set to null This has cause a ...
0
votes
1answer
674 views

How to fetch the Account Name By selecting contact Name in custom object( communications__c)

I have a 2 fields in Communication__c (Custom object). field 1: Select_Contact__c (Lookup) (from Contact Object) field 2: Account_Name__c (Text). In Visualforce Page, when ever user selects the ...
0
votes
0answers
106 views

Pass Field Api From Visualforce Page to Controller

Hi everyone I have a scenario where I can select the fields and that can be either multiplied/subtracted/added/divided and that result should be updated in another field. Using describeobject class ...
2
votes
1answer
2k views

How to get Cases, Opportunities, Contacts Associated with Account Object Dynamically?

I need to get all the associated Contacts,Opportunities and Cases, for a given Account, if there are any. Right now, I am doing something like below: public List<Case> getCases(SObject sobj){ ...
1
vote
1answer
1k views

Updating the owner of records connected via lookup relationship

I was given a task to write a trigger to update the owner of records connected via lookup relationship. Consider i've a custom object which is having a lookup relationship to another custom object. ...
10
votes
1answer
6k views

How to use dynamic SOQL to instantiate a MAP

I've tried doing it, but I get this error: Compile error at line 101 column 32 Invalid initial type List<SObject> for Map<Id,Opportunity> Here's my code: //build out the set set <id&...
1
vote
1answer
3k views

Multiple LIKE in SOQL

I have a batch class where I need to find all contacts with titles like director, cEO, etc. This should allow partial matches such as 'support director', 'sales director', I was trying this but is not ...
0
votes
1answer
76 views

Dynamic SOQL - Risks/Impacts

I understand SOQL is a much restricted version of SQL but what are the potential risks associated with using dynamic SOQL? What damage could be done with malicious intent through it? I'm just trying ...
1
vote
1answer
940 views

Sorting functionality using dynamic soql

I have created a visual force page in Account page that displays related opportunities by RecordType(5 Records at a time) for the given Account and when click on Go to List it directs to new VF page ...
0
votes
0answers
212 views

Error as MALFORMED Query in Developer console (Group by Rollup, Group by Cube)

Why do I get this ERROR as :MALFORMED Query in Developer console? I'm trying to use :Group By Roll or Group By CUbe to get the subtotals and grand totals. When I tried this Query: SELECT id,...
0
votes
2answers
937 views

Not able to query on standard Asset field 'ProductCode' . Please suggest

List<Asset> lst= [select Id, ProductCode, Product_Family1__c, Product_Family__c from Asset WHERE AccountId = '0015000000IBGof' AND ( (NOT IB_Status__c Like '%eval%') ...
2
votes
1answer
637 views

System.QueryException: Non-selective query against large object type with 0 records

I am getting the following error for a query I am running dynamically System.QueryException: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or ...