안드로이드 개발 질문/답변
(글 수 45,052)
final ContentResolver cr = context.getContentResolver(); final Cursor cursorImages = cr.query(uriImages, IMAGE_PROJECTION, null, null, "title ASC"); public final Cursor query (Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder)
이미지 파일을 검색해서 리스트 어레이에 넣어주는데요~
title ASC로 정렬을 하게 되면 이름순으로 정렬이 잘됩니다. 그런데 저는 날짜순으로 하고 싶은데요!
date, Date, DATE 넣어봤는데 안되네요.
title 이라는게 테이블 정보같은데 전체 테이블의 정보를 볼 수 있는 방법이 있나요??
아니면 날짜 순으로 정렬할려면 어떤 테이블 명을 써야 될까요!!
답변 부탁드려요!
2010.09.07 12:45:39
컨텐트 프로바이더를 사용하실때는 android.provider패키지밑에 관련 클래스가 있습니다. 해당 클래스에 상수로 컬럼명이 정의되있을겁니다 api를 찾아보세요
2010.09.07 12:55:09
API를 확인해보니 android.provider.MediaStore.Images.ImageColumns.DATE_TAKEN 을 사용하면
될것 같네요.
될것 같네요.
2010.09.07 15:14:12
답변감사합니다.
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822387000.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822386000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822461427.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822460000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822669949.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822670000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822709718.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822708000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822750342.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822750000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822862620.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822862000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822919949.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822920000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822952526.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822952000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283823389015.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283823388000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283824398166.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283824398000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283824486052.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283824486000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283824510150.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283824510000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283824646438.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283824646000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283824681771.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283824680000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283824745983.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283824746000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283824864576.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283824864000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283824943559.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283824942000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283825025004.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283825024000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283825114381.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283825114000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283825272456.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283825272000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283825376042.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283825376000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283825623550.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283825622000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283837755045.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283837756000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283837863810.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283837862000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283837898366.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283837898000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283838066212.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283838066000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283838220622.jpg
로그를 찍어보면 이렇게 나오거든요.
DATE_TAKEN, DATE_ADDED, DATE_MODIFIED
그래서 리스트어레이에 저 값들을 다 저장한 후에 날짜 순으로 정렬할려는거였거든요
다들 이런 현상이 발생하네요 ㅎ
static final String[] IMAGE_PROJECTION = { MediaStore.Images.ImageColumns.DATA, MediaStore.Images.ImageColumns.DATE_TAKEN };이걸 쓰고 있는데요. 로그를 찍어보면
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822387000.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822386000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822461427.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822460000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822669949.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822670000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822709718.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822708000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822750342.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822750000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822862620.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822862000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822919949.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822920000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283822952526.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283822952000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283823389015.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283823388000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283824398166.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283824398000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283824486052.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283824486000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283824510150.jpg
09-07 05:43:53.895: INFO/CamView(220): 1283824510000
09-07 05:43:53.895: INFO/CamView(220): /sdcard/DCIM/Camera/1283824646438.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283824646000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283824681771.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283824680000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283824745983.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283824746000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283824864576.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283824864000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283824943559.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283824942000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283825025004.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283825024000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283825114381.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283825114000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283825272456.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283825272000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283825376042.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283825376000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283825623550.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283825622000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283837755045.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283837756000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283837863810.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283837862000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283837898366.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283837898000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283838066212.jpg
09-07 05:43:53.904: INFO/CamView(220): 1283838066000
09-07 05:43:53.904: INFO/CamView(220): /sdcard/DCIM/Camera/1283838220622.jpg
로그를 찍어보면 이렇게 나오거든요.
DATE_TAKEN, DATE_ADDED, DATE_MODIFIED
그래서 리스트어레이에 저 값들을 다 저장한 후에 날짜 순으로 정렬할려는거였거든요
다들 이런 현상이 발생하네요 ㅎ
테이블에 날짜 정보를 넣으셨다면 title대신에 날짜 필드를 넣으시면 될텐데요.
테이블에 날짜를 저장하지 않으신것 아닌지?