To be able to retrieve only particular hierarchy level with all childs from huge hierarchy levels

[lakshmi_laksh]

Hello all,
the requirement is that i am having field called 'business unit' on project record which is reference to 'Business_unit'  table , that tables contains records in hierarchy levels, where  parent called "ITCI" the units under 'ITCI' and under so on only can be considered.
need script how to consider all levels of childs under one parent is required.
if anyone can help me with this script that would be helpful.
Thanks in advance.

[Tony Chatfield1]

Hi, any solution for this requirement will depend on the configuration\structure of your reference table,

and you would normally use a reference qualifier to filter the data visible for the reference field based, on some other selected value in your record/form IE how exactly will ITCI be identified ?
- If you want to filter by a 'parent' value then you will need to select the parent somewhere before you can filter for related records\children.

There are then a number of Reference qualifier filter options.
You could return a query with a fix set of sys_id's (the records you want to show)
You could filter on a variation of, parent== ITCI OR parent.parent == ITCI OR parent.parent.parent ==ITCI etc
You could also add a 'text' field to each record containing details of the records path\parent tree structure, similar to the way domain path field is used to show a domain tree, allowing you to filter on field CONTAINS 'ITCI'.

Perhaps you could update this thread with some clearer details of your configuration and use case\requirements, so that the community is in a better position to understand and assist.