# Fixtures by filter **URL:** \ **Category:** Users\ **Created:** [July 21, 2015, 6:20am UTC](https://forum.dimagi.com/t/fixtures-by-filter/2332 "2015-07-21T06:20:46Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Htet](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/h/ecae2f/32.png) [@Htet](https://forum.dimagi.com/u/Htet)\ **Post date:** [July 21, 2015, 6:20am UTC](https://forum.dimagi.com/t/fixtures-by-filter/2332/1 "2015-07-21T06:20:46Z")
Dear colleagues, I noticed there is a change in the display of lookup tables in our application. I am curious to know how the function "filter" can help for the lookup tables? Please kindly suggest for this and thanks. Htet ---
**Author:** ![Fiorenzo\_Conte](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/f/7cd45c/32.png) [@Fiorenzo\_Conte](https://forum.dimagi.com/u/Fiorenzo_Conte)\ **Post date:** [July 21, 2015, 6:31am UTC](https://forum.dimagi.com/t/fixtures-by-filter/2332/2 "2015-07-21T06:31:21Z")
Dear Htet, Thanks for the inquiry. This page gives you an example on how to use the filter for lookup tables [https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices](https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) Best, > **···** > > On Tue, Jul 21, 2015 at 9:20 AM, Htet wrote: > > > Dear colleagues, > > > > I noticed there is a change in the display of lookup tables in our > > application. > > I am curious to know how the function "filter" can help for the lookup > > tables? > > Please kindly suggest for this and thanks. > > > > Htet > > > > -- > > 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](mailto:commcare-users+unsubscribe@googlegroups.com). > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > -- > _Fiorenzo Conte_ > Project Manager | Gestionnaire de projet > West Africa | Afrique de l'Ouest > Dimagi, Inc > m Senegal : +221 77 293 91 89 | m Kenya: +254 706 970567 > s : fioreco86 > > > **[Transforming Social Impact: Data Collection Software & Digital Health...](https://www.dimagi.com/)** > > > > Enabling global NGOs with cutting-edge data collection software & digital health solutions. Discover how Dimagi powers impactful frontline work. ---
**Author:** ![Htet](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/h/ecae2f/32.png) [@Htet](https://forum.dimagi.com/u/Htet)\ **Post date:** [July 22, 2015, 1:39pm UTC](https://forum.dimagi.com/t/fixtures-by-filter/2332/3 "2015-07-22T13:39:41Z")
Dear Fiorenzo Conte, In relation to my previous question, I would like to know using lookup tables with multiple languages. I have visited the site which explains about this and would like to ask a few questions. Following the instruction, I can upload the lookup tables with 2 languages. But I need some advice in dealing with the editing of XML. The following is the xml that I copied from that example. In the above example, "state" is used for explanation and if I would like use state, district and township, do I need to add the red color XML for each variable? Since the term "name" is not specific, how can it differentiate name for districts and township? Do we need to change that name into state/district or township? Eg. Please kindly advice for this and thank you so much for your support. Htet > **···** > > On Tuesday, July 21, 2015 at 1:31:23 PM UTC+7, fconte wrote: \> \> Dear Htet, \> \> Thanks for the inquiry. This page gives you an example on how to use the \> filter for lookup tables \> https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices \> \> Best, \> \> On Tue, Jul 21, 2015 at 9:20 AM, Htet \ wrote: \> \>\> Dear colleagues, \>\> \>\> I noticed there is a change in the display of lookup tables in our \>\> application. \>\> I am curious to know how the function "filter" can help for the lookup \>\> tables? \>\> Please kindly suggest for this and thanks. \>\> \>\> Htet \>\> \>\> -- \>\> 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. \>\> \> \> \> \> -- \> \*Fiorenzo Conte\* \> Project Manager | Gestionnaire de projet \> West Africa | Afrique de l'Ouest \> Dimagi, Inc \> m Senegal : +221 77 293 91 89 | m Kenya: +254 706 970567 \> s : fioreco86 \> http://www.dimagi.com/ \> \> \> \> ---
**Author:** ![Htet](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/h/ecae2f/32.png) [@Htet](https://forum.dimagi.com/u/Htet)\ **Post date:** [July 22, 2015, 9:26am UTC](https://forum.dimagi.com/t/fixtures-by-filter/2332/4 "2015-07-22T09:26:56Z")
Dear Fiorenzo Conte, Thank you so much for the suggestions. It helps. Best, Htet > **···** > > On Tue, Jul 21, 2015 at 1:31 PM, Fiorenzo Conte wrote: > > > Dear Htet, > > > > Thanks for the inquiry. This page gives you an example on how to use the > > filter for lookup tables > > [Setup a Question with Filtered Choices - CommCare Public - CommCare Public](https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) > > > > Best, > > > > On Tue, Jul 21, 2015 at 9:20 AM, Htet [kyawhtet@gmail.com](mailto:kyawhtet@gmail.com) wrote: > > > > > Dear colleagues, > > > > > > I noticed there is a change in the display of lookup tables in our > > > application. > > > I am curious to know how the function "filter" can help for the lookup > > > tables? > > > Please kindly suggest for this and thanks. > > > > > > Htet > > > > > > -- > > > 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](mailto:commcare-users+unsubscribe@googlegroups.com). > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > -- > > _Fiorenzo Conte_ > > Project Manager | Gestionnaire de projet > > West Africa | Afrique de l'Ouest > > Dimagi, Inc > > m Senegal : +221 77 293 91 89 | m Kenya: +254 706 970567 > > s : fioreco86 > > [http://www.dimagi.com/](http://www.dimagi.com/) > > > > -- > > 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/1dsTioFWzkI/unsubscribe](https://groups.google.com/d/topic/commcare-users/1dsTioFWzkI/unsubscribe). > > To unsubscribe from this group and all its topics, send an email to > > [commcare-users+unsubscribe@googlegroups.com](mailto:commcare-users+unsubscribe@googlegroups.com). > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Nate](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/n/e95f7d/32.png) [@Nate](https://forum.dimagi.com/u/Nate)\ **Post date:** [July 23, 2015, 5:36pm UTC](https://forum.dimagi.com/t/fixtures-by-filter/2332/5 "2015-07-23T17:36:15Z")
Hi Htet, You might be able to take advantage of the Single Answer Lookup Table question type in order to perform these actions: [https://help.commcarehq.org/display/commcarepublic/Setup+a+Question+with+Filtered+Choices](https://help.commcarehq.org/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) Please let us know if this is helpful or if you require further assistance. Thanks, > **···** > > -- Nate Haduch > > Technical Support Analyst > Dimagi, Inc | 585 Massachusetts Ave | Suite 3 | Cambridge, MA 02139 > > On Wed, Jul 22, 2015 at 9:39 AM, Htet [kyawhtet@gmail.com](mailto:kyawhtet@gmail.com) wrote: > > > Dear Fiorenzo Conte, > > > > In relation to my previous question, I would like to know using lookup > > tables with multiple languages. > > I have visited the site which explains about this and would like to ask a > > few questions. > > Following the instruction, I can upload the lookup tables with 2 > > languages. But I need some advice in dealing with the editing of XML. > > > > The following is the xml that I copied from that example. > > > > In the above example, "state" is used for explanation and if I would like > > use state, district and township, do I need to add the red color XML for > > each variable? Since the term "name" is not specific, how can it > > differentiate name for districts and township? Do we need to change that > > name into state/district or township? Eg. > > > > Please kindly advice for this and thank you so much for your support. > > > > Htet > > > > On Tuesday, July 21, 2015 at 1:31:23 PM UTC+7, fconte wrote: > > > > > Dear Htet, > > > > > > Thanks for the inquiry. This page gives you an example on how to use the > > > filter for lookup tables > > > [Setup a Question with Filtered Choices - CommCare Public - CommCare Public](https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) > > > > > > Best, > > > > > > On Tue, Jul 21, 2015 at 9:20 AM, Htet [kyaw...@gmail.com](mailto:kyaw...@gmail.com) wrote: > > > > > > > Dear colleagues, > > > > > > > > I noticed there is a change in the display of lookup tables in our > > > > application. > > > > I am curious to know how the function "filter" can help for the lookup > > > > tables? > > > > Please kindly suggest for this and thanks. > > > > > > > > Htet > > > > > > > > -- > > > > 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](mailto:commcare-user...@googlegroups.com). > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > > > -- > > > _Fiorenzo Conte_ > > > Project Manager | Gestionnaire de projet > > > West Africa | Afrique de l'Ouest > > > Dimagi, Inc > > > m Senegal : +221 77 293 91 89 | m Kenya: +254 706 970567 > > > s : fioreco86 > > > [http://www.dimagi.com/](http://www.dimagi.com/) > > > > > > -- > > > 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](mailto:commcare-users+unsubscribe@googlegroups.com). > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Sheel\_Shah](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/s/779978/32.png) [@Sheel\_Shah](https://forum.dimagi.com/u/Sheel_Shah)\ **Post date:** [July 23, 2015, 5:44pm UTC](https://forum.dimagi.com/t/fixtures-by-filter/2332/6 "2015-07-23T17:44:05Z")
Hi Htet, For your specific question, whether you're referring to the list of districts or states is controlled in the line above the one that is highlighted in red. Using the new lookup table question type would definitely make this easier: - Add a lookup table question type - Choose your table (i.e. states or districts) - Set the value to the column in the table that you want to store - Set the label to the column in the table you want to display (ex. _name)_. However, you will need to update the label field so that its \*name[@lang = jr:itext('lang-code-label')] \*You can replace _name_ with whatever column in your chosen table you want to display. - You'll still be required to add a question that contains all your language codes (per the documentation here [Using Lookup Tables with Multiple Languages - CommCare Public - CommCare Public](https://confluence.dimagi.com/display/commcarepublic/Using+Lookup+Tables+with+Multiple+Languages) ). I'm going to update the documentation to be a bit clearer and will let you know when its complete. Thanks, Sheel > **···** > > On Thu, Jul 23, 2015 at 1:36 PM, Nate Haduch wrote: > > > Hi Htet, > > > > You might be able to take advantage of the Single Answer Lookup Table > > question type in order to perform these actions: > > [Setup a Question with Filtered Choices - CommCare Public - CommCare Public](https://help.commcarehq.org/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) > > > > Please let us know if this is helpful or if you require further assistance. > > > > Thanks, > > > > -- > > Nate Haduch > > > > Technical Support Analyst > > Dimagi, Inc | 585 Massachusetts Ave | Suite 3 | Cambridge, MA 02139 > > > > On Wed, Jul 22, 2015 at 9:39 AM, Htet [kyawhtet@gmail.com](mailto:kyawhtet@gmail.com) wrote: > > > > > Dear Fiorenzo Conte, > > > > > > In relation to my previous question, I would like to know using lookup > > > tables with multiple languages. > > > I have visited the site which explains about this and would like to ask a > > > few questions. > > > Following the instruction, I can upload the lookup tables with 2 > > > languages. But I need some advice in dealing with the editing of XML. > > > > > > The following is the xml that I copied from that example. > > > > > > In the above example, "state" is used for explanation and if I would like > > > use state, district and township, do I need to add the red color XML for > > > each variable? Since the term "name" is not specific, how can it > > > differentiate name for districts and township? Do we need to change that > > > name into state/district or township? Eg. > > > > > > Please kindly advice for this and thank you so much for your support. > > > > > > Htet > > > > > > On Tuesday, July 21, 2015 at 1:31:23 PM UTC+7, fconte wrote: > > > > > > > Dear Htet, > > > > > > > > Thanks for the inquiry. This page gives you an example on how to use the > > > > filter for lookup tables > > > > [Setup a Question with Filtered Choices - CommCare Public - CommCare Public](https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) > > > > > > > > Best, > > > > > > > > On Tue, Jul 21, 2015 at 9:20 AM, Htet [kyaw...@gmail.com](mailto:kyaw...@gmail.com) wrote: > > > > > > > > > Dear colleagues, > > > > > > > > > > I noticed there is a change in the display of lookup tables in our > > > > > application. > > > > > I am curious to know how the function "filter" can help for the lookup > > > > > tables? > > > > > Please kindly suggest for this and thanks. > > > > > > > > > > Htet > > > > > > > > > > -- > > > > > 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](mailto:commcare-user...@googlegroups.com). > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > > > > > -- > > > > _Fiorenzo Conte_ > > > > Project Manager | Gestionnaire de projet > > > > West Africa | Afrique de l'Ouest > > > > Dimagi, Inc > > > > m Senegal : +221 77 293 91 89 | m Kenya: +254 706 970567 > > > > s : fioreco86 > > > > [http://www.dimagi.com/](http://www.dimagi.com/) > > > > > > > > -- > > > > 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](mailto:commcare-users+unsubscribe@googlegroups.com). > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > -- > > 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](mailto:commcare-users+unsubscribe@googlegroups.com). > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > -- > Sheel Shah > Project Manager | Dimagi > m: +1.781.428.5419 | skype: sheel\_shah ---
**Author:** ![Htet](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/h/ecae2f/32.png) [@Htet](https://forum.dimagi.com/u/Htet)\ **Post date:** [July 26, 2015, 3:30pm UTC](https://forum.dimagi.com/t/fixtures-by-filter/2332/7 "2015-07-26T15:30:16Z")
Dear Nate, Thank you for your mail. That link is really helpful and I can follow it well. Best wishes, Htet > **···** > > On Fri, Jul 24, 2015 at 12:36 AM, Nate Haduch wrote: > > > Hi Htet, > > > > You might be able to take advantage of the Single Answer Lookup Table > > question type in order to perform these actions: > > [Setup a Question with Filtered Choices - CommCare Public - CommCare Public](https://help.commcarehq.org/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) > > > > Please let us know if this is helpful or if you require further assistance. > > > > Thanks, > > > > -- > > Nate Haduch > > > > Technical Support Analyst > > Dimagi, Inc | 585 Massachusetts Ave | Suite 3 | Cambridge, MA 02139 > > > > On Wed, Jul 22, 2015 at 9:39 AM, Htet [kyawhtet@gmail.com](mailto:kyawhtet@gmail.com) wrote: > > > > > Dear Fiorenzo Conte, > > > > > > In relation to my previous question, I would like to know using lookup > > > tables with multiple languages. > > > I have visited the site which explains about this and would like to ask a > > > few questions. > > > Following the instruction, I can upload the lookup tables with 2 > > > languages. But I need some advice in dealing with the editing of XML. > > > > > > The following is the xml that I copied from that example. > > > > > > In the above example, "state" is used for explanation and if I would like > > > use state, district and township, do I need to add the red color XML for > > > each variable? Since the term "name" is not specific, how can it > > > differentiate name for districts and township? Do we need to change that > > > name into state/district or township? Eg. > > > > > > Please kindly advice for this and thank you so much for your support. > > > > > > Htet > > > > > > On Tuesday, July 21, 2015 at 1:31:23 PM UTC+7, fconte wrote: > > > > > > > Dear Htet, > > > > > > > > Thanks for the inquiry. This page gives you an example on how to use the > > > > filter for lookup tables > > > > [Setup a Question with Filtered Choices - CommCare Public - CommCare Public](https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) > > > > > > > > Best, > > > > > > > > On Tue, Jul 21, 2015 at 9:20 AM, Htet [kyaw...@gmail.com](mailto:kyaw...@gmail.com) wrote: > > > > > > > > > Dear colleagues, > > > > > > > > > > I noticed there is a change in the display of lookup tables in our > > > > > application. > > > > > I am curious to know how the function "filter" can help for the lookup > > > > > tables? > > > > > Please kindly suggest for this and thanks. > > > > > > > > > > Htet > > > > > > > > > > -- > > > > > 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](mailto:commcare-user...@googlegroups.com). > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > > > > > -- > > > > _Fiorenzo Conte_ > > > > Project Manager | Gestionnaire de projet > > > > West Africa | Afrique de l'Ouest > > > > Dimagi, Inc > > > > m Senegal : +221 77 293 91 89 | m Kenya: +254 706 970567 > > > > s : fioreco86 > > > > [http://www.dimagi.com/](http://www.dimagi.com/) > > > > > > > > -- > > > > 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](mailto:commcare-users+unsubscribe@googlegroups.com). > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > -- > > 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/1dsTioFWzkI/unsubscribe](https://groups.google.com/d/topic/commcare-users/1dsTioFWzkI/unsubscribe). > > To unsubscribe from this group and all its topics, send an email to > > [commcare-users+unsubscribe@googlegroups.com](mailto:commcare-users+unsubscribe@googlegroups.com). > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Htet](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/h/ecae2f/32.png) [@Htet](https://forum.dimagi.com/u/Htet)\ **Post date:** [July 26, 2015, 6:53pm UTC](https://forum.dimagi.com/t/fixtures-by-filter/2332/8 "2015-07-26T18:53:12Z")
Dear Sheel, Thank you for your explanation and it is very helpful. I look forward to your update version of the explanation. Many thanks, Htet > **···** > > On Fri, Jul 24, 2015 at 12:44 AM, Sheel Shah wrote: > > > Hi Htet, > > > > For your specific question, whether you're referring to the list of > > districts or states is controlled in the line above > > the one that is highlighted in red. > > > > Using the new lookup table question type would definitely make this easier: > > > > - Add a lookup table question type > > - Choose your table (i.e. states or districts) > > - Set the value to the column in the table that you want to store > > - Set the label to the column in the table you want to display (ex. > > _name)_. However, you will need to update the label field so that its \*name[@lang > > = jr:itext('lang-code-label')] \*You can replace _name_ with whatever > > column in your chosen table you want to display. > > - You'll still be required to add a question that contains all your > > language codes (per the documentation here > > [Using Lookup Tables with Multiple Languages - CommCare Public - CommCare Public](https://confluence.dimagi.com/display/commcarepublic/Using+Lookup+Tables+with+Multiple+Languages) > > ). > > > > I'm going to update the documentation to be a bit clearer and will let you > > know when its complete. > > > > Thanks, > > Sheel > > > > On Thu, Jul 23, 2015 at 1:36 PM, Nate Haduch [nhaduch@dimagi.com](mailto:nhaduch@dimagi.com) wrote: > > > > > Hi Htet, > > > > > > You might be able to take advantage of the Single Answer Lookup Table > > > question type in order to perform these actions: > > > [Setup a Question with Filtered Choices - CommCare Public - CommCare Public](https://help.commcarehq.org/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) > > > > > > Please let us know if this is helpful or if you require further > > > assistance. > > > > > > Thanks, > > > > > > -- > > > Nate Haduch > > > > > > Technical Support Analyst > > > Dimagi, Inc | 585 Massachusetts Ave | Suite 3 | Cambridge, MA 02139 > > > > > > On Wed, Jul 22, 2015 at 9:39 AM, Htet [kyawhtet@gmail.com](mailto:kyawhtet@gmail.com) wrote: > > > > > > > Dear Fiorenzo Conte, > > > > > > > > In relation to my previous question, I would like to know using lookup > > > > tables with multiple languages. > > > > I have visited the site which explains about this and would like to ask > > > > a few questions. > > > > Following the instruction, I can upload the lookup tables with 2 > > > > languages. But I need some advice in dealing with the editing of XML. > > > > > > > > The following is the xml that I copied from that example. > > > > > > > > In the above example, "state" is used for explanation and if I would > > > > like use state, district and township, do I need to add the red color XML > > > > for each variable? Since the term "name" is not specific, how can it > > > > differentiate name for districts and township? Do we need to change that > > > > name into state/district or township? Eg. > > > > > > > > Please kindly advice for this and thank you so much for your support. > > > > > > > > Htet > > > > > > > > On Tuesday, July 21, 2015 at 1:31:23 PM UTC+7, fconte wrote: > > > > > > > > > Dear Htet, > > > > > > > > > > Thanks for the inquiry. This page gives you an example on how to use > > > > > the filter for lookup tables > > > > > [Setup a Question with Filtered Choices - CommCare Public - CommCare Public](https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) > > > > > > > > > > Best, > > > > > > > > > > On Tue, Jul 21, 2015 at 9:20 AM, Htet [kyaw...@gmail.com](mailto:kyaw...@gmail.com) wrote: > > > > > > > > > > > Dear colleagues, > > > > > > > > > > > > I noticed there is a change in the display of lookup tables in our > > > > > > application. > > > > > > I am curious to know how the function "filter" can help for the lookup > > > > > > tables? > > > > > > Please kindly suggest for this and thanks. > > > > > > > > > > > > Htet > > > > > > > > > > > > -- > > > > > > 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](mailto:commcare-user...@googlegroups.com). > > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > > > > > > > -- > > > > > _Fiorenzo Conte_ > > > > > Project Manager | Gestionnaire de projet > > > > > West Africa | Afrique de l'Ouest > > > > > Dimagi, Inc > > > > > m Senegal : +221 77 293 91 89 | m Kenya: +254 706 970567 > > > > > s : fioreco86 > > > > > [http://www.dimagi.com/](http://www.dimagi.com/) > > > > > > > > > > -- > > > > > 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](mailto:commcare-users+unsubscribe@googlegroups.com). > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > > > -- > > > 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](mailto:commcare-users+unsubscribe@googlegroups.com). > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > -- > > Sheel Shah > > Project Manager | Dimagi > > m: +1.781.428.5419 | skype: sheel\_shah > > > > -- > > 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/1dsTioFWzkI/unsubscribe](https://groups.google.com/d/topic/commcare-users/1dsTioFWzkI/unsubscribe). > > To unsubscribe from this group and all its topics, send an email to > > [commcare-users+unsubscribe@googlegroups.com](mailto:commcare-users+unsubscribe@googlegroups.com). > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Sheel\_Shah](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/s/779978/32.png) [@Sheel\_Shah](https://forum.dimagi.com/u/Sheel_Shah)\ **Post date:** [July 29, 2015, 7:40pm UTC](https://forum.dimagi.com/t/fixtures-by-filter/2332/9 "2015-07-29T19:40:27Z")
Hi Htet, I've updated the documentation - please let me know if you have any other questions! [https://confluence.dimagi.com/display/commcarepublic/Using+Lookup+Tables+with+Multiple+Languages](https://confluence.dimagi.com/display/commcarepublic/Using+Lookup+Tables+with+Multiple+Languages) Thanks, Sheel > **···** > > On Sun, Jul 26, 2015 at 2:53 PM, Kyaw Htet wrote: > > > Dear Sheel, > > > > Thank you for your explanation and it is very helpful. > > I look forward to your update version of the explanation. > > > > Many thanks, > > Htet > > > > On Fri, Jul 24, 2015 at 12:44 AM, Sheel Shah [sshah@dimagi.com](mailto:sshah@dimagi.com) wrote: > > > > > Hi Htet, > > > > > > For your specific question, whether you're referring to the list of > > > districts or states is controlled in the line above > > > the one that is highlighted in red. > > > > > > Using the new lookup table question type would definitely make this > > > easier: > > > > > > - Add a lookup table question type > > > - Choose your table (i.e. states or districts) > > > - Set the value to the column in the table that you want to store > > > - Set the label to the column in the table you want to display (ex. > > > _name)_. However, you will need to update the label field so that > > > its \*name[@lang = jr:itext('lang-code-label')] \*You can replace > > > _name_ with whatever column in your chosen table you want to display. > > > - You'll still be required to add a question that contains all your > > > language codes (per the documentation here > > > [Using Lookup Tables with Multiple Languages - CommCare Public - CommCare Public](https://confluence.dimagi.com/display/commcarepublic/Using+Lookup+Tables+with+Multiple+Languages) > > > ). > > > > > > I'm going to update the documentation to be a bit clearer and will let > > > you know when its complete. > > > > > > Thanks, > > > Sheel > > > > > > On Thu, Jul 23, 2015 at 1:36 PM, Nate Haduch [nhaduch@dimagi.com](mailto:nhaduch@dimagi.com) wrote: > > > > > > > Hi Htet, > > > > > > > > You might be able to take advantage of the Single Answer Lookup Table > > > > question type in order to perform these actions: > > > > [Setup a Question with Filtered Choices - CommCare Public - CommCare Public](https://help.commcarehq.org/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) > > > > > > > > Please let us know if this is helpful or if you require further > > > > assistance. > > > > > > > > Thanks, > > > > > > > > -- > > > > Nate Haduch > > > > > > > > Technical Support Analyst > > > > Dimagi, Inc | 585 Massachusetts Ave | Suite 3 | Cambridge, MA 02139 > > > > > > > > On Wed, Jul 22, 2015 at 9:39 AM, Htet [kyawhtet@gmail.com](mailto:kyawhtet@gmail.com) wrote: > > > > > > > > > Dear Fiorenzo Conte, > > > > > > > > > > In relation to my previous question, I would like to know using lookup > > > > > tables with multiple languages. > > > > > I have visited the site which explains about this and would like to ask > > > > > a few questions. > > > > > Following the instruction, I can upload the lookup tables with 2 > > > > > languages. But I need some advice in dealing with the editing of XML. > > > > > > > > > > The following is the xml that I copied from that example. > > > > > > > > > > In the above example, "state" is used for explanation and if I would > > > > > like use state, district and township, do I need to add the red color XML > > > > > for each variable? Since the term "name" is not specific, how can it > > > > > differentiate name for districts and township? Do we need to change that > > > > > name into state/district or township? Eg. > > > > > > > > > > Please kindly advice for this and thank you so much for your support. > > > > > > > > > > Htet > > > > > > > > > > On Tuesday, July 21, 2015 at 1:31:23 PM UTC+7, fconte wrote: > > > > > > > > > > > Dear Htet, > > > > > > > > > > > > Thanks for the inquiry. This page gives you an example on how to use > > > > > > the filter for lookup tables > > > > > > [Setup a Question with Filtered Choices - CommCare Public - CommCare Public](https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) > > > > > > > > > > > > Best, > > > > > > > > > > > > On Tue, Jul 21, 2015 at 9:20 AM, Htet [kyaw...@gmail.com](mailto:kyaw...@gmail.com) wrote: > > > > > > > > > > > > > Dear colleagues, > > > > > > > > > > > > > > I noticed there is a change in the display of lookup tables in our > > > > > > > application. > > > > > > > I am curious to know how the function "filter" can help for the > > > > > > > lookup tables? > > > > > > > Please kindly suggest for this and thanks. > > > > > > > > > > > > > > Htet > > > > > > > > > > > > > > -- > > > > > > > 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](mailto:commcare-user...@googlegroups.com). > > > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > > > > > > > > > -- > > > > > > _Fiorenzo Conte_ > > > > > > Project Manager | Gestionnaire de projet > > > > > > West Africa | Afrique de l'Ouest > > > > > > Dimagi, Inc > > > > > > m Senegal : +221 77 293 91 89 | m Kenya: +254 706 970567 > > > > > > s : fioreco86 > > > > > > [http://www.dimagi.com/](http://www.dimagi.com/) > > > > > > > > > > > > -- > > > > > > 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](mailto:commcare-users+unsubscribe@googlegroups.com). > > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > > > > > -- > > > > 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](mailto:commcare-users+unsubscribe@googlegroups.com). > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > > > -- > > > Sheel Shah > > > Project Manager | Dimagi > > > m: +1.781.428.5419 | skype: sheel\_shah > > > > > > -- > > > 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/1dsTioFWzkI/unsubscribe](https://groups.google.com/d/topic/commcare-users/1dsTioFWzkI/unsubscribe). > > > To unsubscribe from this group and all its topics, send an email to > > > [commcare-users+unsubscribe@googlegroups.com](mailto:commcare-users+unsubscribe@googlegroups.com). > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > -- > > 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](mailto:commcare-users+unsubscribe@googlegroups.com). > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > -- > Sheel Shah > Project Manager | Dimagi > m: +1.781.428.5419 | skype: sheel\_shah ---
**Author:** ![Htet](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/h/ecae2f/32.png) [@Htet](https://forum.dimagi.com/u/Htet)\ **Post date:** [August 10, 2015, 7:51am UTC](https://forum.dimagi.com/t/fixtures-by-filter/2332/10 "2015-08-10T07:51:41Z")
Dear Sheel, Many thanks for your help. It seems according to the update, we can set the label as "\*name[@lang = jr:itext('lang-code-label')]" \*and don't need to edit in the xml. Will get back to you if I have further questions. Best wishes, Htet > **···** > > On Thu, Jul 30, 2015 at 2:40 AM, Sheel Shah wrote: > > > Hi Htet, > > > > I've updated the documentation - please let me know if you have any other > > questions! > > > > [Using Lookup Tables with Multiple Languages - CommCare Public - CommCare Public](https://confluence.dimagi.com/display/commcarepublic/Using+Lookup+Tables+with+Multiple+Languages) > > > > Thanks, > > Sheel > > > > On Sun, Jul 26, 2015 at 2:53 PM, Kyaw Htet [kyawhtet@gmail.com](mailto:kyawhtet@gmail.com) wrote: > > > > > Dear Sheel, > > > > > > Thank you for your explanation and it is very helpful. > > > I look forward to your update version of the explanation. > > > > > > Many thanks, > > > Htet > > > > > > On Fri, Jul 24, 2015 at 12:44 AM, Sheel Shah [sshah@dimagi.com](mailto:sshah@dimagi.com) wrote: > > > > > > > Hi Htet, > > > > > > > > For your specific question, whether you're referring to the list of > > > > districts or states is controlled in the line above > > > > the one that is highlighted in red. > > > > > > > > Using the new lookup table question type would definitely make this > > > > easier: > > > > > > > > - Add a lookup table question type > > > > - Choose your table (i.e. states or districts) > > > > - Set the value to the column in the table that you want to store > > > > - Set the label to the column in the table you want to display (ex. > > > > _name)_. However, you will need to update the label field so that > > > > its \*name[@lang = jr:itext('lang-code-label')] \*You can replace > > > > _name_ with whatever column in your chosen table you want to display. > > > > - You'll still be required to add a question that contains all your > > > > language codes (per the documentation here > > > > [Using Lookup Tables with Multiple Languages - CommCare Public - CommCare Public](https://confluence.dimagi.com/display/commcarepublic/Using+Lookup+Tables+with+Multiple+Languages) > > > > ). > > > > > > > > I'm going to update the documentation to be a bit clearer and will let > > > > you know when its complete. > > > > > > > > Thanks, > > > > Sheel > > > > > > > > On Thu, Jul 23, 2015 at 1:36 PM, Nate Haduch [nhaduch@dimagi.com](mailto:nhaduch@dimagi.com) wrote: > > > > > > > > > Hi Htet, > > > > > > > > > > You might be able to take advantage of the Single Answer Lookup Table > > > > > question type in order to perform these actions: > > > > > [Setup a Question with Filtered Choices - CommCare Public - CommCare Public](https://help.commcarehq.org/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) > > > > > > > > > > Please let us know if this is helpful or if you require further > > > > > assistance. > > > > > > > > > > Thanks, > > > > > > > > > > -- > > > > > Nate Haduch > > > > > > > > > > Technical Support Analyst > > > > > Dimagi, Inc | 585 Massachusetts Ave | Suite 3 | Cambridge, MA 02139 > > > > > > > > > > On Wed, Jul 22, 2015 at 9:39 AM, Htet [kyawhtet@gmail.com](mailto:kyawhtet@gmail.com) wrote: > > > > > > > > > > > Dear Fiorenzo Conte, > > > > > > > > > > > > In relation to my previous question, I would like to know using lookup > > > > > > tables with multiple languages. > > > > > > I have visited the site which explains about this and would like to > > > > > > ask a few questions. > > > > > > Following the instruction, I can upload the lookup tables with 2 > > > > > > languages. But I need some advice in dealing with the editing of XML. > > > > > > > > > > > > The following is the xml that I copied from that example. > > > > > > > > > > > > In the above example, "state" is used for explanation and if I would > > > > > > like use state, district and township, do I need to add the red color XML > > > > > > for each variable? Since the term "name" is not specific, how can it > > > > > > differentiate name for districts and township? Do we need to change that > > > > > > name into state/district or township? Eg. > > > > > > > > > > > > Please kindly advice for this and thank you so much for your support. > > > > > > > > > > > > Htet > > > > > > > > > > > > On Tuesday, July 21, 2015 at 1:31:23 PM UTC+7, fconte wrote: > > > > > > > > > > > > > Dear Htet, > > > > > > > > > > > > > > Thanks for the inquiry. This page gives you an example on how to use > > > > > > > the filter for lookup tables > > > > > > > [Setup a Question with Filtered Choices - CommCare Public - CommCare Public](https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices) > > > > > > > > > > > > > > Best, > > > > > > > > > > > > > > On Tue, Jul 21, 2015 at 9:20 AM, Htet [kyaw...@gmail.com](mailto:kyaw...@gmail.com) wrote: > > > > > > > > > > > > > > > Dear colleagues, > > > > > > > > > > > > > > > > I noticed there is a change in the display of lookup tables in our > > > > > > > > application. > > > > > > > > I am curious to know how the function "filter" can help for the > > > > > > > > lookup tables? > > > > > > > > Please kindly suggest for this and thanks. > > > > > > > > > > > > > > > > Htet > > > > > > > > > > > > > > > > -- > > > > > > > > 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](mailto:commcare-user...@googlegroups.com). > > > > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > > > > > > > > > > > -- > > > > > > > _Fiorenzo Conte_ > > > > > > > Project Manager | Gestionnaire de projet > > > > > > > West Africa | Afrique de l'Ouest > > > > > > > Dimagi, Inc > > > > > > > m Senegal : +221 77 293 91 89 | m Kenya: +254 706 970567 > > > > > > > s : fioreco86 > > > > > > > [http://www.dimagi.com/](http://www.dimagi.com/) > > > > > > > > > > > > > > -- > > > > > > > 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](mailto:commcare-users+unsubscribe@googlegroups.com). > > > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > > > > > > > -- > > > > > 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](mailto:commcare-users+unsubscribe@googlegroups.com). > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > > > > > -- > > > > Sheel Shah > > > > Project Manager | Dimagi > > > > m: +1.781.428.5419 | skype: sheel\_shah > > > > > > > > -- > > > > 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/1dsTioFWzkI/unsubscribe](https://groups.google.com/d/topic/commcare-users/1dsTioFWzkI/unsubscribe) > > > > . > > > > To unsubscribe from this group and all its topics, send an email to > > > > [commcare-users+unsubscribe@googlegroups.com](mailto:commcare-users+unsubscribe@googlegroups.com). > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > > > -- > > > 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](mailto:commcare-users+unsubscribe@googlegroups.com). > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > -- > > Sheel Shah > > Project Manager | Dimagi > > m: +1.781.428.5419 | skype: sheel\_shah > > > > -- > > 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/1dsTioFWzkI/unsubscribe](https://groups.google.com/d/topic/commcare-users/1dsTioFWzkI/unsubscribe). > > To unsubscribe from this group and all its topics, send an email to > > [commcare-users+unsubscribe@googlegroups.com](mailto:commcare-users+unsubscribe@googlegroups.com). > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).