https://www.ptcusercommunity.com/t5/Windchill-Customization/How-to-search-all-children-within-a-Part-structure/m-p/977642#M8832 <P>One possible approach might be to write a java method that recursively returns all child objects for a given WTPart. Then you could use that java method in a query builder report</P> Mon, 14 Oct 2024 13:10:32 GMT joe_morton 2024-10-14T13:10:32Z https://www.ptcusercommunity.com/t5/Windchill-Customization/How-to-search-all-children-within-a-Part-structure/m-p/977557#M8831 <P>Version: Windchill 12.1</P><P>&nbsp;</P><P>Use Case: In the top level Part structure of a car or truck, search for children at all levels with an matching attribute value, ie show all parts within the car made from Aluminium</P><P><BR /><SPAN>Description: </SPAN></P><P>I need to search attributes of all children at all levels within a Part structure. I want to report on attributes like state and materials for all Parts within a car structure, this may be 6 levels deep.</P><P>&nbsp;</P><P>Currently the method being used is to export to excel and use pivot tables.</P><P>&nbsp;</P><P>I have previously used a JSP with some java code I wrote to recursively search for children at all levels with a certain state, this works but is limited to a single attribute input, I want to select any usage or item attribute as input and see a filtered list of child parts matching the criteria.</P><P>&nbsp;</P><P>Any ideas on what approach to take?</P> Mon, 14 Oct 2024 09:32:29 GMT https://www.ptcusercommunity.com/t5/Windchill-Customization/How-to-search-all-children-within-a-Part-structure/m-p/977557#M8831 khimani_mohiki 2024-10-14T09:32:29Z https://www.ptcusercommunity.com/t5/Windchill-Customization/How-to-search-all-children-within-a-Part-structure/m-p/977642#M8832 <P>One possible approach might be to write a java method that recursively returns all child objects for a given WTPart. Then you could use that java method in a query builder report</P> Mon, 14 Oct 2024 13:10:32 GMT https://www.ptcusercommunity.com/t5/Windchill-Customization/How-to-search-all-children-within-a-Part-structure/m-p/977642#M8832 joe_morton 2024-10-14T13:10:32Z https://www.ptcusercommunity.com/t5/Windchill-Customization/How-to-search-all-children-within-a-Part-structure/m-p/977654#M8833 <P>So return all children at all levels into a WTCollection, then use that in the query builder?</P> Mon, 14 Oct 2024 13:26:54 GMT https://www.ptcusercommunity.com/t5/Windchill-Customization/How-to-search-all-children-within-a-Part-structure/m-p/977654#M8833 khimani_mohiki 2024-10-14T13:26:54Z https://www.ptcusercommunity.com/t5/Windchill-Customization/How-to-search-all-children-within-a-Part-structure/m-p/977661#M8834 <P>Actually, now I'm doubting myself. I think java method can only return strings in query builder.&nbsp;<span class="lia-unicode-emoji" title=":downcast_face_with_sweat:">😓</span> It's been awhile since I've worked with them.</P> Mon, 14 Oct 2024 13:34:53 GMT https://www.ptcusercommunity.com/t5/Windchill-Customization/How-to-search-all-children-within-a-Part-structure/m-p/977661#M8834 joe_morton 2024-10-14T13:34:53Z https://www.ptcusercommunity.com/t5/Windchill-Customization/How-to-search-all-children-within-a-Part-structure/m-p/978291#M8844 <P>Adjust your approach by entering the attribute names separated by a delimiter in the same field you are entering the attribute name now.</P> <P>&nbsp;</P> <P>From there you should be able to adjust your code to search for these attributes. <span class="lia-unicode-emoji" title=":beaming_face_with_smiling_eyes:">😁</span>&nbsp;</P> Wed, 16 Oct 2024 12:10:52 GMT https://www.ptcusercommunity.com/t5/Windchill-Customization/How-to-search-all-children-within-a-Part-structure/m-p/978291#M8844 d_graham 2024-10-16T12:10:52Z