Selecting options by importing Excel sheet on CommCare

If you're filtering cases, you want an expression that ultimately returns a set of cases. The first part of the expression, instance('casedb')/casedb/case, gives you all cases on the phone.

The expressions in square brackets then filter the cases by case type, parent (you're limiting to cases that are children of the "current" case, which is the one you selected from the case list), and open/closed.

[@case_type='Indicators']
[index/parent=current()/@case_id]
[@status='open']

The /[contractions_dur = 'low'] is what's throwing the error. The / says to go another level deep, but I suspect what you want is to just add the contractions_dur as a fourth constraint, on the same level as the others. So try dropping the slash: instance('casedb')/casedb/case[@case_type='Indicators'][index/parent=current()/@case_id][@status='open'][contractions_dur = 'low']

The default settings of your project do not let you split mulitselect questions in case exports. This is because your case does not know which questions correspond with which case properties (because it could be multiple questions).

However, we do have a feature preview that you can enable on your project that will allow you to define how you would like to split your case property in a case export.

You can enable this setting by going to https://www.commcarehq.org/a/your_domain/settings/project/previews/ and checking the "Split multi-selects in case export" option. Then hit Update Previews.

When that is enabled you should see an extra column in your export that will allow you to select the Type. Here you select "multiselect." Then you can add your options. Example below: