cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

A query to filter 'Team's by a string

SOLVED
Participant

A query to filter 'Team's by a string

Hello all,

 

I am bit confused with a building a query but it might be trivial for you people. Nevertheless I request your feedback.

 

I want to build a query that search for all the 'Team's with a name say 'Abc'.

 

Any help would be appreciated.

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: A query to filter 'Team's by a string

I'm assuming here that Team is the type of item and Name is a field in the item.  As you mention that you are new to creating queries, I've included several screenshots to help you.

 

To create the query in the GUI:

  1. Select Query > Create Query
  2. Click on the Add Filter button in the Definition Tab.
  3. Select Fields for the type of filter, and Type for the field to query on, then OK:selectfieldtype.PNG
  4. Click Next. Select the Type you want to query on:selectTeam.PNGSelect Type to query on Then click OK and Finish.
    Your first filter is added.
  5. Repeat these steps for the field "Name":addfiltername.PNGteamname.PNG
  6. Click Finish. You should have both filters in your query now, connected with "and": nameandtypefilters.PNG
  7. Click OK to save your new query.

The WebUI is similar, but the "Add Filter" button is the + sign at the bottom of the window:

 webui_addfilter.PNG

 You can find more details on creating queries in the online help. Here's the link for 12.0: https://support.ptc.com/cs/help/integrity_hc/integrity120_hc/en/IntegrityHelp/client_creating_a_quer...

Older help centres can be found here: https://support.ptc.com/appserver/cs/help/help.jsp

View solution in original post

1 REPLY 1

Re: A query to filter 'Team's by a string

I'm assuming here that Team is the type of item and Name is a field in the item.  As you mention that you are new to creating queries, I've included several screenshots to help you.

 

To create the query in the GUI:

  1. Select Query > Create Query
  2. Click on the Add Filter button in the Definition Tab.
  3. Select Fields for the type of filter, and Type for the field to query on, then OK:selectfieldtype.PNG
  4. Click Next. Select the Type you want to query on:selectTeam.PNGSelect Type to query on Then click OK and Finish.
    Your first filter is added.
  5. Repeat these steps for the field "Name":addfiltername.PNGteamname.PNG
  6. Click Finish. You should have both filters in your query now, connected with "and": nameandtypefilters.PNG
  7. Click OK to save your new query.

The WebUI is similar, but the "Add Filter" button is the + sign at the bottom of the window:

 webui_addfilter.PNG

 You can find more details on creating queries in the online help. Here's the link for 12.0: https://support.ptc.com/cs/help/integrity_hc/integrity120_hc/en/IntegrityHelp/client_creating_a_quer...

Older help centres can be found here: https://support.ptc.com/appserver/cs/help/help.jsp

View solution in original post

Announcements