Is it possible to reference a lookup table in a case list calculation in CommCare?
I think I know the syntax that I would need to use, but CommCare doesn't have access to the right instance at that point. Is there a way I can access that instance?
CommCare – Lookup Tables in Case List Calculation
commcare
Related Topic
- How to discover which users have access to which Lookup Tables
- List the parent_name of a child case in the child case module case list
- Display the owner of a case in the case list
- Way to reference a list of mobile workers as possible choices for a multichoice questions in CommCare
- CommCare – Syntax for Referencing User Case Properties
- Is it possible to populate a Multiple Choice Lookup Table question from a case property holding a space-separated list in CommCare
- Conditional Display in CommCare – How to Show Questions Based on Lookup Table Answers
Best Answer
My understanding was that if you reference a fixture inside a calculate using
instance('item-list:my_table')/my_table_list/my_table(wheremy_tableis the name of your lookup table), that instance will be detected and included automatically. If that doesn't work would you mind editing your question to include the expression you're using?EDIT: I had originally said to include
instance('item-list')which was incorrect. The above should allow the app to build, and ifmy_tableexists and is assigned to the user then it should work correctly.