I have a situation where I need to show the full path of a test, not just the 'Subject'. I realize there is a 'AL_ABSOLUTE_PATH' field, but that is garbage to human eyes.
Does anyone have an idea how I could show the full path rather than just the subject? An example of the type of query I'm doing is...
<font class="small">Code:</font><hr /><pre>
Select ALL_LISTS.AL_DESCRIPTION as "Subject", TEST.TS_TEST_ID as "Test ID", TEST.TS_NAME as "Test Name", TEST.TS_DESCRIPTION /*Test.Description*/ as "Test Description", DESSTEPS.DS_STEP_NAME as "Step Name", DESSTEPS.DS_DESCRIPTION as "Step Description", DESSTEPS.DS_EXPECTED as "Step Expected"
FULL JOIN TEST on DESSTEPS.DS_TEST_ID = TEST.TS_TEST_ID
FULL JOIN ALL_LISTS on TEST.TS_SUBJECT = ALL_LISTS.AL_ITEM_ID
Where ALL_LISTS.AL_ABSOLUTE_PATH like
where ALL_LISTS.AL_DESCRIPTION = @Folder_Name@ ) + '%'
I may be missing something simple, but this is driving me crazy... [img]/images/graemlins/confused.gif[/img]