public list<sObject> reclist = new list<sObject>();
public string selectedObject = 'Account';
public string SearchKey = 'test';
string query = 'select id,Name from ' +selectedObject +' where Name LIKE \''+SearchKey+'%\' ORDER BY Name';
reclist = database.query(Query);
system.debug('reclist =='+reclist );
Above Query will return the accounts whose name start with test.
string query = 'select id,Name from ' +selectedObject +' where Name LIKE \'%'+SearchKey+'%\' ORDER BY Name';
reclist = database.query(Query);
Above Query will return the accounts whose name Contains test.
public string selectedObject = 'Account';
public string SearchKey = 'test';
string query = 'select id,Name from ' +selectedObject +' where Name LIKE \''+SearchKey+'%\' ORDER BY Name';
reclist = database.query(Query);
system.debug('reclist =='+reclist );
Above Query will return the accounts whose name start with test.
string query = 'select id,Name from ' +selectedObject +' where Name LIKE \'%'+SearchKey+'%\' ORDER BY Name';
reclist = database.query(Query);
Above Query will return the accounts whose name Contains test.
string query = 'select id,Name from ' +selectedObject +' where Name=:SearchKey limit 1'; system.debug('query ==='+query );
sobject sobj = database.query(Query);
Above Query will return the account whose name exactly Equuleus to test(SearchKey).
string conName = 'test';string conNameLike = '%' + String.escapeSingleQuotes(conName.trim()) + '%';String query = 'SELECT Id, FirstName, LastName From Contact Where FirstName LIKE :conNameLike';List<Contact> conList = Database.query(query);System.debug('conList-' + conList);Above Query will return the contacts whose FirstName contains test.
No comments:
Post a Comment