While doing a case export in CommCare, is the date filter used to filter cases modified between that date range, or are cases filtered by those that were opened in that date range?
CommCare – Date Filter for Case Export: Last Modified Date vs Opened Date
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 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:
Related Topic
- Can the CommCare Export Tool export mobile worker or location information
- Do CommCare Auto Case Closure case property filters overrule the Case Close field (days since updated)
- Missing forms from Submit History report in CommCare when the filter is set to “today”
- What are the options for getting around the 100,000 maximum row limit for case export
- CommCare – How to Reference Mobile Worker’s Username in Case List Filter
- How to get the reference ID of an extension case during a case export
- Archived forms and the export tool
Best Answer
The date filter in the case export is based on modified date, not opened on.
If you also look closely at the subtext it will remind you that it is filtering on when cases were modified.
Note: Confusingly enough, at this time the list of cases in your export however will be sorted by the opened on date.