List of Test Cases (Test ID) under a folder

List of Test Cases (Test ID) under a folder

SELECT TS_TEST_ID FROM TEST
WHERE
TS_SUBJECT IN
        (SELECT AL_ITEM_ID FROM ALL_LISTS
         WHERE
         AL_ABSOLUTE_PATH LIKE (SELECT AL_ABSOLUTE_PATH+'%'
                                             FROM ALL_LISTS WHERE AL_ITEM_ID = 5))