Hi all,

Can anybody help me with the query for retrieving the Parent Subject name in Test plan? suppose there are two Folders inside one of my subject folder, So when I am tryinig to retrieve the TS_SUBJECT column, it is giving only the immediate folder name of the testcase, whereas i need the parent folder name which is just below the folder "Subject" in Test plan.

Please help its very important.

Thanks and Regards,