Example: Investigator Queries

Using the Investigator › Investigator › View Tabular Data › Example: Investigator Queries

Example: Investigator Queries

The search option helps you filter data based on customizable search queries. This example helps you formulate search queries. This example is based on a table, which contains the following columns:

Note: The search is case-sensitive.

System ID

Identifies a unique system identification number.

System Name

Identifies the systems to which CA Chorus is connected.

System ID	System Name
01	System1
11	System3
12	system1
27	System38
33	System385

Use the following examples to help formulate queries:

Column Name	Operator	Search Value	Meaning of the Query	Result
System Name	=	System1	Columns having a value System1.	System1
System Name	<>	System1	Columns having a value other than System1.	system1 System3 System38 System385
System Name	like Note: To search for a specified pattern in a column, use the like operator. To define missing characters (character masking) in the pattern, use the percent (%) sign.	%38%	Columns having a value that follows the pattern, 38.	System38 System385
System Name	contains	3	Columns that contain the value 3.	System3 System38 System385
System ID	starts with	1	Columns that start with the value 1.	11 12

Example: Grouping Criteria with Parenthesis

To search for user IDs that start with A or B, specify the following filter criteria:

User ID starts with A OR User ID starts with B

If your filter criteria is complex, the AND or OR operators can cause confusion. For example, if you are searching for administration users whose User IDs start with A or B, OR all managers whose user IDs start with C or D, group each line in the filter criteria using parenthesis:

(((User ID starts with A OR User ID starts with B) AND (User Role ='Admin')) OR ((User ID starts with C OR User ID starts with D) AND (UserRole = 'Manager')))