Showing a subset of other registered clients in a particular question

Hi all,

Our team is working on setting up a CommCare application for Home Based HIV
testing, and have come up with a technical question we are struggling with.

For this application, clients are tested at their homes, and we provide the
option for couples to be tested together. In instances when a couple is
tested together, they will always be listed in the same household, even if
they are not both resident there. In cases where a couple is tested
together, we would like to be able to link their records in CommCare in
some way, so that we can be confident of the number of couples tested that
we report, and avoid any overcounting/double-counting.

Ideally, what we would like to do, is when the ‘tested as a couple’ option
is selected, provide our staff member with a drop-down list of names/UIDs
of all other individuals registered in the same household. If household
were saved as a case property for all individuals registered in a
household, would it be possible to do this? We’ve been able to get a
dropdown menu of all registered individuals to show up, but we are not
sure how to limit this by individuals in a particular household (or if this
is even possible).

Any suggestions?

Many thanks!
Julia

Hi Julia

Have you had any response to this? If not I’ll reach out to a few people on
Monday and see what the solution is.

It is definitely possible to filter the list of cases by case type and by
closed status and I’m pretty sure you can add a filter that will filter by
any other car property as well except that I think the performance on the
phone will probably be poor.

Anyway, I’ll get back to you on Monday with a more concrete answer.

Simon

··· On 7 Jul 2015 10:06, "Julia de Kadt" wrote:

Hi all,

Our team is working on setting up a CommCare application for Home Based
HIV testing, and have come up with a technical question we are struggling
with.

For this application, clients are tested at their homes, and we provide
the option for couples to be tested together. In instances when a couple is
tested together, they will always be listed in the same household, even if
they are not both resident there. In cases where a couple is tested
together, we would like to be able to link their records in CommCare in
some way, so that we can be confident of the number of couples tested that
we report, and avoid any overcounting/double-counting.

Ideally, what we would like to do, is when the ‘tested as a couple’ option
is selected, provide our staff member with a drop-down list of names/UIDs
of all other individuals registered in the same household. If household
were saved as a case property for all individuals registered in a
household, would it be possible to do this? We’ve been able to get a
dropdown menu of all registered individuals to show up, but we are
not sure how to limit this by individuals in a particular household (or if
this is even possible).

Any suggestions?

Many thanks!
Julia


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

Hi Julia

I got an email regarding your question this morning and my initial thought
was correct that you can just add a filter expression to your casedb query.
With reference to this page on the wiki
https://confluence.dimagi.com/display/commcarepublic/Multiple+Choice+Questions+with+Cases+as+Choices
you
would have to add the following to your form XML (by editing the XML
manually):

Where the wiki page shows this line:

You can adjust it to include your case property query as follows:

Assuming that the case property is called ‘household’ and the the name of
the household you are searching against is in the form property
’/data/selected_household’.

Let me know if you have any trouble getting that to work.

Best regards
Simon

··· On 10 July 2015 at 19:19, Simon Kelly wrote:

Hi Julia

Have you had any response to this? If not I’ll reach out to a few people
on Monday and see what the solution is.

It is definitely possible to filter the list of cases by case type and by
closed status and I’m pretty sure you can add a filter that will filter by
any other car property as well except that I think the performance on the
phone will probably be poor.

Anyway, I’ll get back to you on Monday with a more concrete answer.

Simon
On 7 Jul 2015 10:06, “Julia de Kadt” jdekadt@gmail.com wrote:

Hi all,

Our team is working on setting up a CommCare application for Home Based
HIV testing, and have come up with a technical question we are struggling
with.

For this application, clients are tested at their homes, and we provide
the option for couples to be tested together. In instances when a couple is
tested together, they will always be listed in the same household, even if
they are not both resident there. In cases where a couple is tested
together, we would like to be able to link their records in CommCare in
some way, so that we can be confident of the number of couples tested that
we report, and avoid any overcounting/double-counting.

Ideally, what we would like to do, is when the ‘tested as a couple’
option is selected, provide our staff member with a drop-down list of
names/UIDs of all other individuals registered in the same household. If
household were saved as a case property for all individuals registered in a
household, would it be possible to do this? We’ve been able to get a
dropdown menu of all registered individuals to show up, but we are
not sure how to limit this by individuals in a particular household (or if
this is even possible).

Any suggestions?

Many thanks!
Julia


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


Simon Kelly
Senior Engineer | Dimagi South Africa

Thank you Simon - we will give that a shot!

··· On Mon, Jul 13, 2015 at 10:17 AM, Simon Kelly wrote:

Hi Julia

I got an email regarding your question this morning and my initial thought
was correct that you can just add a filter expression to your casedb query.
With reference to this page on the wiki
https://confluence.dimagi.com/display/commcarepublic/Multiple+Choice+Questions+with+Cases+as+Choices you
would have to add the following to your form XML (by editing the XML
manually):

Where the wiki page shows this line:

You can adjust it to include your case property query as follows:

Assuming that the case property is called ‘household’ and the the name of
the household you are searching against is in the form property
’/data/selected_household’.

Let me know if you have any trouble getting that to work.

Best regards
Simon

On 10 July 2015 at 19:19, Simon Kelly skelly@dimagi.com wrote:

Hi Julia

Have you had any response to this? If not I’ll reach out to a few people
on Monday and see what the solution is.

It is definitely possible to filter the list of cases by case type and by
closed status and I’m pretty sure you can add a filter that will filter by
any other car property as well except that I think the performance on the
phone will probably be poor.

Anyway, I’ll get back to you on Monday with a more concrete answer.

Simon
On 7 Jul 2015 10:06, “Julia de Kadt” jdekadt@gmail.com wrote:

Hi all,

Our team is working on setting up a CommCare application for Home Based
HIV testing, and have come up with a technical question we are struggling
with.

For this application, clients are tested at their homes, and we provide
the option for couples to be tested together. In instances when a couple is
tested together, they will always be listed in the same household, even if
they are not both resident there. In cases where a couple is tested
together, we would like to be able to link their records in CommCare in
some way, so that we can be confident of the number of couples tested that
we report, and avoid any overcounting/double-counting.

Ideally, what we would like to do, is when the ‘tested as a couple’
option is selected, provide our staff member with a drop-down list of
names/UIDs of all other individuals registered in the same household. If
household were saved as a case property for all individuals registered in a
household, would it be possible to do this? We’ve been able to get a
dropdown menu of all registered individuals to show up, but we are
not sure how to limit this by individuals in a particular household (or if
this is even possible).

Any suggestions?

Many thanks!
Julia


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


Simon Kelly
Senior Engineer | Dimagi South Africa


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