android sqlite sorting/ ORDER BY query

Question

I have combine list which contains red color or not. I want to sort my result as below -

If color is not red then display result Alphabetically. (in continuation of list) ---> If color is red then display rest of element Alphabetically.

I am expecting below result :

// If color is not red then display result Alphabetically

orange A (color is not red & alphabetically order)

blue B (color is not red & alphabetically order)

white C (color is not red & alphabetically order)

black D (color is not red & alphabetically order)

//(in continuation of list) ---> If color is red then display rest of element Alphabetically

red A (color is red & alphabetically order)

red B (color is red & alphabetically order)

red C (color is red & alphabetically order)

To achieve this, i am trying below query :

public Loader<Cursor> onCreateLoader(int id, Bundle args) {
    switch (id) {

        case SORT_BY_ALPHABETICALLY:

            String orderAlphabetically = BY_NAME + " ASC, "
                + BY_COLOR + " ASC";

            return new CursorLoader(ctx,
                    URI,
                    null,
                    null,
                    null,
                    orderAlphabetically);

but above query is not giving expected result.

Try this: http://stackoverflow.com/questions/20686415/how-to-sort-the-cursorloader-results — T D Nguyen, Mar 06 '16 at 21:13
Would you please provide some sample table data and expected output? — Ullas, Mar 07 '16 at 07:21

score 0 · Answer 1 · answered Mar 07 '16 at 08:12

0

You want to sort by redness first, then by name.

In SQLite, a boolean expression returns either 0 or 1, so this is exactly what you want for sorting:

SELECT ... ORDER BY Color = 'red' ASC, Name ASC;

answered Mar 07 '16 at 08:12

CL.

173,858
17
217
259

android sqlite sorting/ ORDER BY query

1 Answers1