Construct MediaStore Query uri for multiple folders on sdcard

Question

Good day, i am trying to return images from different specific folders in an SD Card through a MediaStore Query. So far, i can successfully query for a single folder but am getting stuck in how to do it for multiple folders. code is like this:

cursor = getContentResolver().query(MediaStore.Images.Media.EXTERNAL_CONTENT_URI, img, 
     MediaStore.Images.Media.DATA + " like ? ", new String[]{"%" + "dcim" + "%"}, null);

i tried constructing something like this and other similar queries, but its not working:

cursor = getContentResolver().query(MediaStore.Images.Media.EXTERNAL_CONTENT_URI, img, 
MediaStore.Images.Media.DATA + " like ? ", new String[]{"%" + "dcim" + "%","%" + "downloads" + "%" }, null);

please any help will be appreciated. Thank you.

hmmm.. no ideas or links where to find information on this?.. — irobotxx, Oct 10 '11 at 14:18

score 2 · Answer 1 · answered Jan 06 '13 at 14:54

Should be something like that:

cursor = getContentResolver().query(
    MediaStore.Images.Media.EXTERNAL_CONTENT_URI, 
    img,
    MediaStore.Images.Media.DATA + " like ? OR "+MediaStore.Images.Media.DATA+" like ?", 
    new String[]{"%" + "dcim" + "%","%" + "downloads" + "%" }, 
    null);

score 0 · Answer 2 · edited May 23 '17 at 11:48

0

A one possible solution is to use multiple queries for every specific location and then join them with CursorJoiner like already showed here:

Android Can I use JOIN at mediastore query

edited May 23 '17 at 11:48

Community

1
1

answered Feb 23 '12 at 10:31

Michal Harakal

1,025
15
21

Construct MediaStore Query uri for multiple folders on sdcard

2 Answers2