HomeBlog
DWQA Questions › How can I create a dynamic filter that will retrieve all the child items of selected work item
0 Vote Up Vote Down
Rami.Azulay Staff asked 7 years ago

In some cases, I need to build a filter that will dynamically show the results of all the items that are located as a child to the selected parent.
Such use could be for the presentation of CAPA and it’s corrective and preventive action items.

1 Answers
0 Vote Up Vote Down
Rami.Azulay Staff answered 7 years ago

Build a filter where you can use the User Define Criteria section and place in this section the following sql string:

 

(Path like ((Select Path from OBJECTS Where ID=[$ME]) + (Select max(cast(Original_id as varchar)) from OBJECTS_VER_VIEW Where ID=[$ME]) + ‘\%’) or ID=[$ME])