[SalesForce] Invalid bind expression type of Integer for column of type String

 Integer BPcurrentYear = System.Today().year();
    List<Business_Plan__c> lBPs = [Select b.Year__c,  b.FCPA_Last_Updated__c, 
        (Select Name,IsHQ__c 
        FROM Business_Plan_Details__r WHERE Type__c = 'Current Year Revenue Goal') 
        FROM Business_Plan__c b WHERE Partner_Account__c = :accInstance.Id and b.Status__c = 'Approved' AND b.Year__c = :BPcurrentYear
        ORDER BY b.Year__c DESC ];

From abive query i'm getting error:

Invalid bind expression type of Integer for column of type String

I'm having problem with b.Year__c = :BPcurrentYear

Here the b.Year__c is Text Field. I am comparing with integer.

How to compare the Text field with integer or should i take take Current year in any other format which can assign to Text field?

Best Answer

You need to pass String value for Year__c field:

String BPcurrentYear= String.valueOf(system.today().year());

Related Solutions

[SalesForce] Error: Compile Error: Invalid bind expression type of SOBJECT:AccountShare does not match domain of foreign key

Inline lists can only bind to Id, not any other field. What you need is a subquery:

SELECT Account__c,Number__c,LEGACY_CUST_NUM__c 
FROM SYSTEMS__c where Account__c IN
(Select  AccountId from AccountShare 
where ( UserOrGroupId IN : map_group OR  UserOrGroupId =:userId )
AND RowCause IN ('Territory', 'TerritoryManual', 'TerritoryRule'))

If the sub-query is too complex, it may not let you, in which case you'll have to iterate through the list of shares you queried, and build the list manually.

[SalesForce] Error: Compile Error: Invalid bind expression type

The problem is in the final portion of your last query's WHERE clause:

Dependent_Question__c IN:DQlist

Since the Dependent_Question__c field on the MM_Survey_Question__c object is a Text (String) field, DQlist would need to be a Set or List of type String, rather than type MM_Survey_Question__c as it is from the query return. In order to extract the Dependent_Question__c field values from each of the MM_Survey_Question__c records in DQlist, you will need to iterate through the list and collect a set of strings to use in the WHERE clause.

List<MM_Survey_Question__c> DQlist=new List<MM_Survey_Question__c>();
DQlist= [select Dependent_Question__c from MM_Survey_Question__c where MM_Survey__c=:surveyRef and Dependent_Question__c!=null];
Set<String> dependentQuestions = new Set<String>();
for (MM_Survey_Question__c surveyQuestion : DQlist) {
    dependentQuestions.add(surveyQuestion.Dependent_Question__c);
}
System.debug('DQ List---'+DQlist); 
if(dependentQuestion!=null)
{
    dependentQuestionOptions = new List<SelectOption>();
    List<MM_Survey_Question__c> qlst = [Select Id, Name From MM_Survey_Question__c where MM_Survey__c=:surveyRef and Type__c='Single Select' and Dependent_Question__c IN:dependentQuestions];

Stepping back a bit, though, why are you repeating the same query on your second and last lines, with only the added filter of Type__c='Single Select'? Why not include the Type__c filter in the original query?

Best Answer

Related Solutions

[SalesForce] Error: Compile Error: Invalid bind expression type of SOBJECT:AccountShare does not match domain of foreign key

[SalesForce] Error: Compile Error: Invalid bind expression type

Related Topic