You need to sign in to do that
Don't have an account?
P K
Query issue
query like first check Partner level and depend on Partner Level , it will filter out Message for each Partner Level. It will be kind of dynamic SOQL with comparison kind of each values of Partner level.
[SELECT Id,Name, Channel__c,Partner_Level__c
FROM MessageAlert__c
WHERE Channel__c = 'Partner' AND
Partner_Level__c INCLUDES ('Diamond , Gold')];
[SELECT Id,Name, Channel__c,Partner_Level__c
FROM MessageAlert__c
WHERE Channel__c = 'Partner' AND
Partner_Level__c INCLUDES ('Diamond , Gold')];
SELECT Id,Name, Channel__c,Partner_Level__c FROM MessageAlert__c WHERE Channel__c = 'Partner' AND Partner_Level__c INCLUDES (:partnerLevel)
[SELECT Id,Name, Channel__c,Partner_Level__c
FROM MessageAlert__c
WHERE Channel__c = 'Partner' AND
Partner_Level__c INCLUDES ('Diamond ;Gold')];