You can see in the queries tab how we use “selection” to show the list of opposite-sex individuals, for example, in roster_spouse. You can do something similar with your variable for age being >=15. Note you will need to make sure to also use the household identifier – for my example it is q100 – to make sure that you have only members of the same household.
I was actually asking about ODK, and after going to ODK forums I found out that what I’m trying to do is not possible using ODK.
What you showed though seems very interesting and provides more flexibility when designing complex household surveys.
Which makes me think I should switch to ODK-X instead of ODK when designing this particular survey.
I have 2 questions:
Are there any online tutorials, like videos maybe, to learn ODK-X?
How easy is it to integrate ODK-X with an online database or API?
ODK-X sync-endpoint has an API you can access the data, though you have to understand the protocol which is more complicated as it maintains data synchronization. However, if you are simply pulling rows not editing them, it’s much simpler. Check out Suitcase to see a simple download of the data.