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);

http://stackoverflow.com/questions/20686415/how-to-sort-the-cursorloader-results — Phantômaxx, Dec 29 '14 at 09:47
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. — Cor, Mar 26 '22 at 11:16

score 44 · Accepted Answer · answered Dec 29 '14 at 09:48

44

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");

answered Dec 29 '14 at 09:48

Roll no1

3

for example if you're looking for images and you want to see the latest first - add: "date_modified DESC" – Kirill Karmazin May 31 '17 at 16:56

VikasGoyal · Answer 2 · 2014-12-29T10:27:30.697

11

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")

;

edited Dec 29 '14 at 10:27

answered Dec 29 '14 at 09:50

VikasGoyal

2 Answers2