-
ChatterFeed
-
0Best Answers
-
0Likes Received
-
0Likes Given
-
11Questions
-
7Replies
Is there a trick to getting parent joins on Task using the WhatId relationship to work?
SELECT a.Id, a.WhoId, a.WhatId, a.Subject, b.Website, b.Id FROM Task a, a.What b
I get the following error:
INVALID_FIELD:
a.ReminderDateTime, a.IsReminderSet, b.Website, b.Id FROM Task a, a.What
^
ERROR at Row:1:Column:342
No such column 'Website' on entity 'Name'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
The problem seems to be that SOQL can't figure out what to do because the a.What relationship points to a number on entities. Is there some trick I need to do to get this to work?
Thanks,
Eddie
- eddie
- August 20, 2008
- Like
- 0
- Continue reading or reply
Are Child Relationship Names available from the partner WSDL?
I have not been able to find the Child Relationship Names that are required to perform SOQL queries with parent-to-child relationships. I have read the doc but see nothing about how to get the Child Relationship Name from the API for ether the standard or custom objects.
Thanks,
Eddie
- eddie
- January 24, 2007
- Like
- 0
- Continue reading or reply
What happened to Profile.PermissionsIPRestrictRequests?
- eddie
- January 22, 2007
- Like
- 0
- Continue reading or reply
Does upsert with relationships have a problem with self joins?
I'm trying to use upsert with relationships to set Contact.ReportsToId to the external id of an existing contact using the partner WSDL.
The xml for my relationship field looks like this:
<Contact>
<type>Contact</type>
<ExternalId__c>1234</ExternalId__c>
</Contact>
The API returns the following error:
No such column 'Contact' on entity 'contact'
This same code works correctly to set the relationship for Contact.AccountId.
Any ideas?
Thanks,
Eddie
- eddie
- January 19, 2007
- Like
- 0
- Continue reading or reply
Can you use external ID fields as a foreign keys for operations othen then upsert?
The way the doc reads I assume you can't but wanted to make sure.
It would be nice to be able to do so, for the cases where you don't need the upsert functionality (or the external Id baggage) for the child operation but do want to related it a parent based on an external id
Thanks,
Eddie
- eddie
- January 19, 2007
- Like
- 0
- Continue reading or reply
Can upserts with external id foreign keys be done using the Partner WSDL?
- eddie
- January 08, 2007
- Like
- 0
- Continue reading or reply
Cross browser issues with sControls that use /Theme2/common.css
- eddie
- March 06, 2006
- Like
- 0
- Continue reading or reply
Login History Data Records - Do they get purged?
Hi,
Does anyone know if the Login History data records get purged at all? We have clients that with the number of users and the number of processes that login can have about 70,000 entries a week in their Login History. This can easily escalate to 300,000 records in a month. Even though they download that data to excel and filter out automated process logins, the download and filtering out is a huge process due to so many records. Is there a way to purge these or do they get deleted automatically.
Thanks in advance,
Glenn
- eddie
- September 29, 2005
- Like
- 0
- Continue reading or reply
Datetime fields and User Timezones
I�d like to allow users work with datetime fields using times based on the time zone set for their SFDC account, just as they appear in when logged via the web interface. Using .NET, the datetime values I receive back from the API have been converted to my machine�s local time zone. I realize that this is a .NET issue, and that I can convert these back into UTC as needed, but I need a way to then convert the UTC datetime to reflect the user�s time zone. Also, I need a way to take a dateime in from a user in their account�s local time (again not my machines) and convert it to UTC for sending in to the API.
Is there a way that I can obtain the time zone offset (DST aware) for a given user? The User.Timezone field gives me a string �region/key� based time zone instead of an offset, so I can only make use of that with some sort of external lookup.
Is there a way to convert a datetime from a user�s local time into UTC using the same offset DST rules that would be used through the web based UI?
- eddie
- June 30, 2005
- Like
- 0
- Continue reading or reply
Pushing a file to sf
Im looking to attach a file to an account record.
The Attachment object talks about first converting the file to base64 binary.
Please point me in the right direction toward some examples of sending files to salesforce.com
Thankyou
-GL
- eddie
- June 22, 2004
- Like
- 0
- Continue reading or reply
Contact Field Problem
Hello,
I am trying to create a new contact with the insert method
When I run this code:
object[] ret;
mapEntry[] record = new mapEntry[6];
//Create new mapentries and set the values for each field
record[0] = new mapEntry();
record[0].key = "firstName";
record[0].value = fname;
record[1] = new mapEntry();
record[1].key = "lastName";
record[1].value = lname;
record[2] = new mapEntry();
record[2].key = "Phone";
record[2].value = phone;
record[3] = new mapEntry();
record[3].key = "Fax";
record[3].value = fax;
record[4] = new mapEntry();
record[4].key = "Email";
record[4].value = email;
record[5] = new mapEntry();
record[5].key = "accountID";
record[5].value = accounttid;
ret = (object[]) sforce.insert("contact", record);
I get this error message:
Fault Code: 0
Fault string: bad field names on insert/update call: Email, Fax, Phone
I ran a describe on "Contact" and found that most of the fields were not accepted by insert.
Where can i find a list of valid fields to use in code.
Thankyou,
GL
- eddie
- June 22, 2004
- Like
- 0
- Continue reading or reply
Can upserts with external id foreign keys be done using the Partner WSDL?
- eddie
- January 08, 2007
- Like
- 0
- Continue reading or reply
Cross browser issues with sControls that use /Theme2/common.css
- eddie
- March 06, 2006
- Like
- 0
- Continue reading or reply
Login History Data Records - Do they get purged?
Hi,
Does anyone know if the Login History data records get purged at all? We have clients that with the number of users and the number of processes that login can have about 70,000 entries a week in their Login History. This can easily escalate to 300,000 records in a month. Even though they download that data to excel and filter out automated process logins, the download and filtering out is a huge process due to so many records. Is there a way to purge these or do they get deleted automatically.
Thanks in advance,
Glenn
- eddie
- September 29, 2005
- Like
- 0
- Continue reading or reply
Automatic Integration with Exchange?
Hi,
Any one know of a way to keep Exchange and SF.com in sync automatically. (not using a manualy triggered Intellisync).
Problem:
Field Salesforce with GPRS enabled outlook devices (Blackberry's, XDA and other).
Want to make sure they are notified when someone else books them for an appointment and when they book an appointment. For various reasons just using Exchange or just using SF.com will not work.
Does anyone know of 3rd party synchronisation tool?
Thanks
Gareth.
- Gareth Davies
- March 31, 2005
- Like
- 0
- Continue reading or reply