Questions tagged [async-soql]
Async SOQL is a method for running SOQL queries when you can’t wait for the results in real time. These queries are run in the background over Salesforce entity data, standard objects, custom objects, and big objects. It provides a convenient way to query large amounts of data stored in Salesforce.
18 questions
0
votes
1
answer
49
views
SOQL having single quotes (') in the label value on PermissionSet record is not getting queried using the LIKE operator on the label field
Created a Permission set name : John's ps
Query to be run : SELECT Id, Label FROM PermissionSet where label like 'John\'s ps'
Result : [object Object]: MALFORMED_QUERY: CustomPermissionSet WHERE ...
10
votes
2
answers
790
views
Async SOQL retirement
I see the note Asyc SOQL is scheduled for retirement in all Salesforce orgs as of Spring ’22 on SOQL and SOSL Reference.
Is this a glitch in the documentation?
- 2,511
3
votes
1
answer
619
views
How to run an Async SOQL query other than via Workbench
In Workbench, one can perform Async SOQL queries like so:
However, Workbench is strictly speaking not a Salesforce supported product. Is there another tool from which one can execute Async SOQL?
- 3,762
0
votes
1
answer
934
views
How to list all record ids if "SELECT Id FROM ObjectName" returns fails with QUERY_TIMEOUT?
I need literally all the records. Documentation says that if I hit 120 sec. limit then I should refactor my query to retrieve less amount of data. The only option not to skip data but collect it part ...
15
votes
1
answer
2k
views
How to archive & restore Custom Objects in Big Objects
For my app I want to build a Archive and Restore functionality. For a given Custom Object MyObject__c and a Big Object ArchivedMyObject__b those requirements need to be fulfilled:
MyObject__c records ...
- 38.2k
0
votes
0
answers
119
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 ...
- 15
-2
votes
1
answer
378
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<...
- 27
0
votes
1
answer
1k
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 '...
- 1
0
votes
0
answers
40
views
Batch Class and SOQL Implications: 1% of the time a record gets updated that shouldn't
pretty high level question here based on some of the erroneous updates I'm seeing (less than 1% of total records processed).
I'm currently running a batch class (50 record batch size).
It is a ...
- 1,482
2
votes
0
answers
171
views
How to map static date field in Async SOQL query job?
I'm trying to use Aggregate Async SOQL to Query Big Objects to a custom Object like below (https://developer.salesforce.com/docs/atlas.en-us.chatterapi.meta/chatterapi/...
- 1,391
2
votes
1
answer
3k
views
How do SOQL queries act in Queueable (async) apex?
I have a set of 4 Queueable apex classes that perform an ordered series of tasks on a large number of records. It queries a limited number of records, modifies them so that they no longer meet the ...
- 65
2
votes
1
answer
2k
views
How to query non-index field on Big Object?
I'm learning Big Object on trailhead and I have completed deploy the big object to my org.
But I have a question is that: how can I query non-index field by SOQL? I know that only index fields can ...
- 146
1
vote
2
answers
211
views
SOQL governor reached using multiple strike_lookup
I'm developing a custom lighting component, in which I have a table with 2 columns, each cell is composed by a strike_lookup
Everything works as expected until I have too many rows, thus too many ...
- 215
5
votes
0
answers
291
views
ASYNC SOQL "Do Not Have Permission To Query This Object Using ASYNC SOQL"
We have purchased extra Big Objects space from Salesforce which I was advised was a requirement in order to use ASYNC SOQL.
I am now faced with this issue which I run into every time I try to Query ...
- 101
-2
votes
1
answer
205
views
Help in writing Asynchronous Batch Apex to avoid governor limit of 150 records
I have a function that has the DML operation inside the for loop due to which I am running into governor limit exception of 150 records. I read about batch apex on Salesforce discussion about not sure ...
2
votes
0
answers
366
views
Async SOQL Query - Insufficient_Access
I'm trying to learn Async Soql, and messing around with simple test scenarios. I've reached a block where I'm just trying to move the name of Account and create a new Custom Object with that name. I'...
- 21
0
votes
1
answer
2k
views
How to do I enable asyncquery for developer salesforce org
I get the following error when I try to run an async soql query in workbench
{"message":"This feature is not currently enabled for this user type
or org: [AsyncQuery]","errorCode":"...
- 315
0
votes
1
answer
177
views
Async SOQL - is there a way to export the result into a .csv file or so instead of inserting into target object
I am just going through the async SOQL guide. I am finding it very useful as we often have large SOQL queries which runs over time limit.
But it seems to me that the result of the async SOQL can ...
- 13k