How to use distinct query in Android ContentResolver for displaying image folder

Question

I need a distinct query for Album wise image and video display, like gallery in Android. I attached my source code below. My problem is that I'm getting repeated folder names displaying. How can I use a distinct query in this code?

String[] PROJECTION_BUCKET = {"DISTINCT "+ ImageColumns.BUCKET_ID,
                ImageColumns.BUCKET_DISPLAY_NAME, ImageColumns.DATE_TAKEN,
                ImageColumns.DATA }; 
Cursor cur = getContentResolver().query(MediaStore.Images.Media.EXTERNAL_CONTENT_URI, PROJECTION_BUCKET,
                MediaStore.Images.Media.DATA + " like ? ",new String[] {"%" + "MidasOnline/Images_UserID_95"+fname+"" + "%"}, null);`

score 2 · Answer 1 · edited May 23 '17 at 12:08

2

You need to add GROUPBY in selection for DISTINCT to work

ImageColumns.BUCKET_ID+" IS NOT NULL) GROUP BY ("+ImageColumns.BUCKET_ID

more info at this link.

edited May 23 '17 at 12:08

Community

1
1

answered Apr 11 '16 at 10:08

Muhammad Hamza Shahid

956
1
15
23

score 1 · Answer 2 · answered Sep 07 '15 at 17:58

1

try it:

String[] projection= { "DISTINCT _id", "DISTINCT address"};

Cursor address =  getContentResolver().query(android.provider.Telephony.Sms.Inbox.CONTENT_URI,projection, null, null,"address ASC");

answered Sep 07 '15 at 17:58

Elton da Costa

1,279
16
27

1

Nope this doesn't work! results in an exception for contentresolver! – sud007 Oct 26 '17 at 12:33
1

This results in an exception in the content resolver. – Khushal Chouhan Jan 04 '18 at 11:45

score -1 · Answer 3 · answered Apr 21 '20 at 14:45

Take a look at this answer.

val uri = MediaStore.Images.Media.EXTERNAL_CONTENT_URI
val projection = arrayOf(
    "DISTINCT " + MediaStore.Images.Media.BUCKET_ID,
    MediaStore.Images.Media.BUCKET_DISPLAY_NAME,
    MediaStore.Images.Media.BUCKET_ID,
    MediaStore.MediaColumns.DATA
)
val groupBySelection = " 1) GROUP BY (${MediaStore.Images.Media.BUCKET_ID}"
contentResolver.query(
    uri,
    projection,
    null,
    groupBySelection,
    null,
    null
)

How to use distinct query in Android ContentResolver for displaying image folder

3 Answers3