If we have a field that is a drop down in Salesforce is it possible to retrieve a list fo all of the available values through the API?

I've created a Opportunity Contact field for Opportunity which is a lookup on the Contact table.

From salesforce I can see the contact and work with it and everything looks happy.

But when trying to access the contacts information using PHP I get nothing. I'm using the following code:

	$queryOpportunity = "Select AccountId, Amount, Paid__c, Opportunity_Contact__c from Opportunity WHERE Id = '$id'" ;
	$OppResponse = $mySforceConnection->query(($queryOpportunity));
	foreach ($OppResponse->records as $OppRecord) {
		$subtotal = $OppRecord->Amount ;
		$email = $OppRecord->Opportunity_Contact__c->Email ;
		var_dump($OppRecord) ;
		var_dump($OppRecord->Opportunity_Contact__c) ;

And I can't get any of the information for the contact. Help.

Also, Instead of grabbing the AccountID and doing a seperate query on account is there anyway to just grab the account information with this query as well?

Hi,

This must be really simple because I can't find any example of how to do this.  All I want to do is make my datetimes look nice.  Here is what I get out of my query results object: 

2009-09-04T06:43:36.000Z

And I would like to format it like this:

09/04/2009, 12:43 PM

Can anyone clue me in? 

Here is basically what I do.

$sObject1 = new SObject();

$sObject1->fields = $fieldsToUpdate;

$sObject1->type = 'Lead';

$sObject1->Id = $record->Id;

$response = $mySforceConnection->update(array ($sObject1));

This works great until I change a value to null.  :)

I run the query

SELECT Id,LastName,FirstName FROM Account

and only about a 1000 records are called?

Why is this.. I need to call all of them. Is there a way of leap frogging in soql?

SELECT Id,LastName,FirstName FROM Account LIMIT 10,200

and find the number of rows in the query?

I'm trying to log into a production edition and keep getting this error:

Login failed: INVALID_LOGIN: Invalid username, password, security token; or user locked out.

I know my username, password and security token are all working because I'm logging in with the IDE and I'm not locked out. The login attempts are not showing up in the Login History at all. 

Anyone know what the issue is?

I'm using v0.58A with Adobe Air v3.1.0.4880.

Hi,

I have some code that gets some JSON data from a web service callout, then parses it into a collection (map) or object. I'm wondering if there's a best practice or method people are using to then cache this data for some amount of time so that it's not being retrieved and parsed everytime it is needed.

I'm thinking I can create an custom object for this and store the data there, either in a structured format, or serialize it to a JSON string and then store the whole string. I'd store it with a timestamp so that I know when to refresh it.

Is there a better way to do this? And by better I mean recommended or faster?

thanks

I got a "List has no rows for assignment to SObject An unexpected error has occurred. Your development organization has been notified." error message. I know what this error message generally means, but I don't know what the offending line(s) are. It's happening in my production environment, but not in my Sandbox, and I think it has something to do with some fields being populated in the Sandbox, but they're not in the Production so a query is failing somewhere.

Is there a way to determine what lines of what class are causing the problem (line numbers)?

thanks

Hi, 

I'm trying to access a class function from a RemoteAction function. 

The function I was trying to access is not static, while the RemoteAction function must be static. This causes the "Method does not exist or incorrect signature" error.

So I changed the function I was calling to be static, which gets rid of that error. But that creates a new error, because the function is trying to call an instance variable which is not static - "Variable does not exist". Addiing static to that variable does not change anything. 

Something like this:

global with sharing class MyClass {
public static String myVar {get;set;}
 
public static void myClassFunction(String id){
myVar = '';
}
 
@RemoteAction
global static string updateRecord(String id){
myClassFunction(id);
return '1';
}
}

 What's the right way to do this?

When working in the Force.com IDE, the contents of my Outline view keep disappearing, with nothing inside the window. It's a pretty important feature of an IDE, so it's pretty annoying.

I've been trying to use Bookmarks as a workaround, but regularly after a I save, my booksmarks all get cleared!

So there's a clearly bugs with both the Outline and Bookmarks in eclipse, at least with the Force.com IDE.

Has anyone else had this problem?  Anyone know how to solve it? 

It's a pain to navigate code using line numbers and 'Find' alone.

thanks

I'm returning a query result as an SObject from a RemoteAction method in Apex that includes an ActivityDate field on it, which should be type date. When I get it in the Javascript it's a long number like 1312848000000. 

I'm guessing this is some internal storage format, but I don't think it's a normal Unix timestamp. Can someone tell me how to convert this to a readable date string, either in the Javascript or the Apex?

thanks

Code coverage issue, class: Trigger1 -- Test coverage of selected ApexTrigger is 0%, at least 1% test coverage is required
Code coverage issue, class: Trigger2 -- Test coverage of selected Apex Trigger is 0%, at least 1% test coverage is required
Code coverage issue, class: Trigger3 -- Test coverage of selected Apex Trigger is 0%, at least 1% test coverage is required
Code coverage issue -- Average test coverage across all Apex Classes and Triggers is 70%, at least 75% test coverage is required

Hello,

I have a custom object I use for data about events at my organization MyEvent__c, and a connector object  for tracking RSVPs to the events, RSVP__c.

I'm trying to query the RSVPs but can't seem to get a query to work. The RSVP__c object connects to the event object with a Master-Detail(Event) field. 

I'm trying to test queries with the Apex Explorer and I can't get the most basic SOQL queries to work:

Select Id from RSVP__c

Returns Error: Query failed: INVALID_TYPE: sObject 'RSVP__c' is not supported.

Select e.Id,e.Event_Title__c, (Select Id,Name from RSVP__r)  from MyEvent__c e where e.Id = 'a0A7xxxxxxxxxxx'

(with a valid id in there) returns error: 

Query failed:  INVALID_TYPE  ... (query)

ERROR at Row:1:Column:52

Didn't understand relationship  'RSVP__r' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names. 

The WSDL has the relationship in there in the MyEvent__c object:

   <element name="RSVP__r" nillable="true" minOccurs="0" type="tns:QueryResult"/>

I have no idea why this is not working. My guess is that it's a permissions thing or a namespace thing, but I don't know. 

Any help would be greatly appreciated. 

Thanks,

-paul

Hi,

I'm working on an application where I'd like to have a custom List Button do something different based on the currently selected list view. I have a Visualforce page that does a dynamic query and I'd like to retrieve the current view name or ID to use in this query, which I would send to the VF page by adding it as a param in the URL of the VF page called by the custom list button. 

The current view is identified with a URL GET param like this:

https://nan.salesforce.com/aXX?fcf=00NN000000NNnNN

The fcf param specifies the current view by ID (=00NN000000NNnNN).  Is there a way to get that fcf param or maybe the title of the name of the current view and pass it in a link to a VF page in a custom button?

In Apex, you can use getParameters to get that GET param, but in the custom button, I don't think it's possible to do it that way, because it's a PageReference method and this isn't a Visualforce page

I can get the params from the current URL with Javascript (window.location.search) and then parse it out of there in an OnClick function, which works fine (that's how I'm doing it now), but I wanted to check to see if anyone knows of a better way to do it besides hardcoding it into the JS.

Alternatively, I'm considering scrapping the built-in list view altogether and making a VF view to replace it, which would also solve the problem.

thanks,

-paul

In Java you can access a class's fields using the reflective method getField(String name). Is something like this possible in Apex?

For example, instead of accessing with simple dot notation:

String lname = Contact.lastName;

Is there a way to do something like this:

String lname = Contact.getField('lastName'); 

I'm trying to access a field where I'm pulling the field name from a variable, but I obviously can't do something like. 

String.myVar = "lastName";

String lname = Contact.myVar;

I can set this up with a block of if statements (like a switch statement), but if there's a way to do it with reflection, that seems more elegant to me. I'm going to be testing for a lot of values so it would certainly be more concise (1 line of code vs n lines, where n is the number possible values).

 if(myVar == "lastName" ) {lname = Constant.lastName}

I'm guessing the answer is no, because I don't see it in the manual...

-paul

            <apex:pageBlockSection collapsible="true" title="My Form">        
                <apex:inputField value="{!event.Field1__c}"/>
                <apex:inputTextarea value="{!event.Field3__c}" id="specialTextArea" richtext="true"/>
                <apex:inputField value="{!event.Field2__c}"/>
            </apex:pageBlockSection>

Label <apex:inputTextarea value="{!event.Field3__c}" id="specialTextArea" richtext="true"/>

But that doesn't work either -- it just pushes the rich textarea over to the right. 

Has anyone had any luck using this inside a PageBlockSection amongst other inputFields?

I also tried a few other WYSIWYG packages that I used in other work -- TinyMCE and the WYMeditor plugin for jquery.  However, 
I was not able to get either to work in the visualforce page. Both require a class or id attribute to identify the textArea  to make 
rich text. Identifying class doesn't seem to work. I also tried using the id, but the id seems to get transformed in the output. 
 Looking at the source of the html frame, I see something like id="j_id0:j_id3:j_id4:j_id32:specialTextArea". 
I also tried that id, but it didn't work either. If anyone has gotten another WYSIWYG editor working with visualforce, I'd be interested 
in hearing about that also.  

thanks, 
-paul

Hi,

I'm trying to generate an Apex class from the WSDL file from Amazon AWS's SimpleDB web service:

http://sdb.amazonaws.com/doc/2007-11-07/AmazonSimpleDB.wsdl

The file parses fine, but then when I try to generate the Apex class I get this error message:

Apex generation failed.

Error message:

Error: Unable to find name for element in :ListDomainsResponse_element

Anyone know how to deal with this, or seen this before with other WSDL files?

I'm guessing it's a problem with the Apex generator, not the WSDL, because I don't see anything out of the ordinary in the WSDL.

I think I may be able to get around using SOAP since they offer HTTP REST services also, but it seems like the SOAP interface would be a better way to use the service.

thanks, -paul

Hi All,

Salesforce API newbie here.

Using Perl I can do basics on Accounts, Cases, Opportnuities, but when I try to access custom objects I run into trouble. For example trying to look up a custom object returns an error like:

INVALID_TYPE:
select id from Bugzilla__c where BZ_Number__c like '1234'
^
ERROR at Row:1:Column:16
sObject type 'Bugzilla__c' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names. at update-keywords-for-bug.pl line 185

I assume I need to reference my enterprise WSDL instead of the default (in my script I reference https://test.salesforce.com/services/Soap/u/23.0)

How do I do this in Perl? I have searched the forums here and find threads that touch on the topic but can't find any answers,

Help appreciated!

Thanks - James

I am running into a problem with the PHP SDK and aggregate functions.  We are trying to do a very simple calculation that counts the number of records by each MailingState.  Our query is as follows:

$query = "SELECT MailingState, count(Contact.Id) from Contact WHERE MailingState != '' GROUP BY MailingState";
$response = $mySforceConnection->query($query);

When I run the PHP code on my local MAMP stack the $response array returns back properly with MailingState and the expr0 count.  However when I run the same code on our remote webserver (Rackspace Cloud Sites), the $response array only shows the MailingState and does not return the aggregate calculation.  

Has anyone run into this problem before?  is there something that we should be looking for in the PHP config?

Thanks,

-Matt

I'm trying to log into a production edition and keep getting this error:

Login failed: INVALID_LOGIN: Invalid username, password, security token; or user locked out.

I know my username, password and security token are all working because I'm logging in with the IDE and I'm not locked out. The login attempts are not showing up in the Login History at all. 

Anyone know what the issue is?

I'm using v0.58A with Adobe Air v3.1.0.4880.

Using the SOQL commander I am able to query and retrieve values from fields within custom objects without issue. 

When I try to use the same exact query from PHP I get "Notice: Undefined property: SObject::$Date_Requested__c in /var/www/........"

..... where date_requested__c is one of the custom fields I'm trying to pull.

How come I cannot retrieve values from the API like I can using the SOQL commander SQL dashboard? 

Is querying custom fields from the API not allowed?

Thanks in advance,

Ryan

Hi,

I have some code that gets some JSON data from a web service callout, then parses it into a collection (map) or object. I'm wondering if there's a best practice or method people are using to then cache this data for some amount of time so that it's not being retrieved and parsed everytime it is needed.

I'm thinking I can create an custom object for this and store the data there, either in a structured format, or serialize it to a JSON string and then store the whole string. I'd store it with a timestamp so that I know when to refresh it.

Is there a better way to do this? And by better I mean recommended or faster?

thanks

Hi everyone

I need to push data from salesforce (on an event) to a website.... if anyone of you have done some work like this, juss let me know....

Thanx in advance

If we have a field that is a drop down in Salesforce is it possible to retrieve a list fo all of the available values through the API?

I got a "List has no rows for assignment to SObject An unexpected error has occurred. Your development organization has been notified." error message. I know what this error message generally means, but I don't know what the offending line(s) are. It's happening in my production environment, but not in my Sandbox, and I think it has something to do with some fields being populated in the Sandbox, but they're not in the Production so a query is failing somewhere.

Is there a way to determine what lines of what class are causing the problem (line numbers)?

thanks

I have a search page for my custom object and in the result display the Member field (linked to Contact) is automatically clickable. I don't want this to be the case. Can I disable this?

The code for the section is:

<apex:column >               

<apex:facet name="header">                   

<apex:commandLink value="Member" action="{!toggleSort}" rerender="results,debug">                       

<apex:param name="sortField" value="member" assignTo="{!sortField}"/>                   

</apex:commandLink>               

</apex:facet>               

<apex:outputField value="{!counselling_practice.Member__c}"/>           

</apex:column>

Thanks in advance

Justyn

I know my question is going to be pretty simple for you veterans but can someone explain to me how relationships work in SOQL. I have looked at the documentation and the discussion boards but can not seem to understand it.

I want to get the following fields from the following tables:

Contact.FirstName,

Contact.LastName,

Account.Name,

Opportunity.Name

I have tried the following but it does not seem to work:

SELECT Contact__c.FirstName, Contact__c.LastName, Contact__c.Account__r.Name, Contact__c.Account__r.Opportunity__c.Name From Contact

The more I read the more confused I get.

I need to understand the basic concept. If someone could help I would appreciate it.

Robert

I have a simple custom exception class.  Since it's referenced from more than one class, I did not make it an inner class.  It is in a class all by itself that reads as below--

public class OppSyncException extends Exception {
	
}

I have Apex tests that instantiate this exception.  But when I look at the code coverate for that module it says 0%.  Now it has 0 executable lines so technically coverage is undfined (0/0). 

What I want to know is will I have a problem trying to deploy this module where it will complain that the coverage is < 75%?

<b>12. Purchase Order #: </b><apex:outputfield value="{!Contract.Purchase_Order_Number__c}"/>

 How would I make this line show up only if something is typed in the purchase order field?

And then if null it would skip that line completely and go to the next part of the page.

Thanks!

When working in the Force.com IDE, the contents of my Outline view keep disappearing, with nothing inside the window. It's a pretty important feature of an IDE, so it's pretty annoying.

I've been trying to use Bookmarks as a workaround, but regularly after a I save, my booksmarks all get cleared!

So there's a clearly bugs with both the Outline and Bookmarks in eclipse, at least with the Force.com IDE.

Has anyone else had this problem?  Anyone know how to solve it? 

It's a pain to navigate code using line numbers and 'Find' alone.

thanks

Hi,

How do I create a Closed task using Apex?

I have the following code, but it creates an Open task.

I've also tried to replace Task with ActivityHistory, but it seems to have had the effect of making all fields read only.

Task act = new Task();
act.Subject = 'SMS: '+message;
act.Description = message+'\n'+'Sent to: '+toPhone+'\n'+'Sent From: '+FromPhone;
act.whoId = recipient_id;
act.ownerId = user_id;
act.Status = 'Closed';
act.whatId = what_id;

act.IsClosed = true; //this line doesn't compile.

Database.SaveResult sr = Database.insert (act);

Thank you.

For an SMS system I'm trying to create a "Log an SMS" button. (It actually sends the text, but that's besides the point).

I'm trying to have something along the lines of "Log a Call" button in the  "Activity History" section of a contact's detail page.