Hello Guys, I am trying to fetch Directorate and Division which are DFF on create requisition

Summary:

Hello Guys, I am trying to fetch Directorate and Division which are DFF on create requisition page, now I am able to do that with adding a query on SQL default and creating a value set but my expectation was it should fetch for that position only and not all values but I am not able to pass any position parameter.

Following is the query I used

SELECT DISTINCT

p1_dept.name
orglevel1

FROM
per_dept_tree_node_v parent1

,per_dept_tree_node_v
parent2

,per_departments
p1_dept

,per_departments
p2_dept

,per_dept_tree_node_v