### Running a Query

When you run the query, Query searches the project data for Objects that meet all the search criteria defined in the list of search statements. The results are displayed in the Query Results Panel.

To run the query:

- Click Query Now. The Query Tool retrieves the required data and displays the results in the Results Panel. The Status Bar below the results shows the number of Objects found, and whether the query was run with Case Sensitive selected.

You can now:

- Modify the query and rerun it.
- Define and run another query.
- Save the query for reuse. See Saving a Query.
- Work with the results. See Working with the Query Results Panel.

You can change some aspects of the behavior of the Query Tool to suit your specific requirements. See Setting Query Preferences.

### Defining Date Attributes in Queries

When defining date attributes as criteria in a query, you may choose between different methods to retrieve the required information. These methods are:

- After - after, and not including, the requested date.
- Before - before, and not including, the requested date.
- Is between - between two given dates, and not including those dates.
- On - on the requested date.
- Not on - on any date other than the requested date.
- On or after - on the requested date or afterwards.
- On or before - on the requested date or before.
- Today - always today's date. If you are running a saved query, then it does not refer to the day the query was saved. You need to change the selection to be On to refer to that specific date.
- Yesterday - always yesterday's date. If you are running a saved query, then it does not refer to the day before the query was saved. You need to change the selection to be On to refer to that specific date.

For all of these methods, other than Today and Yesterday, you can define the date to be used. You do this either by entering the value of the date directly, or by using a calendar.

To define a date using the calendar:

1. Click the dropdown list arrow for the Value field. The calendar is displayed. The calendar always opens to the current date.
2. Navigate to the required month by using the arrows in the dialog title bar, and click on the required date to select it.

### Defining Alternative Values in Queries

When you define two or more possible values for an attribute in the Value field of a query search statement, you follow a different procedure, according to the attribute type:

- Attributes with a list of predefined values.
- Attributes with a free-text value.

To define alternative values for attributes with predefined lists:

1. Click next to the Value field.
2. In the Select Values checkbox, select the required values. For example, if you want to retrieve a Document with RELEASED or UNDER CHANGE status, select both these values.
3. Click OK.

To define alternative values for attributes with free text values:

1. Click in the Value field.
2. Enter the required values, clicking OR after each value. You can enter up to ten separate values. Clicking Clear clears all the values entered.
3. Click OK.

### Querying for Values using Wildcards

You can specify a value that contains specific text by using the * wildcard symbol, as follows:

- Entering engine creates a query for all Objects whose selected attribute value is engine.
- Entering *engine creates a query for all Objects whose selected attribute values end in the string engine.
- Entering engine* creates a query for all Objects whose selected attribute values start with the string engine.
- Entering *engine* creates a query for all Objects which have the string engine anywhere in their selected attribute value.

SSA Product Data Management 8.0 Integration for MS Office & Project © Copyright 2004 by SSA Global Technologies (Israel), Ltd All rights reserved.