Skip to main content
A
agnibhu1-Visitor
1-Visitor
November 16, 2018
Solved

A query to filter 'Team's by a string

  • November 16, 2018
  • 1 reply
  • 1822 views

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.

 

Best answer by awalsh

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:Select Type to query onSelect 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_query.mif-1.html#wwID0E3BKU

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

1 reply

A
awalsh5-Regular MemberAnswer
5-Regular Member
November 16, 2018

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:Select Type to query onSelect 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_query.mif-1.html#wwID0E3BKU

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

    Terms & ConditionsCookie settingsAccessibility statement