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
1answer
30 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 '...
0
votes
0answers
32 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
35 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
403 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 ...
2
votes
1answer
419 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
120 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
120 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
109 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
275 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
900 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
74 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 ...