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 ...
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 ...
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") {
...
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 ...
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 ...
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 ...
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 ...
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 ...
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.
...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
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 ...
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%...
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....
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 ...
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....
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 ...
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 ...
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:
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
data × 528marketing-cloud × 108
apex × 72
dataextensions × 63
data-loader × 53
sql × 26
soql × 24
query × 20
integration × 20
import × 16
data-export × 15
visualforce × 13
lightning-web-components × 13
ampscript × 13
custom-object × 13
api × 12
reporting × 12
security × 12
sandbox × 12
trigger × 11
account × 11
bulk-api × 11
automation × 11
email × 10
migration × 10