Search code examples
androidlistviewsimplecursoradapterfts3

Aliasing _id in an FTS3 database

My application uses an SQLite database with FTS3. The results of a query shall be displayed in a list view using a SimpleCursorAdapter. However I get the following exception:

java.lang.IllegalArgumentException: column '_id' does not exist

Doing some search I found this answer: Android Full Text Search and ListAdapter. I get the point but I can't figure out how to create this alias for docid -> _id. The SearchableDictionary example on the Android pages are not that helpful for me ;-)

Cheers,
Robert

Solution

  • You'll need to do a 'raw' query such as...

    cursor = db.rawQuery("SELECT docid as _id,...");