Advanced Case Search

You can use the search box to find specific cases in the Case List report and Reassign Cases tool.

Type in any word to search for that term across all columns (with the exception of Case ID: see below). To search in a specific column, use the syntax below.

Case Name

Insert "name:" before your search term, e.g.  You can encompass a name separated by spaces in quotes to search for by both first and last names.

^{name: amelia}

name:"अमिता देवी"

You can search for cases missing a name column by entering the following:

^{_missing_:name}

You can search for cases that have an empty string or null name by entering the following:

^{_missing_:name.exact OR name.exact:""}

Case ID

For the case list information based on the unique identifier, insert _id: before the unique identifier in double quotes "form|case|@case_id"   e.g.

_id:"1d141c59-dfab-4f37-b4a8-662342019038"

Case Type

Insert "type:" before your search term, e.g.

^{type: pregnancy}

Dates

You can search by the dates opened_on, modified_on, server_modified_on

Note, currently opened_on and modified_on are the two columns actively displayed in the report.  Note that 'TO' must be capitalized and can't be entered as 'to'.  Date format is yyyy-mm-dd. 

Examples

^{opened_on:[2011-01-01 TO 2012-01-01]}

^{opened_on:[2013-01-01 TO *]}

^{opened_on:[2011-01-01 TO *] AND modified_on:[2013-01-01 TO *]}

Open or Closed

You can search based on whether the case is open or closed by inserting "closed:" in front of TRUE or FALSE, e.g.

^closed:TRUE

Searching across multiple columns

Searches can be chained using AND and OR, e.g. but AND and OR must be capitalized.

^{type:some_type AND name:parker AND opened_on:[2012-01-01 TO *] AND closed:TRUE}