Working With Custom Queries

Job Manager provides extensive search functionality to make the information stored in the database available to users of the system. However, at times this standard search functionality may not meet the needs of you or your users. To accommodate this, Job Manager provides unique Custom Query functionality, providing you with the capability to create robust queries of the database for information not normally accessible through other means.

Consider the following example. One of the employees from the production department of your company might be responsible for ordering ink supplies needed for all open jobs. The information on ordered ink for a job is stored in the Preflight Analysis document attached to the job. By searching, the user can get a list of all open jobs and a list of all Preflight Analysis documents where the Ink Ordered status is not specified.

Job Manager provides the ability to use Custom Queries to extend the standard searching and reporting capabilities of the system. Using a Custom Query in the above example, it is possible to create a search for all open jobs (instances of the Jobs folder type) whose attached Preflight Analysis documents (instances of the Preflight Analysis document type) have empty Ink Ordered fields.

Generally speaking, creating a Custom Query is a matter of defining the underlying SQL query on the administrative level and making the query available to the end users of Job Manager.