ListView using two cursoradapters?

Question

I have some code which executes two queries against a database and returns two cursor objects. Is there any way that I can combine these two cursors so that all the ListView gets the data from both?

score 14 · Accepted Answer · edited Nov 12 '16 at 22:46

14

There's MergeCursor for that (if there's no way to join tables).

edited Nov 12 '16 at 22:46

Halalbin

95
12

answered Jul 13 '10 at 19:00

yanchenko

56,576
33
147
165

I think there is a way to join tables using SQLiteQueryBuilder setTables (String inTables) methods, I myself is going to try it – 2cupsOfTech May 29 '12 at 11:08

score 9 · Answer 2 · answered Oct 15 '11 at 06:34

FYI - An example of using MergeCursor()

c = Cursor containing Contacts columns from Contacts.CONTENT_URI

private Cursor mergeCursorSubset(Cursor c) {

    int userMobile = ContactsContract.CommonDataKinds.Phone.TYPE_MOBILE,
        workMobile = ContactsContract.CommonDataKinds.Phone.TYPE_WORK_MOBILE;

    String storedNumber = ContactsContract.CommonDataKinds.Phone.NUMBER,
            displayName =ContactsContract.CommonDataKinds.Phone.DISPLAY_NAME,
            numberType = ContactsContract.CommonDataKinds.Phone.TYPE,
            contactKey = ContactsContract.CommonDataKinds.Phone.LOOKUP_KEY,
            whereClausePre = contactKey+" = '",
            whereClausePost = "AND ("+numberType+" = '"+userMobile+"' OR "+numberType+" = '"+workMobile+"'";


    Uri lookupUri = ContactsContract.CommonDataKinds.Phone.CONTENT_URI;;

    Cursor [] m = new Cursor[c.getCount()]; 

    if (c.moveToFirst())
        for (int k = 0; k<c.getCount();k++){            
            //Find the mobile numbers
            Cursor u = this.getContentResolver().query(lookupUri,
                                                    new String[]{displayName, storedNumber, numberType}
                                                    , whereClausePre+c.getString(c.getColumnIndex(Contacts.LOOKUP_KEY))+"') " 
                                                        + whereClausePost, null, null);
            int i = 0;
            if (u.moveToFirst())
                m[i++] = u;

        } //for Each key

    return new MergeCursor(m);

}

can you further explain it? – Shajeel Afzal Jun 20 '13 at 09:36 — Shajeel Afzal, Jun 20 '13 at 09:36

score 4 · Answer 3 · answered Jul 13 '10 at 12:56

4

You can also use cwac-merge.

cwac-merge: Provides the MergeAdapter, a ListAdapter that blends multiple Views or ListAdapters into a single ListAdapter. Use this for section headings, blending multiple sources of data together, etc.

answered Jul 13 '10 at 12:56

Macarse

91,829
44
175
230

score 1 · Answer 4 · answered Jul 13 '10 at 09:29

1

Check out MatrixCursor.

Maybe this will help you also Android - Database Table Join

answered Jul 13 '10 at 09:29

Pentium10

204,586
122
423
502

ListView using two cursoradapters?

4 Answers4

Linked