CODEWITHSUNDEEP
androidandroid-contentprovider
Volodymyr
Volodymyr

Reputation: 6579

android get data from two cursors in one sorted by date list

I want to display phone numbers from call history and inbox message in one listView sorted by date. I am using two cursors; one retrieves calls, and second retrieves incoming messages. Two of them sorted by date. But first I populate contacts and then messages. How can I populate this list with contacts and messages sorted by date?

Here my code:

    public static List<Call> getCallHistory() {
    boolean filter = context.getSharedPreferences(PREFERENCES_NAME, Context.MODE_PRIVATE).getInt("filter", 0) == 1;
    String[] strFields = { CallLog.Calls._ID, CallLog.Calls.NUMBER, CallLog.Calls.CACHED_NAME, CallLog.Calls.TYPE, CallLog.Calls.DATE,
            CallLog.Calls.DURATION };
    String strOrder = CallLog.Calls.DATE + " DESC";
    final Cursor cursorCall = context.getContentResolver().query(CallLog.Calls.CONTENT_URI, strFields, null, null, strOrder);

    List<Call> callList = new ArrayList<Call>();

    while (cursorCall.moveToNext()) {
        Call call = new Call();
        call.setNumber(cursorCall.getString(cursorCall.getColumnIndex(CallLog.Calls.NUMBER)));
        if (cursorCall.getInt(cursorCall.getColumnIndex(CallLog.Calls.TYPE)) == CallLog.Calls.OUTGOING_TYPE) {
            call.setOut(true);
        } else {
            call.setOut(false);
        }

        call.setName(cursorCall.getString(cursorCall.getColumnIndex(CallLog.Calls.CACHED_NAME)));
        call.setTime(cursorCall.getLong(cursorCall.getColumnIndex(CallLog.Calls.DATE)));
        call.setDuration(cursorCall.getLong(cursorCall.getColumnIndex(CallLog.Calls.DURATION)));

        if (filter && cursorCall.getString(cursorCall.getColumnIndex(CallLog.Calls.CACHED_NAME)) != null) {
            continue;
        }
        callList.add(call);
    }
    cursorCall.close();
    return getMessageHistory(callList);
    // return callList;
}

public static List<Call> getMessageHistory(List<Call> callList) {
    String[] projection = { "address", "date", "body" };
    String sortOrder = "date DESC";
    Cursor cursor = context.getContentResolver().query(SMS_INBOX_CONTENT_URI, projection, null, null, sortOrder);
    while (cursor.moveToNext()) {

        Call call = new Call();
        call.setNumber(cursor.getString(cursor.getColumnIndex("address")));
        call.setTime(cursor.getLong(cursor.getColumnIndex("date")));
        call.setBody(cursor.getString(cursor.getColumnIndex("body")));
        call.setSms(true);

        callList.add(call);
    }
    return callList;
}

Upvotes: 2

Views: 979

Answers (1)

Greg Ennis
Greg Ennis

Reputation: 15379

You should use the Android MergeCursor, it is created just for that purpose.

In your case something like

Cursor cursorCall = context.getContentResolver().query(CallLog.Calls.CONTENT_URI, strFields, null, null, strOrder);
Cursor cursorInbox = context.getContentResolver().query(SMS_INBOX_CONTENT_URI, projection, null, null, sortOrder);
Cursor merged = new MergeCursor(new Cursor[] { cursorCall, cursorInbox });

If the columns not matching up causes problems, you can use CursorWrapper to align them.

Upvotes: 2

Related Questions