fbpx
1-888-310-4540 (main) / 1-888-707-6150 (support) info@spkaa.com
Select Page

Three Ways to Narrow your Query results in PTC Integrity Lifecycle Manager

windchill features best plm software
Written by SPK Blog Post
Published on September 17, 2015

One of the most powerful features of PTC Integrity Lifecycle Manager is the ability for system Administrators to have a set of pre-defined queries set up in the system that the user community can use to perform all of their basic tasks. Often times though, out of necessity, those administrator queries are quite generalized, and the end-users will want to see a result set more tailored to what they are looking for.

In this article, I am going to discuss three ways in which users can potentially narrow down the results of a query in PTC Integrity Lifecycle Manager to be more in tune with what they may be looking for. These three ways are using a project filter, using the query builder to add additional criteria, and the “Show Items containing” filter. If we take a simple Admin provided query like for example the “All Documents” query as shown below, I’ll demonstrate how you can modify the results of that query by each of the three methods above.

narrow1

  1. The first of these methods appears under the View -> Options menu, where you can elect to show the project filter:
    narrow2In this case we selected the Monitor-R1 project as our project filter. This means that once we have refreshed the query, the amount of items returned will be reduced to those items that have a value define for the Project field that corresponds to the project filter.

    narrow3

  2. The second method is also available through the View -> Options menu. Here, you can choose to show the Query Builder.  Through the query builder you can add or change the query criteria of your most recently executed query:
    narrow4In this case I’ve added the “Summary” contains “Feature” to the pre-existing query criteria, and as you can see once we refresh the query the result set is greatly reduced.
    narrow5
  3. Lastly, and probably the simplest way to narrow down your result set is to use the “Show items containing” filter to the query results. In this case I entered the value “Test” into the “Show items containing” field thus further reducing my sample set down to one item.
    narrow6

By using these three methods users of PTC Integrity Lifecycle Manager can narrow down the results of their queries to a list more suited to the task they are currently performing.

Next Steps:

Latest White Papers

The Hybrid-Remote Playbook

The Hybrid-Remote Playbook

Post-pandemic, many companies have shifted to a hybrid or fully remote work environment. Despite many companies having fully remote workers, many still rely on synchronous communication. Loom offers a way for employees to work on their own time, without as many...

Related Resources

How Model-Based Definition (MBD) Cuts ECOs by 41% and Scrap by 47%

How Model-Based Definition (MBD) Cuts ECOs by 41% and Scrap by 47%

Organizations are increasingly turning to Model-Based Definition (MBD) to revolutionize their engineering and manufacturing processes. By embedding rich, digital annotations directly into 3D models, MBD provides a single source of truth for product definitions. This...

OKR and Agile: Harmonizing Strategic Goals with Agile Methodologies

OKR and Agile: Harmonizing Strategic Goals with Agile Methodologies

Objectives and Key Results (OKRs) and Agile methodologies like Scrum, Kanban, and SAFe are powerful frameworks designed to boost productivity and keep teams aligned. OKRs drive strategic goal-setting and measurable outcomes, while Agile approaches like Scrum focus on...