My application has a parent case with 3 child cases. Locations own cases, but sometimes the location only owns the parent case and one child case. How can I filter the parent menu so that no parent cases appear if the location doesn't own this parent case (i.e. the location owns a different child case)?
How to filter a case list to display only cases that the mobile user’s location owns
commcare
Related Solutions
For this, you can leave the Case Management tab as "does not use cases." This controls the cases of the case type you've selected in your module.
The User Case will automatically be loaded into your form when you choose a form that has User Case setup.
The export tool can't export users, groups or organisations (locations) but you could use a mapping table to lookup the location or supervisor info based on the user_id.
You could do this by adding a Mappings sheet to your export query that contains the lookup table.
Here is an example of what your query sheet might look like:
We've defined two fields, Location and Supervisor which both reference user_id. We've also added a Mappings sheet as follows:
For each user_id value we have mapped them to the Location and the Supervisor.
When the export is run it will do the lookups the final export will contain the mapped values.
To get the data for the Mappings sheet you can use the user export and organisations (locations) export from CommCare HQ.
Related Topic
- CommCare – Instance Syntax to Search for All Child Cases of a Parent
- Do CommCare Auto Case Closure case property filters overrule the Case Close field (days since updated)
- Viewing supply point cases at a supervisory level
- 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
- CommCare – Configure Case List to Autoselect Child Case in Advanced Modules
- Can users see all of the same cases when assigned to the same location in CommCare
- How to get the reference ID of an extension case during a case export
Best Answer
I was able to get this to work by filtering the parent menu with the following filter:
This filter only shows cases when the case's location owner_id is equal to the current mobile user's location ID.