Hot answers tagged

38 votes
Accepted

Why Are Data Silos Important in Unit Tests?

I think the answer is quite simply one of consistency. It's also one of minimizing variations between environments we test in. This makes our test more consistent and repeatable. These are all things ...
crmprogdev's user avatar
  • 40.9k
30 votes

Why Are Data Silos Important in Unit Tests?

In two words: "bitter experience" I will admit that if you don't have any asserts in your code (another topic) you run a lesser risk but, the reasons all have to do with repeatability/predictability ...
cropredy's user avatar
  • 69.9k
20 votes
Accepted

Parent Field in Lightning Datatable

Doing the "flattening" as mentioned in Winter 18 <lightning:datatable> does not get values from a parent record can be simple if everything is hard coded: if (state === "SUCCESS") { ...
Keith C's user avatar
  • 135k
16 votes

Why Are Data Silos Important in Unit Tests?

Another point to add to cropredy's excellent list is that tests have significant value as a specification of what the code being tested does. But that only works if you can see the inputs (often the ...
Keith C's user avatar
  • 135k
16 votes
Accepted

what happens when you reach your data storage limit in an org?

what happens when I reach my data limit in org? Strictly speaking, nothing typically happens at 100% storage usage, except that Salesforce starts to notify administrators daily by email about storage ...
sfdcfox's user avatar
  • 481k
15 votes

Can I use SalesforceDX to load data into sandboxes?

The short answer is: yes. All of the commands in the force:data command namespace work on any edition of Salesforce any org (provided API is enabled on that org). The long answer is: it depends on ...
pchittum's user avatar
  • 19.6k
11 votes
Accepted

What is the difference between using the LIMIT clause and using a fixed index to retrieve data from a query?

actually, there is a difference, in current example it impacts on total number of records retrieved by SOQL queries limits. Limits is one of the most important challenge working with salesforce ...
Oleksandr Berehovskyi's user avatar
9 votes
Accepted

Uploading 100,000 binary files as attachments to Case record - best approach

I would suggest you to go with data loader using SOAP API, which is by default (not Bulk API). Why? You do not need to write any code to use Data loader It is tested solution, so no bugs With ...
AtulRajguru9's user avatar
  • 9,110
9 votes
Accepted

DE Special Character when importing from a CSV

Your source data file might not be encoded properly, from the H&T portal, Why isn’t Data Loader importing special characters? Make any modifications to your source data file in .xls format. ...
glls's user avatar
  • 20k
8 votes

How can I see emails sent from Marketing Cloud on Salesforce Records?

This is a standard feature of the Marketing Cloud Connector. It is built by default to transmit the tracking information back to Salesforce. Here's what you need to do In Marketing Cloud - Tracking ...
Rajdeep Singh's user avatar
8 votes
Accepted

sObject type 'Pricebook2__c' is not supported

It's hard to tell what data you're even working with, but the standard object name is simply Pricebook2 (no underscores). If you are trying to insert a record looking up to this object (such as ...
Adrian Larson's user avatar
  • 149k
8 votes
Accepted

UNABLE_TO_LOCK_ROW error during inserting a new Record

There are lots of situations where an insert can cause a record lock against the parent of the inserted record, or even against third records. Inserting Task, for example, can lock the WhoId, WhatId, ...
David Reed's user avatar
  • 92.1k
8 votes
Accepted

Can't assign permission set to my user after installing Salesforce Data Mask!

It was not really clear from the announcement or from most of the documentation, but Salesforce Data Mask is actually a paid feature, and if you want to use it you need to talk to your Account Execute ...
Renato Oliveira's user avatar
7 votes
Accepted

Struggling at logging into dataloader

You have two options here. Either download Apex dataloader latest version which support TLS 1.2 and second not so good option is disable this update in your org. The following steps can be followed ...
Tushar Sharma's user avatar
7 votes
Accepted

can i run an automation only when a data extension have data or records?

There is a new Verification Activity in Automation Studio. You can set this to verify if there are no subscribers in DE then stop the automation. This will prevent the error. New Verification ...
Gortonington's user avatar
  • 30.3k
7 votes
Accepted

Can I use SalesforceDX to load data into sandboxes?

You also can take a look at the SFDX plugin called SFDX-Data-Move-Utility. I took part in development of this plugin, which is hosted in the forcedotcom GitHub account under the BSD 3-Clause license ...
Haim K.'s user avatar
  • 111
6 votes

Can I choose which records are copied in a Partial Copy sandbox?

There are no guarantees of what records are copied to a partial sandbox. You get 10,000 random records of each object included in your template. There's not even a guarantee that you'll get all child ...
DavidSchach's user avatar
  • 5,825
6 votes
Accepted

Org Benchmarking?

Salesforce doesn't experience any performance penalty as you near your org's capacity. Each large object has no effect on the performance of small objects. Your org will run just as efficiently at 105%...
sfdcfox's user avatar
  • 481k
6 votes
Accepted

How to import accounts without contacts using Data Import Wizard?

Choose Accounts and Contacts on the first step, and proceed through the wizard. Simply unmap all of the contact fields. If no contact fields are mapped for import, the wizard will only import accounts....
sfdcfox's user avatar
  • 481k
6 votes
Accepted

Can Lightning Data Service include data from Parent-Child relationships?

Using the Lightning Data Service - Considerations page as reference, it appears that currently you are able to work with data across spanning relationships (lookup, master-detail) but not collections ...
Mark Pond's user avatar
  • 22.9k
6 votes
Accepted

Client-side custom data caching

It's best to work with the framework, so I suggest that you have a read about the caching that Lightning offers Storable actions Lightning Data Service Custom cache See: https://developer....
Aidan's user avatar
  • 13.5k
6 votes
Accepted

Marketing Cloud to s3

You can’t do this directly between SFMC and S3. However, AWS has launched their fully managed SFTP service for S3 last year. If you have management access to the AWS environment and can configure this ...
Lukas Lunow's user avatar
  • 20.6k
5 votes
Accepted

profile object permissions for a detail record

This refers to objects which are related by the master detail relationship. In case of such relationships we have two objects - parent ( usually referred as Master) and child(referred as detail). When ...
Shailesh Deshpande's user avatar
5 votes
Accepted

How to touch all records in an object to run a trigger?

For any reasonable size value, you need to either use the Data Loader, or use Batch Apex. I personally have a Batch Apex class that I use for this purpose, which I can call execute anonymous like so: ...
sfdcfox's user avatar
  • 481k
5 votes

what update type to use in query for adding and updating in data extension

These are what the 3 query types are: Append: Will only add records to the table without affecting the existing records. Update: Will update existing records if their is a match or will add the ...
thechrishaddad's user avatar
5 votes
Accepted

what update type to use in query for adding and updating in data extension

EDIT Based on the comments below, this may be your best answer: SELECT * FROM SourceDE s LEFT JOIN DestinationDE d ON s.PrimaryKey = d.PrimaryKey WHERE d.PrimaryKey IS NULL This will force an ...
Gortonington's user avatar
  • 30.3k
5 votes
Accepted

can i decrease the length of a column in data extension

There is no way to directly decrease the size of an existing text field. The easiest way to handle this is to: Export the data from your existing DE. Clear your DE Delete the existing field Create a ...
Gortonington's user avatar
  • 30.3k
5 votes
Accepted

Batch Apex - How to Handle Many SOQL Queries

This is a broad area and the right solution is going to be somewhat specific to your data and Type model and highly dependent on your data volume in Account and the child objects thereof. I see two ...
David Reed's user avatar
  • 92.1k
5 votes

Synchronized Data Extensions

Try the following SQL query to copy data from a Salesforce Synchronised Data Extension to a regular Data Extension. Following example is based on the Account object. SELECT * FROM ...
Rain's user avatar
  • 5,690
5 votes
Accepted

Does field length matter much in performance

For normal objects, there's no difference in performance. For Custom Settings and Custom Metadata, allocating too much space will affect the number of settings/metadata records you can create, but ...
sfdcfox's user avatar
  • 481k

Only top scored, non community-wiki answers of a minimum length are eligible