How to get the Event instance from android calender api?

Question

i am trying to get the id of an instance of recurring event, i am doing this task like this

                                     final String[] INSTANCE_PROJECTION = new String[] {
                                            Instances.EVENT_ID,      // 0
                                            Instances.BEGIN,         // 1
                                            Instances.TITLE          // 2
                                          };
                                    Calendar beginTime = Calendar.getInstance();
                                    beginTime.set(2011, 9, 23, 8, 0);
                                    long startMillis = beginTime.getTimeInMillis();
                                    Calendar endTime = Calendar.getInstance();
                                    endTime.set(2011, 10, 24, 8, 0);
                                    long endMillis = endTime.getTimeInMillis();

                                    Cursor cur = null;
                                    ContentResolver cr = view.getContext().getContentResolver();

                                    String selection = Instances.EVENT_ID + " = ?";
                                    String[] selectionArgs = new String[] {"207"};

                                    Uri.Builder builder = Instances.CONTENT_URI.buildUpon();
                                    ContentUris.appendId(builder, startMillis);
                                    ContentUris.appendId(builder, endMillis);

                                    final int PROJECTION_ID_INDEX = 0;
                                    final int PROJECTION_BEGIN_INDEX = 1;
                                    final int PROJECTION_TITLE_INDEX = 2;

                                    cur =  cr.query(builder.build(), 
                                            INSTANCE_PROJECTION, 
                                            selection, 
                                            selectionArgs, 
                                            null);

                                    while (cur.moveToNext()) {
                                        String title = null;
                                        long eventID = 0;
                                        long beginVal = 0;    

                                        // Get the field values
                                        eventID = cur.getLong(PROJECTION_ID_INDEX);
                                        beginVal = cur.getLong(PROJECTION_BEGIN_INDEX);
                                        title = cur.getString(PROJECTION_TITLE_INDEX);

                                        // Do something with the values. 
                                        //Log.i(DEBUG_TAG, "Event:  " + title); 
                                        Calendar calendar = Calendar.getInstance();
                                        calendar.setTimeInMillis(beginVal);  
                                        SimpleDateFormat formatter  = new SimpleDateFormat("MM/dd/yyyy");
                                        //Log.i(DEBUG_TAG, "Date: " + formatter.format(calendar.getTime()));    
                                        Toast.makeText(view.getContext(), "Date: " + formatter.format(calendar.getTime()), Toast.LENGTH_SHORT).show();

but it is not working, i don't understand where did i go wrong. if anyone gets the problem please let me know.

i got the same problem, and still not able to find a solution. — , Jun 13 '14 at 09:51

score 2 · Accepted Answer · edited Mar 27 '16 at 20:07

I have done it sucessfully, now I am able to get an instance.. here is a code:

  final String[] INSTANCE_PROJECTION = new String[] {

                                            Instances.EVENT_ID,      // 0
                                            Instances.BEGIN,         // 1
                                            Instances.TITLE          // 2
                                          };
                                    Calendar beginTime = Calendar.getInstance();
                                    beginTime = selectedAppointmentInstance.getStartDate();
                                    long startMillis = beginTime.getTimeInMillis();
                                    Calendar endTime = Calendar.getInstance();
                                    endTime = selectedAppointmentInstance.getEndDate();
                                    long endMillis = endTime.getTimeInMillis()-1;

                                    Cursor cur = null;
                                    ContentResolver cr = view.getContext().getContentResolver();

                                    String selection = Instances.EVENT_ID + " = ?" ;
                                    String[] selectionArgs = new String[] {selectedAppointmentInstance.getAppointmentId()};

                                    Uri.Builder builder = Instances.CONTENT_URI.buildUpon();
                                    ContentUris.appendId(builder, startMillis);
                                    ContentUris.appendId(builder, endMillis);




                                    String where=Instances.EVENT_ID + " = " + selectedAppointmentInstance.getAppointmentId();
                                     final int PROJECTION_ID_INDEX = 0;
                                    final int PROJECTION_BEGIN_INDEX = 1;
                                    final int PROJECTION_TITLE_INDEX = 2;

                                    cur =  cr.query(builder.build(), 
                                            INSTANCE_PROJECTION, 
                                            selection, 
                                            selectionArgs, 
                                            null);

                                    while (cur.moveToNext()) {
                                        String title = null;
                                        long eventID = 0;
                                        long beginVal = 0;    

                                        // Get the field values
                                        eventID = cur.getLong(PROJECTION_ID_INDEX);
                                        beginVal = cur.getLong(PROJECTION_BEGIN_INDEX);
                                        title = cur.getString(PROJECTION_TITLE_INDEX);

                                        // Do something with the values. 
                                        //Log.i(DEBUG_TAG, "Event:  " + title); 
                                        Calendar calendar = Calendar.getInstance();
                                        calendar.setTimeInMillis(beginVal);  
                                        SimpleDateFormat formatter  = new SimpleDateFormat("MM/dd/yyyy");
                                        //Log.i(DEBUG_TAG, "Date: " + formatter.format(calendar.getTime()));    
                                        Toast.makeText(view.getContext(), "Date: " + formatter.format(calendar.getTime()), Toast.LENGTH_SHORT).show();






                                    }

this is great thanks man you solved it... take my upvote.. :) — , Jun 17 '14 at 13:04

How to get the Event instance from android calender api?

1 Answers1