List of usage examples for android.support.v4.content CursorLoader setSortOrder
public void setSortOrder(String sortOrder)
From source file:com.amsterdam.marktbureau.makkelijkemarkt.MarktenFragment.java
/** * Create the loader to get the markten from the database * @param id the unique id for this loader * @param args the arguments given in the initloader call in oncreateview * @return a cursor containing the markten *///from w w w . j a va2s . c o m @Override public Loader<Cursor> onCreateLoader(int id, Bundle args) { // create the loader CursorLoader loader = new CursorLoader(getActivity()); loader.setUri(MakkelijkeMarktProvider.mUriMarkt); loader.setProjection(new String[] { MakkelijkeMarktProvider.Markt.COL_ID, MakkelijkeMarktProvider.Markt.COL_NAAM, MakkelijkeMarktProvider.Markt.COL_AANWEZIGE_OPTIES }); loader.setSortOrder(MakkelijkeMarktProvider.Markt.COL_NAAM + " ASC"); return loader; }
From source file:com.amsterdam.marktbureau.makkelijkemarkt.LoginFragment.java
/** * Create the cursorloader that will load the accounts from the db * @param id the unique id given in the initloader call * @param args the arguments given in the initloader call * @return the cursor containing the accounts when loaded from the db *///from ww w. java 2 s . c om @Override public Loader<Cursor> onCreateLoader(int id, Bundle args) { // create the loader CursorLoader loader = new CursorLoader(getActivity()); loader.setUri(MakkelijkeMarktProvider.mUriAccount); loader.setProjection( new String[] { MakkelijkeMarktProvider.Account.COL_ID, MakkelijkeMarktProvider.Account.COL_NAAM }); loader.setSortOrder(MakkelijkeMarktProvider.Account.COL_NAAM + " ASC"); return loader; }
From source file:com.readystatesoftware.chuck.internal.ui.TransactionListFragment.java
@Override public Loader<Cursor> onCreateLoader(int id, Bundle args) { CursorLoader loader = new CursorLoader(getContext()); loader.setUri(ChuckContentProvider.TRANSACTION_URI); if (!TextUtils.isEmpty(currentFilter)) { if (TextUtils.isDigitsOnly(currentFilter)) { loader.setSelection("responseCode LIKE ?"); loader.setSelectionArgs(new String[] { currentFilter + "%" }); } else {// www.ja va2 s . c o m loader.setSelection("path LIKE ?"); loader.setSelectionArgs(new String[] { "%" + currentFilter + "%" }); } } loader.setProjection(HttpTransaction.PARTIAL_PROJECTION); loader.setSortOrder("requestDate DESC"); return loader; }
From source file:com.amsterdam.marktbureau.makkelijkemarkt.NotitiesFragment.java
/** * Get the non-removed notities for selected markt and dag * @param id/*from w w w . j a v a 2s . co m*/ * @param args * @return */ @Override public Loader<Cursor> onCreateLoader(int id, Bundle args) { // create the loader that will load the notities with joined table data for selected // markt for today sorted descending on aanmaak tijd CursorLoader loader = new CursorLoader(getActivity()); loader.setUri(MakkelijkeMarktProvider.mUriNotitie); loader.setSelection(MakkelijkeMarktProvider.Notitie.COL_VERWIJDERD + " = ? AND " + MakkelijkeMarktProvider.Notitie.COL_MARKT_ID + " = ? AND " + MakkelijkeMarktProvider.Notitie.COL_DAG + " = ?"); loader.setSelectionArgs( new String[] { "0", args.getString(getString(R.string.sharedpreferences_key_markt_id), null), args.getString(getString(R.string.sharedpreferences_key_date_today), "") }); loader.setSortOrder(MakkelijkeMarktProvider.Notitie.COL_AANGEMAAKT_DATUMTIJD + " DESC"); return loader; }
From source file:com.amsterdam.marktbureau.makkelijkemarkt.DagvergunningenFragment.java
/** * Create a cursor loader to get the dagvergunningen from the db * @param id unique id for this loader//w ww .ja v a 2 s . c o m * @param args the markt id and dag arguments for setting the selection * @return a cursor loader ready to be started */ @Override public Loader<Cursor> onCreateLoader(int id, Bundle args) { // create the loader that will load the dagvergunningen with joined table data for selected // markt for today sorted descending on aanmaak tijd CursorLoader loader = new CursorLoader(getActivity()); loader.setUri(MakkelijkeMarktProvider.mUriDagvergunningJoined); loader.setSelection(MakkelijkeMarktProvider.mTableDagvergunning + "." + MakkelijkeMarktProvider.Dagvergunning.COL_MARKT_ID + " = ? AND " + MakkelijkeMarktProvider.Dagvergunning.COL_DAG + " = ?"); loader.setSelectionArgs( new String[] { args.getString(getString(R.string.sharedpreferences_key_markt_id), null), args.getString(getString(R.string.sharedpreferences_key_date_today), "") }); loader.setSortOrder(MakkelijkeMarktProvider.Dagvergunning.COL_AANMAAK_DATUMTIJD + " DESC"); return loader; }
From source file:com.silentcircle.contacts.list.EmailAddressListAdapter.java
@Override public void configureLoader(CursorLoader loader, long directoryId) { final Builder builder; if (isSearchMode()) { builder = Email.CONTENT_FILTER_URI.buildUpon(); String query = getQueryString(); builder.appendPath(TextUtils.isEmpty(query) ? "" : query); } else {//w ww. j a v a2 s. c om builder = Email.CONTENT_URI.buildUpon(); if (isSectionHeaderDisplayEnabled()) { builder.appendQueryParameter(ScContactsContract.ContactCounts.ADDRESS_BOOK_INDEX_EXTRAS, "true"); } } builder.appendQueryParameter(ScContactsContract.DIRECTORY_PARAM_KEY, String.valueOf(directoryId)); builder.appendQueryParameter(ScContactsContract.REMOVE_DUPLICATE_ENTRIES, "true"); loader.setUri(builder.build()); if (getContactNameDisplayOrder() == ScContactsContract.Preferences.DISPLAY_ORDER_PRIMARY) { loader.setProjection(EmailQuery.PROJECTION_PRIMARY); } else { loader.setProjection(EmailQuery.PROJECTION_ALTERNATIVE); } if (getSortOrder() == ScContactsContract.Preferences.SORT_ORDER_PRIMARY) { loader.setSortOrder(Email.SORT_KEY_PRIMARY); } else { loader.setSortOrder(Email.SORT_KEY_ALTERNATIVE); } }
From source file:com.silentcircle.contacts.list.PhoneNumberListAdapter.java
@Override public void configureLoader(CursorLoader loader, long directoryId) { if (directoryId != Directory.DEFAULT) { Log.w(TAG, "PhoneNumberListAdapter is not ready for non-default directory ID (" + "directoryId: " + directoryId + ")"); }/*from w ww.j av a 2 s.c om*/ final Builder builder; if (isSearchMode()) { final Uri baseUri = mUseCallableUri ? Callable.CONTENT_FILTER_URI : Phone.CONTENT_FILTER_URI; builder = baseUri.buildUpon(); final String query = getQueryString(); if (TextUtils.isEmpty(query)) { builder.appendPath(""); } else { builder.appendPath(query); // Builder will encode the query } builder.appendQueryParameter(ScContactsContract.DIRECTORY_PARAM_KEY, String.valueOf(directoryId)); } else { final Uri baseUri = mUseCallableUri ? Callable.CONTENT_URI : Phone.CONTENT_URI; builder = baseUri.buildUpon().appendQueryParameter(ScContactsContract.DIRECTORY_PARAM_KEY, String.valueOf(Directory.DEFAULT)); if (isSectionHeaderDisplayEnabled()) { builder.appendQueryParameter(ScContactsContract.ContactCounts.ADDRESS_BOOK_INDEX_EXTRAS, "true"); } applyFilter(loader, builder, directoryId, getFilter()); } // Remove duplicates when it is possible. builder.appendQueryParameter(ScContactsContract.REMOVE_DUPLICATE_ENTRIES, "true"); loader.setUri(builder.build()); // TODO a projection that includes the search snippet if (getContactNameDisplayOrder() == ScContactsContract.Preferences.DISPLAY_ORDER_PRIMARY) { loader.setProjection(PhoneQuery.PROJECTION_PRIMARY); } else { loader.setProjection(PhoneQuery.PROJECTION_ALTERNATIVE); } if (getSortOrder() == ScContactsContract.Preferences.SORT_ORDER_PRIMARY) { loader.setSortOrder(Phone.SORT_KEY_PRIMARY); } else { loader.setSortOrder(Phone.SORT_KEY_ALTERNATIVE); } }
From source file:com.silentcircle.contacts.list.ScDefaultContactListAdapter.java
@Override public void configureLoader(CursorLoader loader, long directoryId) { if (loader instanceof ProfileAndContactsLoader) { ((ProfileAndContactsLoader) loader).setLoadProfile(shouldIncludeProfile()); }/*from w w w .ja v a 2 s. c om*/ ContactListFilter filter = getFilter(); if (isSearchMode()) { String query = getQueryString(); if (query == null) { query = ""; } query = query.trim(); if (TextUtils.isEmpty(query)) { // Regardless of the directory, we don't want anything returned, // so let's just send a "nothing" query to the local directory. loader.setUri(RawContacts.CONTENT_URI); loader.setProjection(getProjection(false)); loader.setSelection("0"); } else { Builder builder = RawContacts.CONTENT_FILTER_URI.buildUpon(); builder.appendPath(query); // Builder will encode the query builder.appendQueryParameter(ScContactsContract.DIRECTORY_PARAM_KEY, String.valueOf(directoryId)); if (directoryId != Directory.DEFAULT && directoryId != Directory.LOCAL_INVISIBLE) { builder.appendQueryParameter(ScContactsContract.LIMIT_PARAM_KEY, String.valueOf(getDirectoryResultLimit())); } builder.appendQueryParameter(SearchSnippetColumns.SNIPPET_ARGS_PARAM_KEY, SNIPPET_ARGS); builder.appendQueryParameter(SearchSnippetColumns.DEFERRED_SNIPPETING_KEY, "1"); loader.setUri(builder.build()); loader.setProjection(getProjection(true)); } } else { configureUri(loader, directoryId, filter); loader.setProjection(getProjection(false)); configureSelection(loader, directoryId, filter); } String sortOrder; if (getSortOrder() == ScContactsContract.Preferences.SORT_ORDER_PRIMARY) { sortOrder = RawContacts.SORT_KEY_PRIMARY; } else { sortOrder = RawContacts.SORT_KEY_ALTERNATIVE; } loader.setSortOrder(sortOrder); }