Summary
The QueryResult object provides access to the job query results returned by the queryJobs method.
Discussion
Each job and property can be accessed by index, iterator or defined field name.
Code sample
QueryResult example
The following script runs a job query and accesses query results.
import arcpy
import arcpywmx
# Establish a connection to a Workflow database
conn = arcpywmx.Connect(r'c:\test\Workflow.jtc')
# Run a query for jobs being assigned to current user. The query results are
# sorted by job name.
result = conn.queryJobs("JOB_NAME,ASSIGNED_TO", "JTX_JOBS",
"Job Name,Assigned To",
"ASSIGNED_TO = '[SYS:CUR_LOGIN]'", "JOB_NAME")
# To get total number of records being returned which are assigned to current user.
print("There are %s jobs assigned to me" % str(len(result.rows)))
# Access first row by index
print("The first value is %s" % str(result.rows[0]))
# Access first row's job name field by field name
print("The job name is %s" % result.rows[0]['JOB_NAME'])
# Access first row's fields values by iterator
row = result.rows[0]
for val in row:
print("Value is %s" % str(val))