Additional configuration options can be given by uploading a JSON file on the
Data Configuration dialog. Currently, the Process Cases Options is the only option that can be specified. If additional configuration options are not specified, all dictionary variables are included while breaking out the case data into the relational tables.
Processing cases through the command line can be slow if you have a large dictionary with a lot of data. The solution is to use the Process Cases Options to specify only the variables in the dictionary that are needed. For example, the dictionary variables used in a report. Only these specified dictionary variables will then be broken out into a relational database when process cases command tool is run.
The include options allows the dictionary variables and records to be targeted for inclusion. The entire dictionary can also be included by not specifying an include option or specifying an empty list for the include option (see example 1). The include option is processed first.
The exclude option allows the dictionary variables and records to be targeted for exclusion. This can be convenient if a record or the entire dictionary was included, but not all dictionary variables are needed. The exclude option is always processed after the include option.
{
"processCasesOptions":{
"include": [],
"exclude": ["HOUSING_REC"]
}
}
{
"processCasesOptions": {
"include": ["PERSON_REC", "HOUSING_REC"],
"exclude": ["HH_LAST_NAME", "HH_FIRST_NAME", "HH_ADDRESS"]
}
}