Skip to main content
Salesforce

Return to Question

deleted 5 characters in body
Source Link
Matt Lacey ♦
Matt Lacey ♦
  • 25.8k
  • 7
  • 68
  • 153

I am retrieving attachments through jitter bit SOQL query, but my all records are not retrieving through in the bulk so I have set the limit of 1000 but when I have download next 1000 records whohow can I will skip first 1000 records from the SOQL query, I have tried OFFSET but it is giving the result only 1 record . Can you please help in this.

SOQL Query:

SELECT Id, Body, BodyLength, ConnectionReceivedId, ConnectionSentId, ContentType, CreatedById, CreatedDate, Description, IsDeleted, IsPartnerShared, IsPrivate, LastModifiedById, LastModifiedDate, Name, OwnerId, ParentId, SystemModstamp FROM Attachment order by Id limit 1000

I am retrieving attachments through jitter bit SOQL query, but my all records are not retrieving through in the bulk so I have set the limit of 1000 but when I have download next 1000 records who can I will skip first 1000 records from the SOQL query, I have tried OFFSET but it is giving the result only 1 record . Can you please help in this.

SOQL Query:

SELECT Id, Body, BodyLength, ConnectionReceivedId, ConnectionSentId, ContentType, CreatedById, CreatedDate, Description, IsDeleted, IsPartnerShared, IsPrivate, LastModifiedById, LastModifiedDate, Name, OwnerId, ParentId, SystemModstamp FROM Attachment order by Id limit 1000

I am retrieving attachments through jitter bit SOQL query, but my all records are not retrieving through in the bulk so I have set the limit of 1000 but when I have download next 1000 records how can I skip first 1000 records from the SOQL query, I have tried OFFSET but it is giving the result only 1 record . Can you please help in this.

SOQL Query:

SELECT Id, Body, BodyLength, ConnectionReceivedId, ConnectionSentId, ContentType, CreatedById, CreatedDate, Description, IsDeleted, IsPartnerShared, IsPrivate, LastModifiedById, LastModifiedDate, Name, OwnerId, ParentId, SystemModstamp FROM Attachment order by Id limit 1000
added 279 characters in body
Source Link
Oleksandr Berehovskyi
Oleksandr Berehovskyi
  • 18.8k
  • 4
  • 46
  • 65

I am retrieving attachments through jitter bit SOQL query, but my all records are not retrieving through in the bulk so I have set the limit of 1000 but when I have download next 1000 records who can I will skip first 1000 records from the SOQL query, I have tried OFFSET but it is giving the result only 1 record . Can you please help in this.

Thanks in AdvanceSOQL Query:

SELECT Id, Body, BodyLength, ConnectionReceivedId, ConnectionSentId, ContentType, CreatedById, CreatedDate, Description, IsDeleted, IsPartnerShared, IsPrivate, LastModifiedById, LastModifiedDate, Name, OwnerId, ParentId, SystemModstamp FROM Attachment order by Id limit 1000

I am retrieving attachments through jitter bit SOQL query, but my all records are not retrieving through in the bulk so I have set the limit of 1000 but when I have download next 1000 records who can I will skip first 1000 records from the SOQL query, I have tried OFFSET but it is giving the result only 1 record . Can you please help in this.

Thanks in Advance

I am retrieving attachments through jitter bit SOQL query, but my all records are not retrieving through in the bulk so I have set the limit of 1000 but when I have download next 1000 records who can I will skip first 1000 records from the SOQL query, I have tried OFFSET but it is giving the result only 1 record . Can you please help in this.

SOQL Query:

SELECT Id, Body, BodyLength, ConnectionReceivedId, ConnectionSentId, ContentType, CreatedById, CreatedDate, Description, IsDeleted, IsPartnerShared, IsPrivate, LastModifiedById, LastModifiedDate, Name, OwnerId, ParentId, SystemModstamp FROM Attachment order by Id limit 1000
Source Link
Dev bluCursor
Dev bluCursor
  • 17
  • 6

How can we skip the some records through SOQL

I am retrieving attachments through jitter bit SOQL query, but my all records are not retrieving through in the bulk so I have set the limit of 1000 but when I have download next 1000 records who can I will skip first 1000 records from the SOQL query, I have tried OFFSET but it is giving the result only 1 record . Can you please help in this.

Thanks in Advance