Android: SimpleCursorAdapter ListView Filtering

Question

I am currently facing problems trying to implement FilterQueryProvider in my custom SimpleCursorAdapter, as I'm not sure what to do in the RunQuery FilterQueryProvider function.

In other words, since the query containing my ListView basically gets the rowID, name and third column from my database table, I want to be able to filter the cursor based on the partial value of the name column.

However, I'm not sure if I can do this directly from runQuery without extending my DB class, since I want to filter out the existing cursor, or I need to create a new query function in my DB class that partially searches for my column name, and if so, then how do I start creating a query statement when using the CharSequence constraint argument in runQuery?

I am also concerned about performance issues related to trying to run multiple queries based on partial text, as the DB table contains about 1300-1400 rows. In other words, would I run into a bottleneck while trying to filter out the cursor?

Answer 1

You need to run a query that will return a new filtered cursor:

public class MyActivity extends ListActivity implements FilterQueryProvider { private Cursor cursor; @Override public Cursor runQuery(CharSequence constraint) { if(cursor != null) { cursor.close(); } cursor = somehowGetAFilteredCursorFor(constraint); startManagingCursor(cursor); return cursor; } 

}