{"id":37306,"date":"2018-01-30T02:50:05","date_gmt":"2018-01-30T10:50:05","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/37306\/how-to-query-repository-artifacts-that-are-linked-to-tracking-itemsissues-having-open-state\/"},"modified":"2019-10-01T03:20:49","modified_gmt":"2019-10-01T10:20:49","slug":"how-to-query-repository-artifacts-that-are-linked-to-tracking-itemsissues-having-open-state","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/37306\/how-to-query-repository-artifacts-that-are-linked-to-tracking-itemsissues-having-open-state\/","title":{"rendered":"How to query repository artifacts that are linked to Tracking Items\/Issues having Open state"},"content":{"rendered":"<p><!-- Start ScreenSteps Content --><\/p>\n<div class=\"LessonContent\">\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Overview<\/h3>\n<div class=\"StepInstructions\">\n<p>This article describes the procedure for applying a filter to view repository artifacts that are linked to Tracking Items\/Issues having &#8220;Open&#8221; state.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Who should read this?<\/h3>\n<div class=\"StepInstructions\">\n<ul>\n<li>TopTeam Users<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 1. Open a List or Tree editor and open Manage Filters window<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/02\/wpid38417-media_1505389849903.png\" alt=\"wpid38417-media_1505389849903.png\" width=\"800\" height=\"569\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>For information on opening a list and tree editor, refer to the article <a href=\"http:\/\/www.technosolutions.com\/kb\/37253\/opening-list-and-tree-editors-in-topteam\/\" target=\"_blank\" rel=\"noopener\">Opening List and Tree Editors in TopTeam<\/a>.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 2. Create a new filter in the Manage Filters window<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/02\/wpid38419-media_1505389917397.png\" alt=\"wpid38419-media_1505389917397.png\" width=\"800\" height=\"569\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 3. Go to the Relational Filter tab<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/02\/wpid-media_15053900071751.png\" alt=\"wpid-media_15053900071751.png\" width=\"658\" height=\"496\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 4. Select Relational Filter Type<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/02\/wpid-media_15053901302511.png\" alt=\"wpid-media_15053901302511.png\" width=\"800\" height=\"569\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 5. Select filter option as &#8220;Having Linked Tracking Items&#8221;<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/02\/wpid38422-media_1505390846316.png\" alt=\"wpid38422-media_1505390846316.png\" width=\"800\" height=\"569\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 6. Select Issues record type<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/02\/wpid38424-media_1506430555820.png\" alt=\"wpid38424-media_1506430555820.png\" width=\"800\" height=\"566\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 7. Specify condition for the linked Tracking Items having &#8220;Open&#8221; state<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/02\/wpid38425-media_1506430654449.png\" alt=\"wpid38425-media_1506430654449.png\" width=\"800\" height=\"565\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Similar to the <i>State<\/i> field, you can also use other fields to filter records.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 8. View defined filter<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/02\/wpid38426-media_1506430679245.png\" alt=\"wpid38426-media_1506430679245.png\" width=\"660\" height=\"489\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 9. Enter Filter Name and Description (Optional)<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/02\/wpid38423-media_1505890530214.png\" alt=\"wpid38423-media_1505890530214.png\" width=\"659\" height=\"489\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 10. Apply the filter<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/02\/wpid38427-media_1518525362065.png\" alt=\"wpid38427-media_1518525362065.png\" width=\"800\" height=\"308\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>For more information on applying filter, refer to the article <a href=\"http:\/\/www.technosolutions.com\/kb\/38390\/how-to-apply-a-filter\/\" target=\"_blank\" rel=\"noopener\"><u>How to apply a filter<\/u><\/a>.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">See Also<\/h3>\n<div class=\"StepInstructions\">\n<p><a href=\"http:\/\/www.technosolutions.com\/kb\/37264\/using-relational-filters\" target=\"_blank\" rel=\"noopener\">Using Relational Filters<\/a><\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepInstructions\">\n<p>Revised: February 23rd, 2018<\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><!-- End ScreenSteps Content --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview This article describes the procedure for applying a filter to view repository artifacts that are linked to Tracking Items\/Issues having &#8220;Open&#8221; state. Who should read this? TopTeam Users Step 1. Open a List or Tree editor and open Manage Filters window For information on opening a list and tree editor, refer to the article Opening List and Tree Editors in TopTeam. Step 2. Create a new filter in the Manage Filters window Step 3. Go to the Relational Filter tab Step 4. Select Relational Filter Type Step 5. Select filter option as &#8220;Having Linked Tracking Items&#8221; Step 6. Select <\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[352],"tags":[],"class_list":["post-37306","post","type-post","status-publish","format-standard","hentry","category-filters"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-9HI","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/37306","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=37306"}],"version-history":[{"count":5,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/37306\/revisions"}],"predecessor-version":[{"id":48678,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/37306\/revisions\/48678"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=37306"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=37306"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=37306"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}