Difference between Export & Export All in Data Loader

Difference between Export & Export All in data loader is really interesting.


It was asked this question in one of my job interviews.


There are two buttons available in the data loader ‘Export’ & ‘Export All’. The difference in both button functionality is very small. When we use the ‘Export’ button for any object in Salesforce, all records( excluding records present in Recycle Bin) present in the system for that particular object are exported to a .csv file. But when we use Export All, all records (including records present in Recycle Bin) for that particular object are exported to a .csv file. Deleted records present in the recycle bin are also called ‘soft Deleted’ records.

When you choose fields to be extracted using a data loader, you can select the IsDeleted field as well because it tells which record is soft-deleted and which is not.


(IsDeleted = true) –> record has been soft deleted.

(IsDeleted = false) –> record has not been deleted.

I clicked on Export All and in the screenshot below, you can see there are some records for which IsDeleted is true. These are some records that were present in the recycle bin(soft deleted).

IsDeleted


For more reference on data loader, Go to Data Loader Reference


Comments

Post a Comment

Popular posts from this blog

Adding a red asterisk to required fields using label in LWC

Image
I am trying to add a double or single asterisk to lightning: input tags in LWC, by using "required" tag inside the tag I am able to see the asterisk, but two issues with this are I have to show a red asterisk to some conditionally mandatory issues. Solution -  You can use  label-hidden  variant and put a label. <template> <label>Middle Name</label> <abbr title="required" class="slds-required">**</abbr> <lightning-input label="Middle Name" variant="label-hidden" aria-required="true" maxlength="80"></lightning-input> </template>
Read more

The Developer Console didn't set the DEVELOPER_LOG trace flag on your user. Having an active trace flag triggers debug logging. You have 1,978 MB of the maximum 1,000 MB of debug logs. Before you can edit trace flags, delete some debug logs.

1. In developer console, Select tab "Query Editor" at the bottom of the console. 2. Select check box "Use Tooling API". 3. Execute the below query: SELECT Id FROM ApexLog   4. Select All Rows. Click the first row and then press Shift button and click last row to select all the rows. Delete all rows using Delete button. https://help.salesforce.com/articleView?id=code_debug_log_delete.htm&type=5
Read more

Salesforce: Serial and Parallel Approval

Image
Approval process has been introduced in Salesforce platform sometimes back. But when someone ask you, if Salesforce support Parallel and Serial approval process? The answer is YES, although Salesforce do not implicitly said it is parallel or serial approval process. The good thing is, this functionality available out of the box. So you do not need to write any code. Just with point and click configuration, you can build this process within hours. Parallel Approval Parallel Approval means you are sending multiple approvals out in one step of the approval process. Any approver able to approve without need to wait for other approvers to approve. The approver can be specific  users ,  a queue  or  related user  in the record. How to configure this in Salesforce? When you reach Approval Steps -  Select Assigned Approver , choose  Automatically assign to approver(s) In sample above, when user submit for approval, it will go to a user 'Maria Ann' a...
Read more