Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Hot answers tagged

37 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 ...
user avatar
  • 40.3k
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 ...
user avatar
  • 61.5k
19 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") { ...
user avatar
  • 129k
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 ...
user avatar
  • 129k
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 ...
user avatar
  • 430k
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 ...
user avatar
  • 19.1k
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 ...
user avatar
10 votes
Accepted

Contacts without Accounts: Is it possible, and if not, why?

Your understanding is correct; SFDC unashamedly assumes you're using a standard Sales-y workflow with Accounts and Contacts. I'm not sure there's a really good alternative here. Some options might be:...
user avatar
9 votes

Return different data type using only one method

You can set return type of the Apex method to Object. public Object returnVariousDataType(String dataType){ //write something if(dataType == 'String'){ // return String return ...
user avatar
  • 573
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 ...
user avatar
  • 8,980
8 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. ...
user avatar
  • 19.2k
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 ...
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 ...
user avatar
  • 27.9k
7 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 ...
user avatar
  • 142k
7 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 ...
user avatar
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....
user avatar
  • 430k
6 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 ...
user avatar
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 ...
user avatar
  • 22.3k
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....
user avatar
  • 12.7k
6 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, ...
user avatar
  • 86.3k
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 ...
user avatar
  • 16.9k
5 votes

Import excel csv data using apex class

Providing the CSV files are not too big, you can use a Visualforce apex:inputFile to upload the file and then apply this Parse a CSV with Apex sample code to grab the data from the rows. If the CSV ...
user avatar
  • 129k
5 votes

Copy Data from Production to Sandbox after sandbox refresh

If you're trying to populate your Developer sandbox, you should use an app like SFXOrgData (http://www.sfapex.com) which will copy data from your Production/Sandbox to another Sandbox (i.e. your ...
user avatar
5 votes
Accepted

Size of "Weekly Export" vs. "Data Storage" is different, why?

Short Answer: The data storage size reported by Salesforce is based on a fixed size per record type and little relation to how many bytes it would take to store that data in a database. The Weekly ...
user avatar
5 votes
Accepted

How to load data into salesforce when I've run out of licenses?

You need a license to be able to upload data. There is no other way. You could consider temporarily (e.g. outside of office hours) deactivating a Sales Rep license and assigning the license to your ...
user avatar
5 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 ...
user avatar
  • 5,598
5 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%...
user avatar
  • 430k
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 ...
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 ...
user avatar
  • 27.9k
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 ...
user avatar
  • 27.9k

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