Page 1 of 1

Query Content Provider - addition

Posted: 14 Jul 2016 10:10
by qwertz
Hi Martin,
in Google calendar there are reminders available for some time now.
Can these also be added to the query content provider function?
Right now they don't show up with a "calendar_id" or something like that...

It would be nice to have a possibility to query these reminders too!
Please consider.

Many thanks for you amazing work!

Re: Query Content Provider - addition

Posted: 14 Jul 2016 19:54
by Martin
Hi,

You can already query the reminders today. It's quite complicated...
First try to find the event_id of the calendar event that you are interested in (e.g. using the All current calendar events example).

Create a second action Query Content Provider with following settings:
Content URI: content://com.android.calendar/reminders
Set selection to event_id=? and the selection arguments to {event_id} (this assumes that the event ID in the first step was stored in variable event_id).
Result type: Table (transposed)
check Include header row
Variable: reminders

You can view the resulting list of reminders with a condition Debug Dialog. Select the variable reminders and click Change value which will bring up a dialog with the result in a readable way. The result should contain columns minute and method. Minute is the amount of minutes to remind before the event starts. Method is documented as 1=Alert, 2=Email, 3=SMS, 4=Alarm (2 and 1 are commonly used).

Regards,
Martin

Re: Query Content Provider - addition

Posted: 15 Jul 2016 08:57
by qwertz
Hi Martin,
thanks for info. This is great addition.

But I was not speaking of timely reminders for an existing event.
I meant this:
http://www.theverge.com/2016/4/5/113710 ... -reminders

Sorry for not being precise enough... Is this possible to integrate?

Regards

Re: Query Content Provider - addition

Posted: 15 Jul 2016 20:09
by Martin
I was not even aware that such a feature exists :-) The official documentation about accessing the calendar seems not to mention this kind of reminders yet. Maybe it's not disclosed to third party apps.
I'll add it to the todo-list to check if it's feasible to somehow access it anyway.

Re: Query Content Provider - addition

Posted: 18 Jul 2016 10:14
by qwertz
Hi Martin,

sounds great!!! ...as always :D

Thanks for consideration. Hopefully it is possible...
Looking forward to it.

Have a nice day :)