The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
22 views

Mass transfer Contact owner

I want to mass transfer some of contacts to another user. I tried to use the data management and use the feature but I am not able to get the contacts displayed. Am I not following the proper way or ...
0
votes
0answers
28 views

How to integrate Oracle database to Salesforce.com?

I have to integrate Oracle SQL Developer with Salesforce.com. The situation is whenever I am Performing CRUD operations on my Oracle database it should reflect on Salesforce.com (like outlook ...
0
votes
0answers
11 views

Exact Target in Dynamics CRM - State and Status Codes for Email Sends

I'm looking for documentation on the status codes used in Exact Target for Microsoft Dynamics CRM. I'd love to get something resembling this: ...
2
votes
1answer
175 views

How to get data type of any object's field in SOQL

how to i get datatype of any filed in SOQL?
1
vote
1answer
20 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 ...
2
votes
1answer
32 views

Do we have a Salesforces global database for all clients that installed my package?

Please help me with this question and please correct me if I misunderstand anything. I am developing a package, in this package, I created some custom objects. I also have my external Web Service and ...
3
votes
1answer
86 views

How to know which Database.SaveResult instance corresponds to my SObject

I am currently trying to Update and Insert to collections of SObjects. I perform the actions(update&insert) separately, obtaining a Database.SaveResult Array as feedback. The problem is that I ...
1
vote
1answer
30 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 ...
2
votes
1answer
34 views

How create new database for testing

/** * Get template folder */ public List<SelectOption> getFolderList() { // Initialize a selectoption list List<SelectOption> options = new List<SelectOption>(); // ...
12
votes
1answer
245 views

How to best use the “Test Data Builder” pattern in a database context?

I need to setup test data in proprietary cloud platform (Salesforce.com) where I have no access to advanced testing frameworks. Besides that you can read my code example like it would be Java. ...
3
votes
0answers
26 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 ...
1
vote
3answers
58 views

Custom Save on New/Edit page - Is this valid code?

In my controller extension I have a custom save method that works for New and Edit scenarios also saves modified child records The below code works in all unit tests but starts to show strange ...
2
votes
1answer
182 views

Is upsert the right thing to save new or existing records?

In many of my Controller extensions I have save action methods that work for NEW and EDIT scenarios. I simply use upsert record instead of update / insert record in such cases. But now I am running ...
1
vote
1answer
20 views

'<<<' characters are lost in a field after saving to the database?

I have a field on a custom object before saving to the database as below: <span>>>> just some text <a class="Link" href="/55555555555AAA" >John Travolta</a> ...
4
votes
1answer
166 views

Database class commit

Why does Database class not provide commit method so that we can commit explicitly as well while in a transaction as we can do a rollback.
0
votes
2answers
82 views

Old style JOIN (ANSI JOINs) syntax is not allowed. Please use standard syntax

A client has asked me to write a rather complex SQL query to be used on Salesforce. When trying to implement the finished query on the Queries page I get the following error: Old style JOIN (ANSI ...
0
votes
1answer
120 views

Is there a way to create a master-detail to the Campaign Member object

TLDR; Is there a way to build a joint object between the campaign member and account objects? If not, what are some other methods to design the SFDC database to capture the specific individuals that ...
2
votes
1answer
202 views

Storing json as a String field is giving wrong value

I have been developing an Apex Trigger where I build a json string from an incomming Event. What I do is serialize the event into the json at first, then deserialize it as a Map and add to it some ...
0
votes
1answer
59 views

Database.rollback() risks and alternative

I've inherited some complex logic that does several different DML actions within the same (fairly long) method and if there are failures I need to revert everything that's been previously done. The ...
3
votes
1answer
193 views

Can Salesforce function as a “data warehouse?”

I am attempting to integrate on-premises software with our Salesforce Org. Our timekeeping system uses a PostgreSQL database to store time entries committed by staff. Salesforce's role is relegated to ...
6
votes
1answer
471 views

Can I tell how many records in a Database.QueryLocator()?

According to the documentation, in a batch a Database.QueryLocator can retrieve up to 50 million records. A maximum of 50 million records can be returned in the Database.QueryLocator object. If ...
0
votes
1answer
52 views

Inserted records have lifespan only within current Visualforce page

I have a VF page which dynamically inserts records into a custom object. To debug the problem and ensure the records have been successfully, I reloaded the inserted records after the insertion. The ...
1
vote
2answers
1k views

Problem with Database.update()

I have some accounts to update but some validation rules can failed. So to avoid this I use the Database.update() function to update accounts even if some DML exception occur. try { ...
0
votes
0answers
17 views

How to connect salesforce to external database without any third party tool [duplicate]

How to connect salesforce with SQL Server database without any third party tool like data loader or informatica. Is it possible to connect via Apex web services. It could be soap/wsdl based, or basic ...
1
vote
1answer
238 views

Database.DeleteResult.getErrors() question

I am trying to connect specific records that fail to delete in my batch job to their error messages. I thought my solution was working, but I checked the size of .getErrors() and it's size 1. My test ...
11
votes
1answer
313 views

How can adding a Subselect make a SOQL query non-selective?

I have a SOQL Query with subquery that fails to execute because it is non-selective. I don't understand why and cannot interpret the results. All I know is that tearing parent und sub query apart ...
7
votes
1answer
187 views

Database.DMLOptions - How to prevent Chatter Group Auto-Follow trigger from generating email

Currently I have a trigger which auto-follows specific groups in our organization when a new user is brought onboard. The auto-follow trigger feature works great! However, we have quite a few groups ...
2
votes
3answers
146 views

Backing up sf data in external DB [closed]

Hi I need to back up my sf org data into my local database. I am looking out for tools or any best practices to this at specific time intervals or regular time intervals. Can any one suggest what ...
3
votes
1answer
628 views

Salesforce database structure for sales cloud and service cloud

Do any one here have any doc related to database model of salesforce. Model of sales cloud and service cloud. I go through doc which salesforce have ...
3
votes
1answer
69 views

External SalesForce Forms

Is it possible to create external SalesForce Forms that can populate fields in the same way as inside salesforce? We offer online teaching and the idea is that teachers, after every lesson, can fill ...
1
vote
2answers
88 views

Tally the number of items in a related lists on a related object

Hi guys I am a complete n00b with SalesForce.com, so please forgive me if my question is too basic, but I have been trying for about 2 days now and I feel like I am getting nowhere I have a database ...
2
votes
2answers
238 views

Salesforce Mirrored To mySQL - Reporting Tool Suggestions?

We are setting up mirroring our Salesforce to mySQL using CopyStorm. One object in particular will be mirrored with no deletion (all data ever will accumulate in mySQL while in Salesforce it will ...
0
votes
1answer
1k views

Database schema export

Hi we have a date export made from salesforce instance. We'd like to rebuild just the database but we stumbled on process to import the CSV files to a SQL Server database. We have force.com IDE ...
1
vote
2answers
320 views

Data replication from MS SQL to Salesforce

I'm trying to setup our MSSQL server to "replicate" new insert/updates to Salesforce, but it appears that there is no official way to do it via Salesforce. Is there a recommended way? Background: I'm ...
1
vote
1answer
1k views

Pass a String in Select query - SOQL

I have a String that contains some custom fields of Account. I want to pass a String in a Select query like this : String myString = 'myCustomField1__c, myCustomField2__c'; List<Account> ...
1
vote
0answers
203 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, ...
1
vote
2answers
442 views

Get ID with upsert

I'm trying to insert/update a custom object in database with upsert but after the upsert I need to get the database ID. Is there a way to get the new/updated ID on database without querying the ...
0
votes
1answer
362 views

Database Save Results, Map.values() and maintaining order

Maybe because it is Friday afternoon, but I feel like I am missing something obvious here. I am trying to work out how I can refer back the errors from a database.insert to the key in my map. So I ...
2
votes
0answers
95 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; ...
3
votes
3answers
659 views

Can I rollback a Before Insert trigger from an after trigger event?

Scenario: After an object is inserted/updated (can happen after any of the two) - I update an external system with that object's info - Object ID is needed - which is why I need the After Insert. ...
1
vote
1answer
244 views

Database.delete and CRUD permissions

I have an detail Custom Object that has Contact as its master. My user profile has Read, but not Edit, Delete or Create permission. When I login as this user I can View the record, but the Edit and ...
2
votes
0answers
297 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 ...
0
votes
1answer
263 views

How to recognize duplicate records and other criteria within a Data Extension

Currently the AMPscript based landing page features an indication that shows how many individuals are signed up for an event. This number is arrived at simply by ROWCOUNT to see how many fields in the ...
5
votes
6answers
860 views

Most efficient (instant / no Batch) way to mark thousands of records as dirty

I have the requirement to store and retrieve the information that a set of arbitrary sobject records are "dirty" and need to be touch by asynch processes. I am talking about 10.000 to 100.000 records ...
0
votes
1answer
172 views

Accessing field dependancy values in the back end

On our UI we have two picklist fields where we provided field dependancy. On the front end we can see these dependancies. Now at the backend there will be a table to store these values. I would like ...
2
votes
0answers
143 views

Newbie : Save User Credentials in Salesforce [closed]

I am making an App which has to run in Salesforce and eventually distributed over Appexchange. In my app, I would like the Salesforce user to enter his Username and Password (with which he registered ...
6
votes
2answers
3k views

where do I use Database. Methods?

I m trying to understand where we use following Database.Methods. I know if we want to insert a record to an object we use DML Statement. What i want to know is why/where we use Database. methods. It ...
9
votes
2answers
255 views

How can updated SObjects/CObject be queried/retrieved without duplicate or missing records?

Another way to ask the question: Are SOQL queries transactional/atomic on the second level? I am writing a data integration with salesforce using the REST API. I want to retrieve a list of updated ...
1
vote
0answers
118 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 ...
41
votes
3answers
899 views

Any reason to skip DML on empty lists?

In parts of my code I have DML statements with an if around to only do the DML if the list is not empty: if( !recordsToUpdate.isEmpty() ) { update recordsToUpdate; } Couldn't I just write? ...