AnsweredAssumed Answered

Query needed...

Question asked by Chuck_Williams_313 on Dec 20, 2013
Latest reply on Dec 27, 2013 by Mark_Hadler_430

I am looking for a way to execute a series of registration jobs automatically in a workflow.  Each of the jobs shares a similar name, and I want them to be executed as an initial step in a workflow to be sure all of the products installed are registered in a static variable.

Currently, I am exporting the list of jobs to a file,

:SET &OBJECT# = "CATALOGS_*_REGISTER_LOADER_TYPE"

:SET &FILE#  = "&WIN_WORKING_DIR#\jobs.tmp"

:SET &RET#    = EXPORT(&OBJECT#,&FILE#)

then parsing the file, but this is a bit awkward, and looks prone to failure in the future.

I would like to use a query variable to get a list of the matching jobs and then iterate through the returned variable, but I do not know which table to use.

Something like…

SELECT objectName FROM [table] WHERE client=&$CLIENT# and objectName LIKE  ‘CATALOGS_%_REGISTER_LOADER_TYPE’

A table name to use would be greatly appreciated.

Outcomes