Using iwqueryjobs with a query

robertito

I want a list of all the jobs that are owned by a particular user.

The command line tools documentation states that all the queries must be in a particular XML format, but it doesn't provide any examples of how to include the query structure into the command line arguments. In addition, the iwqueryjobs -h command just says that the queries are read from the STDIN.

Can somebody provide me with an example?

Migrateduser

Here's an email response I sent to someone asking about something similar for the iwquerytasks CLT. You can incorporate the same technique for iwqueryjobs.

There is a way to use the CLT iwquerytasks that you can use from within a script without using STDIN. It's a little funky to use, but here's one way to do it. I tend to be impatient, so once I find a way to get something to work, I don't try to
find the most efficient way, so there may be an easier way. That's my disclaimer. The command reads an XML formatted request, which I read in from a file instead of STDIN. Here's an example.

I do this programmatically because it's part of a custom menu item that allows people to look at their open tasks. I build the XML dynamically, because you never know who the user will be. Here's the perl code to do this:

my $tasks_infile = '/interwoven/iw-home/httpd/iw-bin/iwquerytasks.input';

open OUTFILE, ">$tasks_infile";
print OUTFILE <<END;
<taskquery>
<and>
<ownedby v="$user"/>
<active/>
</and>
</taskquery>
END

close OUTFILE;

# Get the active tasks for this user
my @active_tasks = `/interwoven/iw-home/bin/iwquerytasks < $tasks_infile`;

The resulting $tasks_infile looks like this, assuming the user ID is "dsmith":

<taskquery>
<and>
<ownedby v="dsmith"/>
<active/>
</and>
</taskquery>

What gets returned is a list of task IDs that are active for that user. You can take a look at the CLT manual for iwquerytasks for all DTD of the input format. Although it isn't documented very well with lots of examples, all you need to know is there. There's also a similar CLT called iwqueryjobs which does the same thing for jobs.


Dave Smith
Sr. Software Engineer
Nike, Inc.
(503) 671-4238
DavidH.Smith@nike.com

ONLINEHELP.jpg