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") {
...
- 137k
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 ...
- 502k
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 ...
- 19.8k
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 ...
- 18.8k
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.
...
- 20.3k
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 ...
- 485
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 ...
- 151k
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, ...
- 93.6k
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 ...
- 14.4k
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 ...
- 30.8k
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 ...
- 111
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....
- 502k
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 ...
- 5,966
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 ...
- 23.1k
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....
- 14k
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 ...
- 22.2k
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 ...
- 1,569
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 ...
- 30.8k
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 ...
- 30.8k
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 ...
- 93.6k
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,794
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 ...
- 502k
5
votes
What is the difference between using the LIMIT clause and using a fixed index to retrieve data from a query?
I'll just add to Alexander's answer.
As per the documentation for ORDER BY here
There is no guarantee of the order of results unless you use an ORDER BY clause in a query
So if you don't use ORDER ...
- 2,785
5
votes
Accepted
SFDX commands to export and import related objects
It appears that all your objects are related together. You can use parent queries in your SOQL:
sfdx force:data:tree:export --outputdir data --plan --query \
"SELECT Name, lkp_Account__r.Name, ...
- 502k
5
votes
Accepted
Marketing Cloud Disaster Recovery
There is a comprehensive backup solution in place, so you should not worry about your data being lost forever. For Salesforce Marketing Cloud, customer data is automatically replicated on a near real-...
- 22.2k
5
votes
Accepted
Return an Instance of a Class in a LWC (Lightning Web Component)
Is this currently possible with a LWC or do I have to change my overall approach?
You just need a minor tweak.
Is there an issue with the way I am calling the Apex Method/Class?
Nope.
Is there ...
- 502k
5
votes
Retrieve data from now to last hour of modified time in SOQL
HOUR_IN_DAY returns a number representing the hour in the day for a Datetime field, i.e. if LastModifiedDate is 2024-09-16T23:52:46Z, HOUR_IN_DAY(LastModifiedDate) returns 23
Therefore it isn't the ...
- 9,567
4
votes
Is it possible to get data storage details of a Salesforce organization using Apex code
This has been made possible by now via the OrgLimits class [1].
Map<String,System.OrgLimit> limitsMap = OrgLimits.getMap();
System.OrgLimit fileStorage = limitsMap.get('FileStorageMB');
System....
- 121
4
votes
Accepted
Facing record lock issue on Parent when loading millions records
Your suggestions are all valid in there own right, but they do become dependent on your data.
I would lean towards #3 the most, as that is what I most often do (because it works with most of my data ...
- 2,726
4
votes
Accepted
Recover data lost in a field while doing data type conversion
You could always go through the Data Restoration Service, but it takes about three weeks and $10,000 (USD). Unfortunately, if you didn't back up the data yourself, there's no way to get it back ...
- 502k
Only top scored, non community-wiki answers of a minimum length are eligible