function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
VinHVinH 

Cannot select Probability from Opportunity table in sforce.

I have the following query in sforce explorer:
 
Select Probability from Opportunity
 
The query results in an error: "Query failed: Input string was not a correct format."
 
Can someone tell me why this error occurs, and how I can get the Probability from the Opportunity table?
 
- thanx
 
Gareth DaviesGareth Davies

Try:

Select Probability from Opportunity Where Probability > 20.0

Or some other such where clause.

Gareth.

VinHVinH

Thanx for the response.

It tried it, and other similar statements with different 'Where' clauses.

Still got the same error

However the following statement does work:

Select Id from Opportunity where Probability < 60

So it seems I can select records based on the Probability, but cannot retrieve the Probability itself.

- V

 

.

Gareth DaviesGareth Davies

Hi

I'm using .NET directly and I can execute a query that returns "Probability". I have not tried it in the sforce explorer.

Cheers

Gareth.

james_galindojames_galindo
I agree, it is something buggy with sforceExplorer. I have noticed that on several fields in different tables within sf using sfx. You should be able to retrieve Probablity just like any other field using straight API code though..