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

Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X

A query to filter 'Team's by a string

agnibhu
4-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.

 

ACCEPTED SOLUTION

Accepted Solutions
awalsh
17-Peridot
(To:agnibhu)

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

View solution in original post

1 REPLY 1
awalsh
17-Peridot
(To:agnibhu)

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

Announcements


Top Tags