Examples of SBM–Processed SQL

When a field name contains spaces or any other non-alphanumeric characters, enclose the field name within double quotation marks (").

The following examples are created using fictional data. These examples show you how to handle multi-word names.

• Finding items you own

  Owner=current

• Finding items owned by any user, or a subset of users

  Owner IN ("Joe Manager", "Sarah Developer", "Tom Support Manager")

• Finding items for a subset of projects

  Project IN ("Professional Suite", "Image Builder")

• Finding all active primary items

  "Active/Inactive" = Active

  The quotation marks around Active/Inactive are necessary because of the forward slash (/) character.

• Find primary items with Severity of Critical or High:

  (Severity = Critical) OR (Severity = High)

• Find primary items with Severity of Critical, High, or Medium:

  You have the option of using the OR operator, as above, or the IN operator. The following example shows how to use the IN operator.

  Severity IN (Critical, High, Medium).

• Find assigned primary items owned by Joe Manager:

  (State = Assigned) AND (Owner = "Joe Manager").

  The quotation marks around Joe Manager are necessary because of the space between the names.

• Find items submitted on or after June 1, 2002:

  "Submit Date/Time" >= "6/1/02".

• Find items submitted in the last two weeks:

  "Submit Date/Time" >= (now - 14)

  Note: You can replace 'now' with a DBMS-specific value. You can also use a DBMS-specific date equation for the section to the right of the 'equals' sign.

• Find items that contain a particular text string in the Description field:

  Description LIKE '%testing%'

  Note: The use of single quotation marks is imperative. The % character is a wildcard. This particular example returns results of any items containing the word "testing" in the Description field. Use the LIKE operator with any text, fixed length, or memo field.

• Find items for which the title begins with a certain text string:

  Title LIKE 'Image%'

• Find items using a combination of operators. Find items submitted after December 1, 2001, which were later deferred:

  ("Submit Date/Time" > "12/1/01") AND (State = Deferred)

  Tip: Fields with a space in the name must be enclosed within double quotation marks. Separate each part of the expression using parentheses.