Android: Sorting a merged cursor

Question

Hi,

I'm wondering if there's any way to merge two cursors together and then resort them.

I can easily merge two cursors together by using a MergedCursor, but that doesn't sort them.

I have two sets of contacts in two separate cursors (with totally different schemas) and I want to merge them and sort them by name (the name column is different in the two cursors).

Is this possible?

Thanks,

Tony

Answer 1

Perhaps you should rather create an SQL query that returns a cursor that contains all data that you want to view than to create two different query and try to merge them once you have a cursor?

Answer 2

As a lengthy, probably not very efficient solution, you could use this combined cursor to create another databse, and sort from that query. Otherwise just add the items from the native phone contacts to your database periodically or something?

Answer 3

You can use SortCursor from android sources with slight modifications (different column names), see http://android.git.kernel.org/?p=platform/packages/apps/Gallery3D.git;a=blob;f=src/com/cooliris/media/SortCursor.java