How to specify the sort order for the query to a content provider

Question

I am trying to load all items from a Sqlite Table in Android and want to order the result.

How do I specify the order for the returned cursor?

I query the ContentProvider through a CursorLoader the following way:

new CursorLoader(context, RepresentativeEntityContentProvider.CONTENT_URI, null, null,
            null, null);

Ddene

#20686915 – Haricot

additional to accepted answer: its possible to sort for more then one column, e.g. "column_name1 ASC, column_name2 DESC, column_nameN ASC" where DESC means descending. – Promethean

Answer 1

try below code change COLUMN_NAME with actual column name on which you wants to sort.

new CursorLoader(context, RepresentativeEntityContentProvider.CONTENT_URI, null, null,
            null, "COLUMN_NAME ASC");

Thursby

for example if you're looking for images and you want to see the latest first - add: "date_modified DESC" – Oleate

Answer 2

new CursorLoader(context, RepresentativeEntityContentProvider.CONTENT_URI, null, null,
            null, "column_name ASC");

or

new CursorLoader(context, RepresentativeEntityContentProvider.CONTENT_URI, null, null,
                null, "column_name DESC")

;

Respecting