Search Construction and Syntax

User profiles store a wealth of useful data, although that data is useful only if you have: 1) easy access to it, and, 2) tools available to help you retrieve the data. Fortunately, the Console introduces a number of powerful search mechanisms that make the Console a superior tool for locating the exact information you need. For example, the Console enables you to:

  • Search on more than one attribute (and/or more than one value) at a time. In the Capture Dashboard you can search for all the users who live in the state of Oregon; however, you can’t search for all the users who live in the state of Oregon or in the state of Washington. This type of search (often referred to as a Boolean search) is an integral part of the Console.
  • Use wildcards when running a search. For example, suppose you can’t remember if a user is named Cindy, Cindi, or Cyndy. In the Capture Dashboard, you would have to conduct separate searches on each of those names. In the Console, you can do a single wildcard search that can find all those names in a single operation: givenName = “C?nd?”.
  • Export user profile data. The Console includes an Export Options button that makes it easy to save user data as either a CSV (comma-separated values) file or as a JSON (JavaScript Object Notation) file. The Capture Dashboard does not allow you to export user data.
  • Sort records returned from a search. The Console lets you sort data by any indexed attribute. By comparison, Capture Dashboard records are always sorted by lastUpdate time.
  • Modify the attributes displayed in your search results. By default, a Console search displays the following six attributes: givenName; familyName; email;; birthday; and created. However, you can modify your search results to display the values for any non-plural attribute.

Before you can use these powerful new search tools, you need to have a good understanding of how search works in the Console; as well as the syntax required for creating search queries. These topics should help you achieve that understanding: