apex – SOQL query with Multi Select Picklist with where clause contains field
I have a field Job_technology__c field in account and technology__c field in Job__c custom object. Account and Job__c is in look up relationship.
Job_technology__c field in account is multi-picklist with values(salesforce,java,.net,aws,etc) and technology__c field in Job__c is also multipicklist field with values(salesforce,java,Angular,Azure,aws,etc).
I need a query to Find jobs where any one of the value in technology__c of Job__c matches with any one of the value in Job_technology__c of account.
Read more here: Source link