Edmond Tamas Edmond Tamas - 5 months ago 11
Android Question

Android search suggestion, why have to type the whole word for suggestion?

I have a search widget with suggestions enabled. Everything works ok, but I have to write the whole word in order to get a suggestion.

I have set the - android:searchSuggestThreshold="2", but still need to finish a word (5-6) characters, to get a suggestion. Why?

I would really, really appreciate some help.
Thanks!

manifest:

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="com.exploreca.tourfinder"
android:versionCode="1"
android:versionName="1.0" >

<uses-permission android:name="android.permission.CALL_PHONE" />

<uses-sdk
android:minSdkVersion="14"
android:targetSdkVersion="19" />

<application
android:allowBackup="true"
android:icon="@drawable/ic_exploreca"
android:label="@string/app_name"
android:theme="@style/AppTheme" >
<activity
android:name="com.exploreca.tourfinder.MainActivity"
android:label="@string/app_name" >
<intent-filter>
<action android:name="android.intent.action.MAIN" />
<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
<activity
android:name=".SettingsActivity">
</activity>
<activity
android:name=".TourDetailActivity">
</activity>
<!-- Search results activity -->
<activity android:name=".SearchActivity">
<intent-filter>
<action android:name="android.intent.action.SEARCH" />
</intent-filter>
<meta-data
android:name="android.app.searchable"
android:resource="@xml/searchable" />
</activity>

<meta-data
android:name="android.app.default_searchable"
android:value=".SearchActivity" />

<provider
android:name=".SearchContentProvider"
android:authorities="com.exploreca.tourfinder.SearchContentProvider" >
</provider>

</application>
</manifest>


And part being used in SearchContentProvider:

@Override
public Cursor query(Uri uri, String[] projection, String selection,
String[] selectionArgs, String sortOrder) {

Log.i(LOGTAG, "The typed characters are: " + selectionArgs[0]);

SQLiteQueryBuilder builder = new SQLiteQueryBuilder();
builder.setTables(ToursDBOpenHelper.TABLE_TOURS);

HashMap<String, String> columnMap = new HashMap<String, String>();
columnMap.put(BaseColumns._ID, ToursDBOpenHelper.COLUMN_ID + " AS " + BaseColumns._ID);
columnMap.put(SearchManager.SUGGEST_COLUMN_TEXT_1, ToursDBOpenHelper.COLUMN_TITLE + " AS " + SearchManager.SUGGEST_COLUMN_TEXT_1);
columnMap.put(SearchManager.SUGGEST_COLUMN_INTENT_DATA, ToursDBOpenHelper.COLUMN_ID + " AS " + SearchManager.SUGGEST_COLUMN_INTENT_DATA);
builder.setProjectionMap(columnMap);

dbhelper = new ToursDBOpenHelper(getContext());
//database = dbhelper.getReadableDatabase();

SQLiteDatabase db = dbhelper.getWritableDatabase();
cursor = builder.query(db, projection, selection, selectionArgs, null, null, null, null);

return cursor;
}


And searchable.xml:

<?xml version="1.0" encoding="utf-8"?>
<searchable xmlns:android="http://schemas.android.com/apk/res/android"
android:hint="@string/search_hint"
android:label="@string/app_name"
android:searchSuggestAuthority="com.exploreca.tourfinder.SearchContentProvider"
android:searchSuggestIntentAction="android.intent.action.VIEW"
android:searchSuggestSelection="city LIKE ?"
android:searchSuggestThreshold="2"
android:includeInGlobalSearch="true"/>

Answer

I have figured it out, thanks to this post. For suggestions to appear after typing the first or second word we need "Wildcards":

"city LIKE '%' || ? || '%'"