{"id":37375,"date":"2018-01-30T02:59:56","date_gmt":"2018-01-30T10:59:56","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/37375\/how-to-query-tracking-itemsissues-not-having-any-child-itemsissues-in-open-state\/"},"modified":"2019-10-01T03:07:39","modified_gmt":"2019-10-01T10:07:39","slug":"how-to-query-tracking-itemsissues-not-having-any-child-itemsissues-in-open-state","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/37375\/how-to-query-tracking-itemsissues-not-having-any-child-itemsissues-in-open-state\/","title":{"rendered":"How to query Tracking Items\/Issues not having any Child Items\/Issues in 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 Tracking Items\/Issues not having any Child Items\/Issues in &#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 Issue List<\/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\/wpid37351-media_1506422881984.png\" alt=\"wpid37351-media_1506422881984.png\" width=\"550\" height=\"433\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 2. Click Manage Filters in the list editor<\/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_15064230748622.png\" alt=\"wpid-media_15064230748622.png\" width=\"800\" height=\"347\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 3. 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\/wpid-media_15064231437582.png\" alt=\"wpid-media_15064231437582.png\" width=\"800\" height=\"598\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 4. 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_15053900071755.png\" alt=\"wpid-media_15053900071755.png\" width=\"658\" height=\"496\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 5. 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_15053901302515.png\" alt=\"wpid-media_15053901302515.png\" width=\"800\" height=\"569\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 6. Select filter option as &#8220;Having no Child 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\/wpid38529-media_1506427024872.png\" alt=\"wpid38529-media_1506427024872.png\" width=\"800\" height=\"566\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 7. 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\/wpid38531-media_1506431785372.png\" alt=\"wpid38531-media_1506431785372.png\" width=\"800\" height=\"566\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 8. Specify condition for the Tracking Items not having any Child Items in &#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\/wpid38532-media_1506431824109.png\" alt=\"wpid38532-media_1506431824109.png\" width=\"800\" height=\"566\" \/><\/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 9. 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\/wpid38533-media_1506431870842.png\" alt=\"wpid38533-media_1506431870842.png\" width=\"652\" height=\"488\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 10. 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\/wpid38530-media_1506427313454.png\" alt=\"wpid38530-media_1506427313454.png\" width=\"652\" height=\"488\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 11. 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\/wpid38534-media_1506432142215.png\" alt=\"wpid38534-media_1506432142215.png\" width=\"800\" height=\"272\" \/><\/div>\n<div class=\"StepInstructions\">\n<p><span style=\"color: #000000;\">For more information on applying filter, refer to the article <\/span><a href=\"http:\/\/www.technosolutions.com\/kb\/38390\/how-to-apply-a-filter\/\" target=\"_blank\" rel=\"noopener\">How to apply a filter<\/a><span style=\"color: #000000;\">.<\/span><\/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 Tracking Items\/Issues not having any Child Items\/Issues in &#8220;Open&#8221; state. Who should read this? TopTeam Users Step 1. Open Issue List Step 2. Click Manage Filters in the list editor Step 3. Create a new filter in the Manage Filters window Step 4. Go to the Relational Filter tab Step 5. Select Relational Filter Type Step 6. Select filter option as &#8220;Having no Child Items&#8221; Step 7. Select Issues record type Step 8. Specify condition for the Tracking Items not having any Child Items in &#8220;Open&#8221; state Similar <\/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-37375","post","type-post","status-publish","format-standard","hentry","category-filters"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-9IP","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/37375","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=37375"}],"version-history":[{"count":5,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/37375\/revisions"}],"predecessor-version":[{"id":48662,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/37375\/revisions\/48662"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=37375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=37375"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=37375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}