Questions tagged [data]

All Data related Queries

Filter by
Sorted by
Tagged with
0 votes
1 answer
18 views

LWC - Don't get the Data

With this code, I want to get the last stock value of my record respecting the condition and transfer the value in ‰ and take only the two digits after the decimal point. The problem I have is that I ...
user avatar
-1 votes
2 answers
36 views

how I will get all the record from QA to a fresh sandbox? [closed]

I want to get all the records in a fresh sandbox from QA. please guide me thanks
user avatar
0 votes
2 answers
50 views

Salesforce Data Dictionary Selective Standard + Custom Fields

I was tasked with creating a Data Dictionary to document fields and objects in my Salesforce Org. The dictionary would be a reference point to all teams that would be used to rationalize the existing ...
user avatar
  • 1,204
0 votes
2 answers
43 views

To display the spinner until all the data is rendered on the UI in LWC

<lightning-button-icon icon-name="utility:chevrondown" variant="bare" name="add-PickUpWindowSelect" ...
user avatar
  • 13
0 votes
1 answer
17 views

Finding fields for standard data types

I've been trying to complete a challenge on trailhead (link here) The text says "Create an Apex trigger that sets an account’s Shipping Postal Code to match the Billing Postal Code if the Match ...
user avatar
  • 3
0 votes
0 answers
11 views

Saving data in cache from Lightning Component in Mobile

i have a custom Lightning component displaying some data from a record, unfortunately on mobile, the data from the component isn't stored in cache like the data from the standard layout, so if the app ...
user avatar
2 votes
0 answers
44 views

Safely replace a packaged Master-Detail with Lookup

My active 1GP Managed Package app suffers from Account and Data skew (with ROW LOCKING) because we made a custom object AccountItem__c a child in a Master-Detail relation (MDR) ship with Account. As ...
user avatar
1 vote
2 answers
133 views

CPU Timeout Error When Inserting 2000 Records through Apex

I created an apex class that is activated by a button for a 1 time use insert of about 2000 enrollment records. The code works with small amounts of records but when with the full 2000 I get a ...
user avatar
-1 votes
1 answer
47 views

Converting CSV to an APEX List [closed]

I have a csv file downloaded with 1 column listing about 3000 names. What is the simplest way to grab all these names and store them in a List to be further manipulated in Apex? Thanks!
user avatar
0 votes
0 answers
16 views

LWC Component datatable

Hi all I am working on an lwc component datatable and I have a object named OpportunityContactRole related to the parent object Opportunity.Also another object named GrantContract is related to the ...
user avatar
0 votes
1 answer
79 views

SSJS Lookup All Rows from Data Extension Column as Array

So I have a "Master" Data Extension that has a ton of columns and rows (millions), and one column needs to have some changes made for specific rows based on Customer_ID. I have a ...
user avatar
  • 27
0 votes
0 answers
86 views

SFDMU - Deleting 30 Millions records

I deleted 30M records with SFDMU. The only issue I faced was that I have to update the Json file for every 900,000 records and re-trigger the job using sfdx sfdmu:run --targetusername Production. By ...
user avatar
0 votes
1 answer
20 views

Lookup filters based on values populated from junction object's parents

I have a junction object that connects a Lead to a Schedule object. This junction is called Schedule Registration. A user creates a Schedule Registration by locating a Schedule they want to register a ...
user avatar
-1 votes
1 answer
37 views

Salesforce Shield Encryption - official video showing invalid information

I was looking into Salesforce Shield Encryption. Apparently Salesforce Shield Encryption does not mask any data, but encrypts the data at rest, which means only at the database level. Anyone who has ...
user avatar
2 votes
0 answers
103 views

A summary formula field in report used to count sum of related lookup records is displaying incorrect value

I believe this question is somewhat related to Formula Field to Count Records in Lookup Relationshp. I have a 'primary' object called 'Tennis Player' and a 'secondary' object called 'Tennis Reports'. ...
user avatar
1 vote
1 answer
106 views

Does workbench store or cache data anywhere outside of Salesforce?

If you import a data file into workbench for querying or attempting to load into Salesforce, is it stored anywhere outside of Salesforce that may need to be purged?
user avatar
0 votes
1 answer
32 views

Tracking sends event from within app exchange > query studio

I'm trying to access send data from within a sql ui. We have 'QueryStudio' under app exchange which let's me query data extension tables. E.g. select AccountId from Contact_Salesforce Our data ...
user avatar
  • 107
1 vote
1 answer
298 views

Python Simple-Salesforce - Import related records with an external ID

Some time ago I've started to use Python with Pandas and Simple-Salesforce to make data migration to Salesforce orgs. I want to insert Account records and Contact records that have lookup to Account ...
user avatar
  • 121
3 votes
1 answer
245 views

SOQL SubQuery Parent-to-child-Junction Returns Child Records in Query Editor but not Apex. Any Idea why?

I have a Junction object for which I'm trying retrieve records in a subquery from one of it's parents and strangely the query returns child records when executing the query in SOQL Query Editor but it ...
user avatar
1 vote
1 answer
47 views

Restoring Contacts via developer console

I've deleted 260k contact records and want to undelete them via developer console. I tried this: undelete [SELECT Id FROM Contact WHERE IsDeleted = true ALL ROWS]; but when I click Execute I get the ...
user avatar
  • 11
0 votes
0 answers
32 views

How to keep Account Team when Account Owner is updated(mass update) via Data Loader?

How to keep Account Team when Account Owner is updated(mass update) via Data Loader? I am trying to do mass update on Account owner via data loader, but want to keep account team members as is. Is ...
user avatar
1 vote
1 answer
26 views

Bulk upload data with cumulusci

I am trying to bulk upload data with cumulusci. Is there any command to enable bulk mode? Any thing to append in the json while inserting the data
user avatar
0 votes
1 answer
147 views

How to pass the data from from a lightning-datatable to a column

I have the following data as an array: this.finalSObjectDataListChild = sObjectRelatedFieldListValues; console.log(this.finalSObjectDataListChild); From an icon-button on the row I trigger ...
user avatar
  • 2,068
1 vote
1 answer
62 views

How do I add active TDTM trigger handler records to an org with CumulusCI?

EDA and NPSP come with Table-Driven Trigger Management (TDTM), a trigger framework that uses records in a custom object to track which "trigger handler" Apex classes are active, rather than, ...
user avatar
  • 1,129
0 votes
1 answer
179 views

Formula to validate if a number of fields are empty

I am trying to create a formula that will return a number corresponding to the first field that is empty/blank within the fields listed in the formula. What I have so far seems to only add them. I ...
user avatar
  • 3
1 vote
0 answers
18 views

Delete CDP Connector

We are trying to update the schema of a CDP connector but it throws an error. When we added the schema to a new connector it worked as expected. However, we need the name of the first connector and ...
user avatar
0 votes
0 answers
14 views

Query and delete records off a Big Object

I've got an existing Big Object with millions of records in it. When it was originally built, only 1 unique ID field was indexed, and nothing else. I found this article from Salesforce that shows you ...
user avatar
0 votes
1 answer
37 views

Is it ok to store a bearer token in a custom field in the user object [closed]

I am about to create a salesforce app that eventually will be delivered to appExchange, this app has a setting page that requires the user to enter his token that he uses to consume an external API. ...
user avatar
1 vote
0 answers
114 views

DataLoader batch job failing with PricebookEntry upsert

I have an issue with our PRICE BOOK ENTRY Upsert using the DataLoader batch bulk job. We have External IDs in our PRICE BOOK and PRODUCT objects that we use when Upserting to our PRICE BOOK ENTRY ...
user avatar
  • 11
0 votes
0 answers
33 views

PK Chunking : message" : "The requested resource does not exist"

I enabled PK chunking in Full Copy Sanbox by following below steps: Can anyone tell me what mistake I am doing? Create Job XML <?xml version="1.0" encoding="UTF-8"?> <...
user avatar
  • 657
1 vote
1 answer
61 views

Data modeling - Vehicles in Salesforce

We are starting to think about how we want to model vehicles in Salesforce. We currently have service cloud and a new requirement arised around being able to track driver vehicles. The requirements ...
user avatar
  • 229
0 votes
2 answers
72 views

Salesforce Backup Process

I would like to be informed about Salesforce Backup Process (Security Management). I would like to know more about the Standard Recovery Process if any. How often is the Salesforce backup taken? ...
user avatar
0 votes
1 answer
924 views

this.template.querySelector works in parent template but not child template

I'm using the following in Javascript functions in LWC "var uiSection = this.template.querySelector('[data-id="sidebar"]');" to find a UI element with data-id=sidebar. This works ...
user avatar
0 votes
1 answer
64 views

Seeking API and permissions combination that faciulitates for read only exact target email data

I'm about to embark on my first SFMC project and am seeking some hand holding for getting started. Please be forgiving in that this question is more vague than typical on a stack exchange post and I'm ...
user avatar
  • 107
0 votes
1 answer
143 views

data upload error: id value of incorrect type

A member of our support team gave me a list of 100 Account ID's and their associated 'Customer Success Manager' in text form. I was asked to upload this data to salesforce, using Data Loader. I asked ...
user avatar
  • 79
1 vote
0 answers
41 views

Error from Rows.Add

I have the following script that returns the array as expected. When I go to add the "Rows.Add" aspect, I get a 500 error. I am testing the script on a cloudpage with plans to move it to an ...
user avatar
0 votes
0 answers
25 views

How can I see emails sent from Marketing Cloud on Salesforce Records other than the who coming from journeys? [duplicate]

I have read this thread : How can I see emails sent from Marketing Cloud on Salesforce Records?, but the method seems to work only for emails from journeys, is there a way to see all eblast sent? ...
user avatar
0 votes
0 answers
82 views

Data Loader Login Screen Change

I have attempted to find an answer but am struggling, and I'm a bit of a newbie with Salesforce / Data Loader, so apologies in advanced... I have been using Data Loader and was able to login ...
user avatar
0 votes
2 answers
132 views

Show all records with an invalid picklist value

Is there a simple way to reveal records that have incorrect picklist values? Example: Record A is created with restricted value Picklist__c value of "Aerospace" Picklist__c is updated ...
user avatar
  • 1,226
0 votes
1 answer
667 views

Lightning datatable displaying rows but values are not visible

I am trying to display Account records through dynamic SOQL, and I am getting the queried data in the console. Also, the result screen is displaying the rows with respect to that data, but the values ...
user avatar
0 votes
0 answers
122 views

Joining up data from multiple sfdx force:data:tree:export outputs [duplicate]

I have a 3 level deep graph of records that I would like to export: parent records, child records and a grand-child records. Reading this Example: Export and Import Data Between Orgs, I was interested ...
user avatar
  • 129k
1 vote
1 answer
242 views

Why can't I render list of related product in LWC

Problem : I have to display a list of products related to a package (which is related to an order), but I have 2 issues: Only one element of the list is displaying It's displaying the same element in ...
user avatar
  • 223
0 votes
1 answer
90 views

Cannot enable state and country picklist

I've gone through all the steps in order to convert the address fields into state and country picklists however when clicking 'Finish and Enable Picklists' nothing happens at all and I don't get a ...
user avatar
0 votes
1 answer
38 views

How to expose object fields to make accessible on reports?

I have a custom object in Order Management. I wanted a field within the object to appear on my Order report in reports. I couldn’t find the field in my field options. Anyone got any ideas? Thanks
user avatar
-1 votes
1 answer
196 views

Get user's last assignment (or re-assignment) to profile or permission set datetime

Is it possible? Let's say we have a lot of users, profiles and permsets. There is need to get last datetime when user was assigned to particular permset or profile using SOQL. Which fields could help?
user avatar
  • 687
2 votes
1 answer
125 views

Integration design: ETL vs. ETL + Apex

We need to load large volumes of data from external vendors into our Salesforce org on a daily basis. Because the format in which each vendor provides the data is different, we use an ETL tool to ...
user avatar
0 votes
2 answers
566 views

Multiple Users and LWC Data Refreshing

How would I update the data/view of another user when one user makes changes to a record via a lightning-record-form LWC? For example, User 1 edits an Account record and changes the phone number via ...
user avatar
  • 103
0 votes
1 answer
25 views

How to know if the managed package is comply with Privacy shield framework?

Is there any possibility/link to understand if the managed packages that we installed/built are complying with privacy shield framework? I didn't see any links or documents which shows the details on ...
user avatar
  • 500
0 votes
2 answers
180 views

Querying for users in a a Role based on Role Id instead of RoleName or DeveloperName

List<User> usrlst = [SELECT Id FROM User WHERE UserRole.DeveloperName LIKE : '%Customer_Support_Representative%' and IsActive = True]; The problem with this is that we changed the name of the ...
user avatar
2 votes
1 answer
91 views

SQL: How to get the right SUM of two different columns from two different data extensions into one new DE

I have the following tables: In the third table I want to combine these data with the SUM option in SQL so the total of clicks and Sends are in one field. Like this: I created the following query: ...
user avatar
  • 103

1
2 3 4 5
10