I have a question about a problem I am running into with a page I am trying to make. It appears I can not include the “Probability” field in a conditions query. My goal is to exclude any records who’s probability is marked as either 0% or 100%.
Here is how I am setting the condition:
and this is the error message I am getting:
1. An error occurred while attempting to perform the following SOQL query: SELECT Id,RecordType.Name,RecordTypeId,Event_Date__c,Point_of_Contact__c,CloseDate,Proposal_Submitted_Date__c,Contract_Amount__c,StageName,Project_Name__c,Account.Name,Name FROM Opportunity WHERE ((RecordType.Id = ‘012700000005pp8’)AND(StageName not in (‘Contract Accepted’,‘Completed/Paid in Full’,‘Proposal Denied’,‘Proposal Submitted’))AND(Probability in (‘0%’,‘100%’)))OR((StageName not in (‘Contract Accepted’,‘Completed/Paid in Full’,‘Proposal Denied’,‘Proposal Submitted’))AND(RecordType.Id = ‘01270000000E1wr’)AND(Probability in (‘0’,‘100’))) LIMIT 21 Error:value of filter criterion for field ‘Probability’ must be of type double and should not be enclosed in quotesThere is nothing I can do about quotes as they are automatically put in by the query generator. Is this a bug / something I will have to wait to get fixed? or am I doing something wrong here. Any help is appreciated!
