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.

Filter by
Sorted by
Tagged with
0
votes
0answers
30 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 ...
2
votes
0answers
23 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/...
2
votes
1answer
191 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 ...
0
votes
0answers
34 views

Async API enabling issues

What am I missing? When I call async API through Apex(using "authorization" : "bearer " + userInfo.getSessionID trick), I get a 403. When I use the workbench I get {"message":"This feature is not ...
1
vote
1answer
288 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 ...
1
vote
2answers
92 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 ...
5
votes
0answers
110 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 ...
-2
votes
1answer
104 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
0answers
256 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'...
0
votes
1answer
756 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":"...
0
votes
0answers
63 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 ...