You need to sign in to do that
Don't have an account?
Saransh Bharadwaj 1
Need help on dynamic query
Hi Guys,
Need some help on below dynamic query. I am getting error here somewhere on 'in' operator.
Thanks
Need some help on below dynamic query. I am getting error here somewhere on 'in' operator.
list<Call_Memo__share> lstCallMemoShareTemp = Database.query('Select Id from Call_Memo__share' +'where RowCause =: '+Schema.Call_Memo__Share.RowCause.Call_Memo_Sharing_Account_Coverage_Team__c +'And ParentId in' +'(Select Id from Call_Memo__c Where'+ ParentName +' in: '+setParentId+')');
Thanks
Convert you set (setParentId) to comma(,) separated string like ('SFID', 'SFID', 'SFID',....) and then pass it
Regards
Amrender