Query saved data in ODK Tables

Support
1

Hi ODK,

There is very little help available as how to query data in odk tables.

Can someone shed some light on this subject?

Regards,
Ayub

2

Ayub,

ODK Tables is alpha, so there isn't a ton of information besides what
you see at https://code.google.com/p/opendatakit/wiki/TablesAlphaWalkThrough.

That said, you are more likely to get a response from the dev team if
you can be more specific about the question. What do you mean by query
data? Do you mean query the data through the app? Using an external
app? The more details, the better.

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Thu, Dec 19, 2013 at 11:44 PM, Ayub nrspaggregate@gmail.com wrote:

Hi ODK,

There is very little help available as how to query data in odk tables.

Can someone shed some light on this subject?

Regards,
Ayub

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

3

Hi Yaw,

I tried ODK Tables, made a new table, clicked (+) it opened up ODK Collect
for collection, now my question was is it possible to some how query saved
data ( that we see in ODK Tables once collection is complete) e.g. query id
of a person, perhaps using Xforms (i guess ODK tables generate an Xform).

Is it possible i could query ODK Tables outside Tables and Collect, like a
database, through my own android application?

Thanks,

Regards,
Ayub

4

Is it possible i could query ODK Tables outside Tables and Collect, like
a database, through my own android application?
The short answer is yes... a question like that is best posted to the
opendatakit-developers list.

Also please note, ODK Tables is in alpha which means the core team may
change things, possibly substantially change things. In the case of Tables
there are some large changes to the database that are planned with the
Beta. The release of the Beta is planned for sometime early in the new
year.

Waylon

··· On Sun, Dec 22, 2013 at 2:22 AM, Ayub wrote:

Hi Yaw,

I tried ODK Tables, made a new table, clicked (+) it opened up ODK Collect
for collection, now my question was is it possible to some how query saved
data ( that we see in ODK Tables once collection is complete) e.g. query id
of a person, perhaps using Xforms (i guess ODK tables generate an Xform).

Is it possible i could query ODK Tables outside Tables and Collect, like a
database, through my own android application?

Thanks,

Regards,
Ayub

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

5

Hi Waylon,

Tables is a new product and i thought community would have similar
questions that is why i posted my question in community forms, you're right
that it belongs in developers section.

It is great that we would be able to query data from it, any specifics on
how we can do this using Xforms.

Just wanted to try it out.

Regards,
Ayub

6

Under a number of restrictions, if ODK Survey is installed, you can access
any row/submission in ODK Tables via

If you install ODK Survey, you can access the XForms submission XML via its
SubmissionProvider. That takes 2 query parameters (formId and formVersion)
to specify the form to use when creating the XML, since there can be
multiple forms to update or manipulate a single data table (to implement a
workflow on your device).

Mitch

··· On Mon, Dec 23, 2013 at 3:59 AM, Ayub wrote:

Hi Waylon,

Tables is a new product and i thought community would have similar
questions that is why i posted my question in community forms, you're right
that it belongs in developers section.

It is great that we would be able to query data from it, any specifics on
how we can do this using Xforms.

Just wanted to try it out.

Regards,
Ayub

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

7

Thanks Mitch, i will look into it.