QueryResult

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))