Questions tagged [data]

All Data related Queries

Filter by
Sorted by
Tagged with
1
vote
1answer
38 views

How to query only accounts that don't have attachments

Use Case: get all accounts that don't have a related attachment I have used this query but I get an error when I add the Bold part SELECT Id, (SELECT Id, StageName FROM Opportunities WHERE StageName = ...
0
votes
1answer
19 views

Customizing Salesforce chunk size

Is there a way to set the chunk size of an import/update for Salesforce? I hit apex limits when importing records due to automation (Process builder/flow) that I have setup. I use Skyvia import tool. ...
2
votes
1answer
37 views

When LWC invokes a function, is it possible for the function to access arbitrary attributes in the invoking element?

Let's say my LWC has the following code: <c-widget-tile widget={widget} onwidgetselect={openWidget}></c-widget-tile> Assuming widget contains the data for an instance of Widget__c Is it ...
0
votes
1answer
18 views

List all existing Flows as options in a Custom Object field

I am working on a project and I want to create a Custom Object that has as a field a lookup for flows. I would like to know if there is some kind of way to retrieve all existing flows in one org and ...
0
votes
1answer
26 views

How to insert new records into the custom object using Data Loader which has “Master-Detail” relationship with Account?

I have an Account object and a custom object "B" where Account is Master and "B" is Child. I already have Account data and I am looking for inserting records in "B" using ...
1
vote
1answer
48 views

Data from _SENT data view not ready when I need it

I have created a "daily sent" email that gets it's content from data pulled from the _SENT and _JOB data views. The query runs at 4:00 and with most emails finished sending by about 2:00 it ...
0
votes
2answers
24 views

How many Email Alerts and Task can be created on an Object?

How many Email Alerts and Tasks can be created on an Object? Is there any documentation that gives details about the limits of creating Metadata Components in salesforce? Thanks
0
votes
0answers
10 views

Data Export (Weekly Export Service) Does not Include Chatter Object Feeds or FeedItems

Seems the Data Export service in Salesforce does not allow you to export Chatter Object__Feed nor FeedItem. Chatter Object Structure: https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/...
2
votes
0answers
69 views

ERROR running force:data:tree:import: The requested resource does not exist when using force:data:tree:import

I'm having some trouble with importing Json file which containing data in SObject using sfdx force:data:tree:import -p ./data/Project__c-Round__c-plan.json It spits out an error which is: ERROR ...
0
votes
0answers
14 views

Top 15 most recent JOBIDs for a subscriberkey

I am trying to write a query that can help us identify out of the 15 most recent JOBIDs a subscriberkey received, how many were opened? My thinking is to break this up into a few queries: 1. A query ...
0
votes
0answers
21 views

Data Model Architecture - More Fields or New Object

I am reassessing an existing data model in use in my org and looking to ensure it's following best practices. The custom object is called a ticket. If the ticket record meets certain criteria, it is ...
0
votes
1answer
30 views

Trouble with sfdx force:data:bulk:upsert to do a basic import

We are looking to automate the creation of demo orgs using Scratch orgs. We have a very light data set that we want to include in our scratch org, but it is highly relational. We are looking to get ...
0
votes
1answer
34 views

SentEvent and Send properties in SOAP API

I have data that I am retrieving using SentEvent (https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/sentevent.htm) and Send (https://developer.salesforce.com/docs/atlas....
0
votes
1answer
41 views

Salesforce Data Mask and Workflows / Process Builder deactivation

I'm trying out Salesforce's Data Mask feature and in the docs (https://help.salesforce.com/articleView?id=data_mask_considerations.htm&type=5) it mentions that all workflows (and presumably ...
0
votes
0answers
9 views

Has anyone found an accurate way to measure handle time per agent touch per case?

Both handle time and active time stop calculating once an agent closes the tab. Assigned cases never record handle nor active time. We're struggling to find a truly accurate way to measure how long ...
0
votes
1answer
23 views

SOQL select archived product2 records

There are some records in one of the custom objects that relate (lookup) to archived product2 records. I am unable to select archived Prodcut2 records even though I can access them via UI... I am ...
0
votes
1answer
528 views

LWC (Lightning Web Component) Data-Table Header Level Actions

I have a LWC Data-Table in which I am displaying Activity currently. I have three columns in the data table: Subject, Comments, Activity Date. I would like to add a header level action to the Subject ...
0
votes
0answers
16 views

Best Practices to Upsert records from External Database to Salesforce using jitterbit

My task is to maintain data consistency between external database and salesforce. The external database is the source of truth for Contacts and Accounts, and the association between AccountContacts. ...
0
votes
2answers
42 views

calculate day difference between orders [closed]

I need to calculate the day difference between orders to be able to calculate the next prediction date of this order. I'm now focusing to find the day difference between orders. My assumption was to ...
0
votes
1answer
36 views

Questions using Workbench: Aborting data upload; modify the batch size; turn off the auto-mapping

I use API version 47.0 I've been testing out the usage of Workbench in our sandbox and had some questions: How do I abort a data upload in Workbench without having to go into setup in Salesforce ...
2
votes
1answer
80 views

Blob is not a Valid UTF-8 String - Only after “–” [duplicate]

I created a CSV parser that parses CSV's from static resources. I am returned with a Blob is not a Valid UTF-8 String error when parsing the character: "–" different from "-". The "–" is apparently ...
3
votes
1answer
212 views

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

After installing the Salesforce Data Mask managed package in my org I get the following error when trying to assign the permission set to my user: Can't assign permission set Data Mask to user ...
1
vote
2answers
37 views

Journey Data View

I just wanted to ask, if I have a journey that was created 6 months back, but I created a new version of the journey within 6 months, will the data view of journey give me the data for this journey or ...
-1
votes
1answer
261 views

LWC (Lightning Web Component) - Properly accessing Data and placing into Lightning Data Table

I have a custom APEX Class that returns two sets of data (Activities & Notes), I would like to individually access each of those arrays of data and place them into separate Lightning Data Tables. ...
1
vote
1answer
372 views

Return an Instance of a Class in a LWC (Lightning Web Component)

Below I am Trying to Return an Instance of a Class to a LWC JS to then handle and display to the End User. I am able to successfully call the Apex Class and Method and return data, but the data is ...
0
votes
0answers
18 views

If I intend to use Person Accounts but need to get contacts into Salesforce before this can be enabled, should I keep contacts 'private'?

I'd just like to understand the implications of this as we unfortunately need to hit an unmovable deadline and having contacts in the Salesforce or is necessary for our Marketing Cloud deadline (we're ...
0
votes
0answers
15 views

Deactivate Data Connector for Salesforce Google Sheets

I know this is somewhat of a reverse question, but it there a way to block Data Connector for Salesforce. Users can view their data in the platform, and have all the tools to manipulate it, but we don'...
0
votes
0answers
11 views

Append in query keeps re-adding same data

Below is my query, I have append selected in my automation and insert it into an FTP. I am querying data views. The problem is the same records keep being added every file creation (%%Year%%%%Month%%...
1
vote
1answer
46 views

Name field and FirstName & LastName for classic email templates

I've just noticed that the merge field for classic email templates for Opportunity Owner or Account Owner is something like {!Opportunity.OwnerFullName} and but the FullName field is not available to ...
0
votes
0answers
51 views

Running Total in the Dataflow

I am trying to use computerelative transformation to calculate running total and running into this error: Transform dim/mea not found in Edgemart My SAQL is case when previous('weeklymeasure') ==...
1
vote
2answers
74 views

Questions: Migrate data from one organization to another

I am in the process of planning out and executing how we're going to migrate data from one SF organization to another. I want to make sure I do this properly. Based on https://help.salesforce.com/...
2
votes
0answers
34 views

how to deduplicate millions of records of custom objects [closed]

In an org of a client we have about 170 million records of mostly custom objects, with some single custom objects having as much as 70 million records on their own. The problem is that for about 10 ...
2
votes
1answer
25 views

What effect does FOR UPDATE have on pending inserts?

FOR UPDATE will lock a row to prevent other clients from accessing it, as is well documented. Does FOR UPDATE have an effect on pending inserts from concurrent clients as well? For example, assume ...
0
votes
1answer
44 views

Updating Accounts without the ID

What would be the most efficient way to update an excel sheet with 400 accounts that do not have an ID nor external ID of accounts that exist in the system. There are about 40,000 accounts in ...
0
votes
0answers
28 views

Uploading speed to Salesforce Marketing Cloud SFTP

Is there anyway we can increase uploading speed to Salesforce Marketing Cloud SFTP SFTP? Our data size is quite huge and with current speed (maximum 2MB/sec) it's taking quite a lot of time to upload ...
2
votes
1answer
50 views

How to Set up Contacts in Marketing Cloud to populate records from Personalization Builder Data Extension

I worked on Personalization Builder and collected data about users based on collection codes set up on a demo webpage. The data is in the Standard Personalization Builder Data Extension. IGO_PROFILES ...
0
votes
0answers
23 views

Formatting data on a lightning component without using lightningrecordform

So, I am currently working on a call out to another service outside of Salesforce. I have made the call out and am successfully returning data from the service outside Salesforce. So, my question is ...
3
votes
1answer
43 views

Using Salesforce as Single Source of Truth [closed]

From a software architecture perspective, are there major issues with using Salesforce as an application's single source of truth (as opposed to a traditional relational database like Postgres)? It ...
0
votes
1answer
29 views

Dataloader Command line error

I need to be able to run Data Loader from the command line (we need a scheduled import/export of data once per day). I created the conf file but get the error message below when I run the proccess.bat ...
0
votes
1answer
54 views

Outbound Email Message empty Attachment Related List

When sending an email, the person receiving it gets both the body text and the attachment being sent out along with it. So it sends out correctly. When I go into the activity history related list and ...
0
votes
1answer
20 views

Unravel table links

What are the relationship links (field names and any other tables used to link) between the four tables below: Account Opportunity Quote User Thanks you for any help
0
votes
0answers
226 views

How does Potential Duplicate Component and Duplicate Record Sets work?

TLDR: Can we retrieve duplicate records in 'View Duplicates' using Apex or SOQL. Details I am planning to create a list view with a column of 'View Duplicates' link or button. Similar to below image ...
1
vote
0answers
23 views

Providing a list of data to non-users securely [closed]

We have a requirement to send data to a list of people who are not users. This data is, and should be treated as, highly secure. These people are owed this data and are allowed to view it but it ...
2
votes
1answer
35 views

Trying to conserve data consumption using record Types?

So, I've been working on a Project where there is a very large volume of data that is kept and there is a relatively low amount of traffic, so it can afford more strain in terms of process/IO. I'd ...
0
votes
0answers
9 views

Salesforce CLI data tree command load Account with User lookup

I want to export and import an account record that has a custom field lookup to User table. I was able to do that with Account and Contact. But I am not able to get User- Account relationship.Is there ...
1
vote
1answer
60 views

Query to compare branches of a journey after a percentage split

I ran a journey where I used a decision split to separate the audience into 4 branches and then sent each branch the same series of emails with varying wait times in between sends. Now I want to ...
0
votes
0answers
56 views

Exceeded max length for one record data loader

How can I spot which record exceeds the limit shown by data loader when I try to insert the CSV in my 'to' salesforce environement? The same files export fine in my 'from' environment. I have tried ...
0
votes
0answers
15 views

In Classic, how can I track the productivity of my team cleaning up records?

Prereqs: Team of 6 employees @ 8/hours a day for 1-2 weeks 25,000-35,000 total records affected (Likely won't get to them all) Various issues -- missing address, missing phone number, "Unknown Last ...
0
votes
1answer
50 views

Help with the SOQL query on multiple objects

Need SOQL or SOSL query to return the Accounts Name having at least a Partner, and/or Contact and/or an Activity attached to it. So far i am able to get the account name where owner ID is '...
0
votes
0answers
17 views

how to restrict visibility of text field rows of values based on user's accountshare on a single record

I have requirement to create an alert everyday displaying list of calls submitted by users sharing same set of accounts over last 7 days. But the text field should display selective values for user ...

1
2 3 4 5
9