You need to sign in to do that
Don't have an account?

Dyanmic query error
L = Database.query('SELECT Id,Name (Select QualificationStatus__c From Qualifications__r where QualificationStatus__c =\'Success\' AND QualificationType__c=:countries) FROM Contact WHERE Firstname= :text');
Getting error
System.QueryException: unexpected token: 'Select'
try like this
L = Database.query('SELECT Id,Name, (Select QualificationStatus__c From Qualifications__r where QualificationStatus__c =\'Success\' AND QualificationType__c=:countries) FROM Contact WHERE Firstname= :text');
All Answers
try like this
L = Database.query('SELECT Id,Name, (Select QualificationStatus__c From Qualifications__r where QualificationStatus__c =\'Success\' AND QualificationType__c=:countries) FROM Contact WHERE Firstname= :text');