Connect By

SQL

SELECT STUDYLEVEL01.STUDYLEVELNO AS STUDYLEVELNO01
FROM STUDYLEVEL STUDYLEVEL01
WHERE 1=1
CONNECT BY PRIOR STUDYLEVEL01.STUDYLEVELNO=STUDYLEVEL01.PARENTSTUDYLEVELNO
START WITH (STUDYLEVEL01.STUDYLEVELNO=5)

XML query API

<query alias="testHierarchicalFiltering" projectedClass="com.taleo.akirademo.entity.StudyLevel">
    <projections>
        <projection>
            <field path="no"/>
        </projection>
    </projections>
    <hierarchicalFilterings>
        <hierarchicalFiltering>
            <hierarchicalFilter>
                <equal>
                    <field path="no"/>
                    <field path="parent"/>
                </equal>
            </hierarchicalFilter>
            <startWithFilter>
                <equal>
                    <field path="no"/><integer>5</integer>
                </equal>
            </startWithFilter>
        </hierarchicalFiltering>
    </hierarchicalFilterings>
</query>