Displaying location name from organizations lookup table in case list/case detalis

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.

Assuming your question is named /data/location_id_result, you can reference the name of the location selected with the expression

instance('locations')/locations/location[@id = /data/location_id_result]/name

and load that into a hidden value which you then save to the case.