samedi 7 mars 2015

Search in database with values of String array (filter list view with multi data for a specific culomn)

In my app i implement custom listView filter that user can search in it with the value of a textView.


But in this situation i have an Array of names that want to limit the items in listView to these names. but i don't know how to fetch records that their names is in this array.

I write the where statement for a single value like this :



buf.append(Imps.Contacts.NICKNAME);
buf.append(" LIKE ");
DatabaseUtils.appendValueToSql(buf, "%" + mSearchString + "%");
buf.append(" OR ");
buf.append(Imps.Contacts.USERNAME);
buf.append(" LIKE ");
DatabaseUtils.appendValueToSql(buf, "%" + mSearchString + "%");


But in this case mSearchString is an array of string not a single string.

I hope i explain my problem clear :)


Aucun commentaire:

Enregistrer un commentaire