Filtering look-up tables

Dear colleagues,

I am contacting you because of a lookup table issue. In one of my forms, I
implemented three lookup tables to define the region, the district and then
the ward. That worked fine (they appeared correctly on the mobile app).
But then, I tried to filter results in tables according to the answer to
the previous question. I followed closely the CommCare tutorial (
https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices)
but for some reason it doesn’t work. When we try it on our phone, the
lookup tables with a filter condition don’t appear at all, so it is clearly
linked to the filtering condition.

It’s difficult to explain clearly by email, but here goes (I’ll leave out
the 3rd table, it’s the same problem):
I have a first “regions” table, with the fields “id” and “region"
The second “districts” table has the fields “id”, “district” and
"regions_id”.

In the Question Tree, I was in the District Question and I wanted to filter
according to the answer to the Region Question above. I cliked on the
Lookup table below the “district” question. I went to Filter > Edit.
Then in the Expression Editor, I have :
Result is: "True when ALL of the expression are true"
Expression: “regions_id” is equal to -> and I dragged the Region Question
in it.

This is exactly what I read on the tutorial, I did it several times and so
did my colleagues, without any success. I’m sure we are missing on
something but I can’t understand what.

Do you have an idea on what might be blocking us?

Thank you a lot!

Hi Celine,

It sounds like you are looking at the right documentation, and everything
you described sounds right! There may be something subtle going on with
your form, or potentially a bug. If you go ahead and "Report an Issue"
using the button at the bottom of the page on CommCareHQ, someone from our
support team will look into the problem.

Thanks,
Amelia

··· On Mon, Nov 16, 2015 at 3:48 AM, Céline Gross wrote:

Dear colleagues,

I am contacting you because of a lookup table issue. In one of my forms, I
implemented three lookup tables to define the region, the district and then
the ward. That worked fine (they appeared correctly on the mobile app).
But then, I tried to filter results in tables according to the answer to
the previous question. I followed closely the CommCare tutorial (
https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices)
but for some reason it doesn’t work. When we try it on our phone, the
lookup tables with a filter condition don’t appear at all, so it is clearly
linked to the filtering condition.

It’s difficult to explain clearly by email, but here goes (I’ll leave out
the 3rd table, it’s the same problem):
I have a first “regions” table, with the fields “id” and “region"
The second “districts” table has the fields “id”, “district” and
"regions_id”.

In the Question Tree, I was in the District Question and I wanted to
filter according to the answer to the Region Question above. I cliked on
the Lookup table below the “district” question. I went to Filter > Edit.
Then in the Expression Editor, I have :
Result is: "True when ALL of the expression are true"
Expression: “regions_id” is equal to -> and I dragged the Region Question
in it.

This is exactly what I read on the tutorial, I did it several times and so
did my colleagues, without any success. I’m sure we are missing on
something but I can’t understand what.

Do you have an idea on what might be blocking us?

Thank you a lot!


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.

I am having the exact same problem. Were you able to figure it out?

··· On Monday, November 16, 2015 at 10:48:55 AM UTC+2, Céline Gross wrote: > > Dear colleagues, > > I am contacting you because of a lookup table issue. In one of my forms, I > implemented three lookup tables to define the region, the district and then > the ward. That worked fine (they appeared correctly on the mobile app). > But then, I tried to filter results in tables according to the answer to > the previous question. I followed closely the CommCare tutorial ( > https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) > but for some reason it doesn't work. When we try it on our phone, the > lookup tables with a filter condition don't appear at all, so it is clearly > linked to the filtering condition. > > It's difficult to explain clearly by email, but here goes (I'll leave out > the 3rd table, it's the same problem): > I have a first "regions" table, with the fields "id" and "region" > The second "districts" table has the fields "id", "district" and > "regions_id". > > In the Question Tree, I was in the District Question and I wanted to > filter according to the answer to the Region Question above. I cliked on > the Lookup table below the "district" question. I went to Filter > Edit. > Then in the Expression Editor, I have : > Result is: "True when ALL of the expression are true" > Expression: "regions_id" is equal to -> and I dragged the Region Question > in it. > > This is exactly what I read on the tutorial, I did it several times and so > did my colleagues, without any success. I'm sure we are missing on > something but I can't understand what. > > Do you have an idea on what might be blocking us? > > Thank you a lot! >

Thanks Amelia, I’ll do this right away!

··· On Monday, November 16, 2015 at 8:02:56 PM UTC+3, Amelia Sagoff wrote: > > Hi Celine, > > It sounds like you are looking at the right documentation, and everything > you described sounds right! There may be something subtle going on with > your form, or potentially a bug. If you go ahead and "Report an Issue" > using the button at the bottom of the page on CommCareHQ, someone from our > support team will look into the problem. > > Thanks, > Amelia > > On Mon, Nov 16, 2015 at 3:48 AM, Céline Gross <celine....@gmail.com > wrote: > >> Dear colleagues, >> >> I am contacting you because of a lookup table issue. In one of my forms, >> I implemented three lookup tables to define the region, the district and >> then the ward. That worked fine (they appeared correctly on the mobile app). >> But then, I tried to filter results in tables according to the answer to >> the previous question. I followed closely the CommCare tutorial ( >> https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) >> but for some reason it doesn't work. When we try it on our phone, the >> lookup tables with a filter condition don't appear at all, so it is clearly >> linked to the filtering condition. >> >> It's difficult to explain clearly by email, but here goes (I'll leave out >> the 3rd table, it's the same problem): >> I have a first "regions" table, with the fields "id" and "region" >> The second "districts" table has the fields "id", "district" and >> "regions_id". >> >> In the Question Tree, I was in the District Question and I wanted to >> filter according to the answer to the Region Question above. I cliked on >> the Lookup table below the "district" question. I went to Filter > Edit. >> Then in the Expression Editor, I have : >> Result is: "True when ALL of the expression are true" >> Expression: "regions_id" is equal to -> and I dragged the Region Question >> in it. >> >> This is exactly what I read on the tutorial, I did it several times and >> so did my colleagues, without any success. I'm sure we are missing on >> something but I can't understand what. >> >> Do you have an idea on what might be blocking us? >> >> Thank you a lot! >> >> -- >> 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-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >

Hi Amanda,

The bug reported above should have been fixed in a subsequent CommCare
version (2.25) - could you make sure you’re running the latest version of
CommCare and update if not? If the issue persists on the latest version,
please report a bug
https://confluence.dimagi.com/display/commcarepublic/Bug+Reports and we
can take a closer look at your application.

Cheers,
Will

··· On Fri, Sep 30, 2016 at 2:25 AM, Amanda Berman wrote:

I am having the exact same problem. Were you able to figure it out?

On Monday, November 16, 2015 at 10:48:55 AM UTC+2, Céline Gross wrote:

Dear colleagues,

I am contacting you because of a lookup table issue. In one of my forms,
I implemented three lookup tables to define the region, the district and
then the ward. That worked fine (they appeared correctly on the mobile app).
But then, I tried to filter results in tables according to the answer to
the previous question. I followed closely the CommCare tutorial (
https://confluence.dimagi.com/display/commcarepublic/Setup+
a+Question+with+Filtered+Choices) but for some reason it doesn’t work.
When we try it on our phone, the lookup tables with a filter condition
don’t appear at all, so it is clearly linked to the filtering condition.

It’s difficult to explain clearly by email, but here goes (I’ll leave out
the 3rd table, it’s the same problem):
I have a first “regions” table, with the fields “id” and “region"
The second “districts” table has the fields “id”, “district” and
"regions_id”.

In the Question Tree, I was in the District Question and I wanted to
filter according to the answer to the Region Question above. I cliked on
the Lookup table below the “district” question. I went to Filter > Edit.
Then in the Expression Editor, I have :
Result is: "True when ALL of the expression are true"
Expression: “regions_id” is equal to -> and I dragged the Region Question
in it.

This is exactly what I read on the tutorial, I did it several times and
so did my colleagues, without any success. I’m sure we are missing on
something but I can’t understand what.

Do you have an idea on what might be blocking us?

Thank you a lot!


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.