Skip to main content

Questions tagged [database]

The tag has no usage guidance, but it has a tag wiki.

43 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4 votes
0 answers
529 views

how data in _open data view is recorded in SFMC

As of now, our understanding of data views is that data is mostly real-time. But is this true for all data views or only specific data views? if specific, then which ones? Recently, we noticed that we ...
kl2's user avatar
  • 353
4 votes
1 answer
3k views

Is there a simple way to generate a create table script from a salesforce class?

I am looking for a way to synchronize Salesforce data with a local database. At the moment I just want a pain free way of downloading the data. I've been playing around with importing CSVs from the ...
JonM's user avatar
  • 141
3 votes
0 answers
703 views

Reliable Salesforce JDBC to be used with DataGrip

Do you recommend any particular JDBC for Salesforce (can be paid) which is reliable enough to be used for commercial purposes along with DataGrip (or similar) software? I've been checking similar ...
Pawel Gumiela's user avatar
3 votes
0 answers
122 views

First event/event relation insert taking a while

I have an application that inserts events and event relations in an org's database and has a loading icon to prevent the user from doing anything until the event and relations are properly created and ...
Tyler Dahle's user avatar
  • 2,719
3 votes
0 answers
141 views

How can we keep our tasks accessible to view and report on while not having them count against the data storage limit?

The org I am working with right now is using 210% of its allotted data storage. Most of the storage space is taken up by tasks (over 31M records). Is there a way to decrease the data usage while ...
Nia's user avatar
  • 61
2 votes
0 answers
71 views

"Didn't understand relationship 'Histories' in FROM part of query call." When query Seller History from Seller

I am getting an script-thrown exception when query Seller History from Seller. Here is my apex class: public without sharing class MainLayoutController { public static SObject ...
Tuấn Trần quốc's user avatar
2 votes
0 answers
258 views

Where is Database.query() spending (so much) CPU time?

My assumption was that only Apex Code is using CPU time. But the what I measure for code that is run by Salesforce's own Backend code speak a different language. List<SObject> result = Database....
Robert Sösemann's user avatar
2 votes
0 answers
211 views

Salesforce Optimistic Record Locking and JavaScript Updates

Is there a way to implement field only updates for Salesforce? Even if fields could be updated concurrently through JavaScript/JavaScript remoting calls, would Salesforce still save the record using ...
amanda fouts's user avatar
2 votes
0 answers
108 views

What is the salesforce equivalent of Microsoft's Northwind database

This sounds like an obvious question but I have not been able to find the answer anywhere. Does Salesforce have an equivalent of Microsoft's Northwind database? My problem is that I have gone ...
Hamilton Blake's user avatar
2 votes
0 answers
349 views

sObject insert execution not synchronous

I have a custom object and a controller action that creates a new record of this type. The action then returns a page where the list of objects are displayed. save() { ... insert myObject; ...
blu le temps's user avatar
2 votes
0 answers
161 views

Obtaining users data after accepting / allowing a Chatter Application

I'm slowly on the road to completing my PHP application, the final piece to my knowledge is figuring out how, after a user accepts the use of an Application (I think I'm using a remote app atm), to ...
ehime's user avatar
  • 530
1 vote
0 answers
261 views

Roll up summary field max value in database

I want to export Roll up summary fields to external system. What should be database column length. Should i use int, bigint or any other data type. I was just doing testing in my org and roll up ...
Manjot Singh's user avatar
  • 3,516
1 vote
0 answers
336 views

Database.merge - error "Invalid field IsCustomerPortal for merge"

I'm trying to merge accounts in apex using database.merge - Getting error "Invalid field IsCustomerPortal for merge". This field is available in Account object. The org do not have customer ...
Anand Jeevakan's user avatar
1 vote
0 answers
297 views

Database.saveResult showing only one error at a time

I am trying to write an apexrest service that takes in fields for the Opportunity Object. There are certain restrict picklists on the Opportunity object that I've created. Additionally there are other ...
N_H1922's user avatar
  • 315
1 vote
0 answers
186 views

Duplicate record not added to Database DuplicateRecordSet

We have activated the standard duplicate rules and matching rules for Account. Generally, they seem to work and the duplicate records get written into the tables DuplicateRecordSet and ...
Andrea Voggenreiter's user avatar
1 vote
1 answer
144 views

Apex to run cross-object duplicate detection (Leads vs Contacts)

I have the following code that checks Phone, Phone2 and Mobile for Leads and gives an error if a Lead with the same phone exists, before saving the new record. How do I turn it into a code that will ...
Suteu Adrian's user avatar
1 vote
1 answer
150 views

Multiple Databases On Salesforce DE edition

I was wondering whether it is possible to have multiple databases associated with my current Salesforce DE account. As I want to add some new data, but do not want to corrupt the current database ...
Andrew Johnson's user avatar
1 vote
1 answer
107 views

Is there is any way to count number of child objects of account object

I used related list but in related list I have to call the related object which I know but if there will be an custom object then what to do
user38865's user avatar
1 vote
0 answers
648 views

Get complete list of Forecast Categories & Labels

I'd like to programatically (in Apex or SOQL) get the full list of ForecastCategories and their corresponding ForecastCategoryNames for an org i.e. the list that you can access in the UI by navigating ...
sheilak's user avatar
  • 550
1 vote
1 answer
57 views

Accessing Data Externally - Any tools?

Bit of a back story... We have a business requirement where out of a team of 50 people only 20 need actual SF licenses. The other 30 only need access to a very small portion of data and only need ...
David Dawson's user avatar
  • 1,204
1 vote
2 answers
1k views

Converting Database.SaveResult error messages in more friendly feedback messages

I am implementing an interface from where you can update & insert records in SFDC, through a CSV file. After I process the files accordingly to my specifications, I want to perform an Update and ...
Endrit Sino's user avatar
1 vote
0 answers
427 views

Guidelines for Salesforce Database (Objects) design

What are the best practices for Salesforce Database structure (Object structures)? . It is very difficult to query data from a highly normalized structure. As in we cannot follow the RDBMS (Oralce Db, ...
Bharath Bhandarkar's user avatar
1 vote
0 answers
180 views

Temporary Restore of Salesforce

I always get asked the question by my clients - "What happens if we can't access Salesforce?". "Take regular backups" we say. But is that enough? Has anyone attempted to restore their Salesforce ...
JodieM's user avatar
  • 1,185
0 votes
0 answers
25 views

mapping changing defect types across different products

I need a way to unify "defect types" and "defect subtypes" (these are fields in a salesforce object) over multiple products with each new product release. I am a Q&R engineer (...
AnthonyJS's user avatar
0 votes
0 answers
36 views

how to override user's locale for number format in Apex data upsert operation

I've a Database.upsert operation on Apex base. But a user's locale(who runs the upsert operation) is Kyrgyz (Kyrgyzstan). Because of the number format that user has the numbers being upserted without ...
batuayyildiz's user avatar
0 votes
1 answer
39 views

How to get row number for jobid via SQL?

I am trying to extract jobids from data view bases on the emailname. How can I get the row number if I am getting back multiple jobids? I tried using ROW_NUMBER() but getting a static value of "1&...
kl2's user avatar
  • 353
0 votes
0 answers
25 views

JDBC driver not loading in Dataloader 37

I'm trying to configure Database as source in a Data Loader 37 bean, but at time to execute it from CLI I got an error message that specify the JDBC driver cannot be loaded, according to the ...
saulrainier's user avatar
0 votes
0 answers
20 views

How can I restore a Heroku database detached?

I used to be a free plan Heroku user. Since Heroku removed free plan my project databases have been detached (December 2022). Heroku doesn't provide technical support for free applications. As of ...
user avatar
0 votes
0 answers
76 views

Tip still showing Database access elements in loop

I have a loop in a flow where I have multiple Get elements which are clearly placed after the "After Last" path when the loop is complete. But the Flow 'Tips' is still telling me almost ...
Suzie's user avatar
  • 11
0 votes
1 answer
79 views

How to get records from sendable audience who did not make it to _SENT log without hardcoding the jobid

I have a DE extension where I have saved 1 record by querying: DE NAME: DataView_Job_DE Select top 1 JobID ,EmailName ,CreatedDate ,JobType ,JobStatus ,Row_Number() OVER (Partition by jobid ORDER BY ...
kl2's user avatar
  • 353
0 votes
0 answers
192 views

Implementing autocomplete suggestion for record ids

The LWC app that I am currently working on has a feature that lets users fetch information for a record whose record ID is entered. I am looking forward to implementing a feature that proactively ...
darthcoderUS's user avatar
0 votes
0 answers
530 views

how to find out total number of subscribers who were sent 1 email in last from in salesforce marketing cloud

I am trying to get a count of all subscribers (irrespective of BU) - hence I am running the query in parent BU who received ONLY 1 email in previous month. This is my query but it is not returning any ...
kl2's user avatar
  • 353
0 votes
2 answers
606 views

Unable to Merge two account and giving the "Database.MergeResult = Invalid field IsCustomerPortal for merge;MERGE_FAILED;"

private static void DuplicateAccountMerge(List<Account> triggerNew) { try{ // Merges a new Account with an existing Account based on matching email addresses. // Old ...
user41705's user avatar
0 votes
0 answers
41 views

Api Integration Issue

I have created an api integration in salesforce. From client's website a request will send to Salesforce in form of JSON. This will create record in Salesforce. Sometimes multiple requests are sent ...
Sushil's user avatar
  • 3
0 votes
0 answers
274 views

Search and view data from external database

I have a business requirement to create a way for users to search and view results from an external database (Snowflake) in Salesforce. I have created a simple visualforce page and need to send a ...
Hannah's user avatar
  • 35
0 votes
0 answers
91 views

Exception: Invalid field X__c for SObject Y__c

I have below VF Page. <apex:pageBlock > <apex:pageBlockTable value="{!CPAT_accounts}" var="c"> <apex:repeat value="{!excelFields}" var="f"> <...
Testing_SFDC's user avatar
  • 2,950
0 votes
1 answer
298 views

How our database should be for using it with Salesforce Connect?

I have a on-premise data base(Oracle DB), this database i need to use in salesforce directly using External Object technology provided by salesforce. I understood how to use External objects in ...
user3576180's user avatar
0 votes
1 answer
307 views

How can I find out what fields made my upsert fail?

I'm trying to upsert some records. I use Database.upsert. If the failure is related to a duplicate value (external ids that have to be unique) I need to know what fields are duplicate and clear (...
Pedro Otero's user avatar
0 votes
0 answers
86 views

Problem with database.query() in APEX REST @httpput method

In APEX REST @httpput method, after DML is done on newKas, saved record having different value in Article_Title__c instead of fetched article title field value from database.query() method. @HttpPut ...
user11's user avatar
  • 43
0 votes
1 answer
37 views

Work order data need to be stored in SalesForce databse

I need to save custom data(Work order related data) into sales force database. I need to have a service for this the same will be called in my SOA application. What database API i have to use to store ...
Prashanth's user avatar
-1 votes
1 answer
68 views

How to create a sql query in SFMC with where clause with date and time

I am trying to create a query that pulls the record from _open data view before a specific date and time, how to do that in sql? I am currently doing this for defining the date: Select * from _open ...
kl2's user avatar
  • 353
-2 votes
1 answer
24 views

Database.update issue with AccessLevel (FLS check) and Master-Detail fields with reparenting disabled

I'm having an issue with using AccessLevel.User_mode: Database.update(someSObject, AccessLevel.User_mode); The problem is that if I have a Master-detail field on an object that is being updated and ...
LinQ's user avatar
  • 139
-2 votes
1 answer
49 views

Please Recommend Some Free ETL Tools

Can anyone recommend me some ETL tools to integrate salesforce with Oracle ?
Nikhil Tripathi's user avatar