Entering Advanced Report Criteria

When defining the criteria for a report, you can use the More function to specify detailed criteria to restrict the report to only the information needed.

Before you begin: Before you start, select the report you want to generate from the Metrics > Common Reports menu and enter basic criteria.

  1. Click More.

    The page expands to show additional criteria. The attributes that display depend on the ENOVIA products in use.

  2. At the top of the advanced search section, select whether you want to use an "Or" search or an "And" search.

    Or. Search results contain items that include any attributes specified.

    And. Search results contain items that include all attributes specified.

    For example, suppose you search for parts and specify the following attributes:


    • Modified greater than Dec. 1, 2003
    • Target Cost less than $1000

    If you select "And," the search results contain only those parts that have been modified since Dec. 1, 2003 and have a Target Cost less than $1000.

    If you select "Or," the search results will show all parts that have been modified since Dec.1, 2003, regardless of what their Target Cost is. It will also include all parts that have a Target Cost less than $1000, regardless of when they were last modified. "Or" searches often produce a larger number of results than "And" searches.

  3. For each attribute that you want to include in the search criteria, choose an operator and enter the data you want to search on:

    If range values have been predefined for the attribute, a drop-down list is provided in the Select Value column.

    Attribute Type Operator Description
    Text Begins with The system looks for attributes whose data begins with the text you enter (like including a wildcard * at the end of the text you enter).
    Ends with The system looks for attributes whose data ends with the text you enter (like including a wildcard * at the beginning of the text you enter).
    Includes The system looks for attributes whose data includes the text you enter (like including a wildcard * before and after the text you enter).
    Is exactly The system looks for attributes with data that exactly matches the text you enter (like not including a wildcard in the text you enter).
    Is not The system looks for attributes that do not contain the text you enter.
    Matches The system looks for attributes with data that matches text you enter.
    Numeric Is at least, Is at most, Does not equal, Equals, Is between, Is less than, Is more than If you select Is Between include both values in the Value column, separated by spaces.

    If the attribute has been configured with units of measure, a drop-down list shows next to the text box. You can search for any value/units regardless of the actual units used to store the data.
    Date/Time Is on, Is on or before, Is on or after. Click to select a date.