Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with soql
Search options not deleted
user 74004
Salesforce Object Query Language (SOQL), modeled on SQL, for accessing information saved in the Salesforce database.
1
vote
1
answer
230
views
Query to find max(RecordId) on Duplicate Record Items
I want to find the AccountId that is most of times used as Duplicate Record Item. I tried
select id, count(RecordId)
from DuplicateRecordItem
group by RecordId
but i get
MALFORMED_QUERY:
select …
- 937
0
votes
0
answers
63
views
Apex SOQL Strange Behavior skips spaces
I have a custom object under the account entity (master-detail). This object (System Codes) has 3 fields (Account, Code, Line). I perform a query in inspector (or in dev. console - the results are t …
- 937
0
votes
1
answer
294
views
Filter records by Date - SOQL
I am trying to get some duplicate records by using SOQL but i also want an analysis per day.
select max(id)maxID,count(id),name, ea_System__c, ea_BusinessLine_Code__c, ea_CustomerId__c, count(Id)
from …
- 937
-2
votes
1
answer
89
views
Avoid SOQL inside for - loop
I want to select all the related services and update them, but i would like to avoid the use of soql inside the for-loop since it is against salefsorce best practices. How could i utilize the maps? …
- 937
2
votes
2
answers
492
views
Apex method does not return result as expected
I use an apex method that takes as inputs 2 dates. And i query on events and then i return the list of events. My code is this:
@AuraEnabled
public static List<Event> getEventsForDateRange(String fr …
- 937
1
vote
Accepted
Apex method does not return result as expected
So after a lot of debugging i found solution! Here is my code that works as expected
@AuraEnabled
public static List<Event> getEventsForDateRange(Date fromDate, Date endDate){
try{
Time m …
- 937
0
votes
1
answer
513
views
Query Parent records of an Object
The way i do it (query for the parent records by using the null in the SOQL query) or to select all product configurations of this opportunity and then process only the parents? …
- 937
-1
votes
1
answer
347
views
Get all records created by user today
We are about to perform Load Testing and we are performing some complex scenarios. We use a CPQ tool that has many custom object records being involved and inserted. Is there an easy way to get someho …
- 937
0
votes
Get all records created by user today
Used the code based on a similar question: How to get list of all sobject records modified today in the system?
but with some minor changes on the ignoreList list.
ignoreList.add('feedattachment');
ig …
- 937
3
votes
1
answer
2k
views
Access Parent Record from child SOQL - APEX
This question seems silly but i am really stuck! I want to get the Account name and Account Rating for my contacts via Apex code, but instead of Account name and rating, it returns the accountId! I ru …
- 937
0
votes
1
answer
233
views
Rest Service - Return grandchild in the response
I need to create a Rest Api where I want to take as input an Id and perform a query on an object. The response must contain the fields of this record and also some related records (children) and the r …
- 937
1
vote
1
answer
2k
views
Map returned to JS does not include null values
inputMap.get('fieldAPIName'); //Mandatory
String orderByFieldAPIName = (string) inputMap.get('orderByFieldAPIName'); //Optional
String queryString; //Query String to be used for SOQL …
- 937