How to create custom interactive filters on the same table with conditions

Alvin7 · ‎06-17-2020

Dear expert,
I'm a beginner for ServiceNow,regarding the Custom interactive filters,could you please give some advice?Thanks in advance.

Requirement:
Use custom interactive filter to retrieve the component and it's sub-component
and display the result on Dashboard.

Currently,in the dashboard,there is already a component reference filter cannot meet the above requirement(this filter can only retreive the input component itself).

Sample data structure:

The componet and sub-component stored in the same table,the table strutcture like below:
Record 1:
<sys_id>624e8e221bc233401ead7403dd4bcb43</sys_id>
<u_component>AC</u_component>
<u_parent/>
Record 2:
<sys_id>a24e8e221bc233401ead7403dd4bcb46</sys_id>
<u_component>ACCO</u_component>
<u_parent display_value=""AC"">624e8e221bc233401ead7403dd4bcb43</u_parent>
If input the component with name "AC",the above 2 recoreds(component AC and it's sub-component ACCO) should be retrieved.

Following the below instructions,UI macro(system UI>>UI macro) and Dynamic content(Content Management >> Dynamic) was created,it still does not work correctly.
1)https://developer.servicenow.com/connect.do#!/event/creatorcon18/CCW1161
2)https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/dashboards/concept/c_CustomPublishers.html

Question:
For this issue,where should I start from?
Can you give me some advice?
How to find the component and it's component in the Dynamic content?