Query Content Provider - addition

Post your feature requets for new triggers, conditions, actions and other improvements.

Moderator: Martin

Post Reply
qwertz
Posts: 25
Joined: 14 Oct 2015 07:37

Query Content Provider - addition

Post by qwertz » 14 Jul 2016 10:10

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!

User avatar
Martin
Posts: 4434
Joined: 09 Nov 2012 14:23

Re: Query Content Provider - addition

Post by Martin » 14 Jul 2016 19:54

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

qwertz
Posts: 25
Joined: 14 Oct 2015 07:37

Re: Query Content Provider - addition

Post by qwertz » 15 Jul 2016 08:57

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

User avatar
Martin
Posts: 4434
Joined: 09 Nov 2012 14:23

Re: Query Content Provider - addition

Post by Martin » 15 Jul 2016 20:09

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.

qwertz
Posts: 25
Joined: 14 Oct 2015 07:37

Re: Query Content Provider - addition

Post by qwertz » 18 Jul 2016 10:14

Hi Martin,

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

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

Have a nice day :)

Post Reply