Need SQL-query to get CF_ITEM_PATH

Question ID: 104415
1
0

Hi All,

I am trying to pass a path to the folder in Test Lab as a parameter in SQL query, for example @path@=’ST\\Automation\\Cycle1\\Auto\\BankService\\Release2′. What I need is a CF_ITEM_PATH of the last folder in this path. I need to do it only using SQL query in QC.

Thank You

Marked as spam
Posted by (Questions: 2, Answers: 1)
Asked on November 25, 2011 10:21 am
33 views
Answers (1)
0
Private answer

Hello,

Have you tried this Query?

Select CYCL_FOLD.CF_ITEM_NAME, CYCL_FOLD.CF_ITEM_PATH
From CYCL_FOLD
Where CYCL_FOLD.CF_ITEM_NAME LIKE 'Release2'

Marked as spam
Posted by (Questions: 1, Answers: 69)
Answered on January 14, 2014 3:42 pm