Finding all versions of an artifact across configurations

You can create a report that finds all versions of an artifact for IBM® Engineering Test Management or IBM Engineering Requirements Management DOORS® Next projects that are configuration-enabled.

About this task

For requirements and test artifacts, projects that are enabled for configuration management can have one or more components. Each component can have one or more streams and baselines (configurations). In Engineering Test Management and Engineering Requirements Management DOORS Next, you can also refactor or clone a resource from one component into another component so that both components have the same artifact but different versions of it. A component might have multiple configurations, or if artifacts are copied into another component. In this case, you might want to construct a report to find all versions of a specific artifact and the configurations.

To create this kind of report, you must know the type of resource that you want to find and its unique ID.


  1. Open Report Builder.

    Go to https://server_name:port/rs. On the Reports page, click Build report. If the page doesn't open, contact your application administrator.

  2. Choose a report type.
    • Click the pencil Edit icon to select the Lifecycle Query Engine data source (not the Lifecycle Query Engine scoped by a configuration data source).
    • Select Current Data (table or graph) to report on the information about artifacts in and across projects.
  3. When you are using the LQE data source, projects that are enabled for configuration management are hidden by default. In the Limit the scope section, select the List all project areas when reporting on configurations themselves checkbox to see configuration-enabled projects in the list.
    Limit scope

    Choose the projects to report on, and click Continue. If you do not select any projects, the report includes all projects that you can access.

  4. In the Choose an artifact section, select the Configuration type if you want to find both streams and baselines that contain the artifact. If you want just streams, expand the Configuration twistie and select the Stream type.
    Choosing the configuration artifact
  5. Add a filter in the Set conditions section:
    1. Click Add condition.
    2. From the list, select the artifact type that is the target of the Is Version Of relationship, for example QM Test Plan.
    3. Choose the ID attribute for the component, and select the values to return the artifacts you want.
    4. In the Choose values list, select is for the operator and enter the exact ID of the artifact that you want to find all versions of.
    5. To keep the window open for adding other conditions, click Add. Otherwise, click Add and Close.
      If you want to trace multiple artifacts of the same type, you can add multiple conditions. If you do not add any conditions, the report extracts all versions of all artifacts of the same type.
      Condition with the Id attribute and the is operator
  6. Format the results:
    1. In the Add columns section, click Attribute .
    2. Select the target artifact type (for example QM test plan), choose the Project Area attribute, and click Add.
      Project area attribute of test plan
    3. Click the Project Area (QM Test Plan) attribute and drag the attribute to the start of the list.
      Dotted lines beside the attribute
    4. Delete the Component 1 ID and URL (Component) 1 columns because you only need the component title.
    5. Move the Component 1 title column immediately below the Project Area (QM Test Plan) column.
    6. Delete the Configuration ID column but leave the title and URL columns for the configuration.
    7. Delete the URL (Version Resource) column as this URL is not useful for most users.
    8. If you want to distinguish between streams and baselines, add the Mutable attribute for the configuration type and move it below the URL (Configuration) column. You might want to rename the Mutable column to something more meaningful like Is Stream.
    9. Sort the columns into the following order:
      1. Project Area (QM Test Plan) - ascending
      2. Component 1 - ascending
      3. Mutable - descending
      4. Configuration - ascending
      For every component, this sorting order groups its streams first and then its baselines.
      Columns sorted

      Do not add any other columns from your target artifact type (for example, QM Test Plan) because if the various versions of that artifact have different values for a property, then the SPARQL query execution creates all combinations of the property values for that artifact. Many of the property combinations are invalid.

  7. Run the report.
    In the results table, the same artifact title, 'User Acceptance' is listed for each configuration under the QM Test Plan column, where that title is a hyperlink. If you hover over each instance of that artifact, you see the compact rendering of the artifact for the corresponding configuration. In this example, the User Acceptance test plan was modified in component 1 of the project and multiple baselines and streams were created. In addition, that test plan was copied into the initial stream of component 2.
    Results of running the report
  8. When you are satisfied with the report, click the Name and Share page title, and specify the details for your report. Click Save.
    For more information, see the section Name and share the report in this topic.

What to do next

  • To see your report in the list of other reports, click All Reports or My Reports.
  • To view a full-page version of your report in a new window, click Open in a new window.
  • To further edit your report, click a pencil in the My Choices pane at the right. Click Save to save your changes.
  • You can export your report to various document types (Microsoft Word or Excel, PDF, or HTML). To do further editing on the report, export it to IBM Engineering Lifecycle Optimization - Publishing if you have a license. You can also export a report graph to an image file. See the related topics.