Administer > Database administration > Data persistence > Queries > Create a query using isin in statements

Create a query using isin in statements

Applies to User Roles:

System Administrator

Example: Retrieve all contacts records where the Company name is either DEFAULT or advantage and the Contact Name begins with the letter B.

In this example, we perform a complex query on the contacts.qbe form using the isin relational operator. An Advanced Search is performed and records are returned where the value of the Company field is either DEFAULT or advantage and the value of the Contact Name field begins the letter B.

To create a query using isin in statements:

  1. Click System Administration > Base System Configuration > Contacts.
  2. On the Contact Information form, open the More Actions menu.
  3. Select Expert Search.
  4. In the Query field, type company isin {“advantage”, “DEFAULT”} and contact.name#“B’, and then click Search.
  5. Click any record in the list of returned records to view the details.