Displaying jobs/sequencers in folders

Victoria · Post by **Victoria** » Tue May 20, 2008 11:11 pm

Hi,

I would like to list the jobs/sequencers under the folders of my project. For example, I have MYPROJECT project and folders FOLDER1, FOLDER2, FOLDER3, FOLDER4 and FOLDER5.
I would like to have an output which will give me the folder name and the jobs/sequencers under it:
FOLDER1:
Job1a
Job1b
Jobseq1c
FOLDER2:
Jobseq2a
Job2a
Job2b
...
FOLDER4:
Job3a
Job3seqa
Job3seqb

What function or can you pass me a sample routine that does this??
Thanks in advance..

ray.wurlod · Post by **ray.wurlod** » Wed May 21, 2008 1:27 am

Code: Select all

SELECT BREAK ON "'O'" CATEGORY FMT '32L', NAME FMT '40L' FROM DS_JOBS WHERE NAME NOT LIKE '\\%' ORDER BY 1,2;

ag_ram · Post by **ag_ram** » Thu May 22, 2008 11:05 pm

Victoria,

I guess, If you call 'Folders' as 'Category', it woluld seem to be better.

However, the solution is above.