function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Siddhesh ChavanSiddhesh Chavan 

System.QueryException: unexpected token: ':'

Hi I am getting  unexpected token: ':' error when i am using follwing query

 String CaseFiler =  ' + selectedCaseFiler + =:' + selectedFilterValue;         
            theQ = 'SELECT id,OwnerId,CaseNumber,Origin,Priority,Status,Account.Name,New_Owner__c  FROM Case WHERE OwnerId = :myId AND :CaseFiler  ';


In above query selectedCaseFiler and selectedFilterValue both are dynamic values
Siddhesh ChavanSiddhesh Chavan
Its not working giving System.QueryException: unexpected token: '+'
Sunny670Sunny670
Try below code :

String CaseFiler =  ' + selectedCaseFiler + =:' + selectedFilterValue;         
            theQ = 'SELECT id,OwnerId,CaseNumber,Origin,Priority,Status,Account.Name,New_Owner__c  FROM Case WHERE OwnerId = :myId AND CaseFiler:  ';