Filter ODK Aggregate content

Hello,

We are using odk collect to fill multiple forms. To link the forms together
we are using a "Student ID" field. Now, we would like to lookup the
"Student ID" from ODK aggregate given a student name. Does ODK aggregate
expose an API with a functionality to filter the forms based on some
criteria, because I see this functionality in the ODK Aggregate web
application.

Would you please recommended a way to approach this problem.

Thanks,
Meera

For significant data processing, we recommend using an external system for
data analysis.

You can apply a filter to the data being published, and you can apply a
filter to CSV exports (the filter applies to values outside of any repeat
groups, and not to the repeats within that table).

The filters only work on non-multiple-choice fields, and on fields outside
of any repeat groups. If you are using a MySQL database, only roughly the
first 200 fields can be used in the filter (on AppEngine and with the
PostgreSQL database, this limitation applies to the first 3900 fields and
is unlikely to occur in practice).

Mitch

··· On Fri, Oct 17, 2014 at 10:06 PM, Meera Kamath wrote:

Hello,

We are using odk collect to fill multiple forms. To link the forms
together we are using a "Student ID" field. Now, we would like to lookup
the "Student ID" from ODK aggregate given a student name. Does ODK
aggregate expose an API with a functionality to filter the forms based on
some criteria, because I see this functionality in the ODK Aggregate web
application.

Would you please recommended a way to approach this problem.

Thanks,
Meera

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

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

I am still confused, Let me rephrase my question. How do I filter the data
available in ODK Aggregate programmatically?

Thanks,
Meera

··· On Mon, Oct 20, 2014 at 2:58 PM, Mitch Sundt wrote:

For significant data processing, we recommend using an external system for
data analysis.

You can apply a filter to the data being published, and you can apply a
filter to CSV exports (the filter applies to values outside of any repeat
groups, and not to the repeats within that table).

The filters only work on non-multiple-choice fields, and on fields outside
of any repeat groups. If you are using a MySQL database, only roughly the
first 200 fields can be used in the filter (on AppEngine and with the
PostgreSQL database, this limitation applies to the first 3900 fields and
is unlikely to occur in practice).

Mitch

On Fri, Oct 17, 2014 at 10:06 PM, Meera Kamath meera.kamath12@gmail.com wrote:

Hello,

We are using odk collect to fill multiple forms. To link the forms
together we are using a "Student ID" field. Now, we would like to lookup
the "Student ID" from ODK aggregate given a student name. Does ODK
aggregate expose an API with a functionality to filter the forms based on
some criteria, because I see this functionality in the ODK Aggregate web
application.

Would you please recommended a way to approach this problem.

Thanks,
Meera

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

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/UmH7gwOX3Ts/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

We don't expose a programmatic way to do this.

··· On Mon, Oct 20, 2014 at 12:03 PM, Meera Kamath wrote:

I am still confused, Let me rephrase my question. How do I filter the data
available in ODK Aggregate programmatically?

Thanks,
Meera

On Mon, Oct 20, 2014 at 2:58 PM, Mitch Sundt mitchellsundt@gmail.com wrote:

For significant data processing, we recommend using an external system
for data analysis.

You can apply a filter to the data being published, and you can apply a
filter to CSV exports (the filter applies to values outside of any repeat
groups, and not to the repeats within that table).

The filters only work on non-multiple-choice fields, and on fields
outside of any repeat groups. If you are using a MySQL database, only
roughly the first 200 fields can be used in the filter (on AppEngine and
with the PostgreSQL database, this limitation applies to the first 3900
fields and is unlikely to occur in practice).

Mitch

On Fri, Oct 17, 2014 at 10:06 PM, Meera Kamath meera.kamath12@gmail.com wrote:

Hello,

We are using odk collect to fill multiple forms. To link the forms
together we are using a "Student ID" field. Now, we would like to lookup
the "Student ID" from ODK aggregate given a student name. Does ODK
aggregate expose an API with a functionality to filter the forms based on
some criteria, because I see this functionality in the ODK Aggregate web
application.

Would you please recommended a way to approach this problem.

Thanks,
Meera

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

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/UmH7gwOX3Ts/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

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