How to export Job Types, Descriptions, Accounts and Sub-Accounts from DFWorks

Product Feature: Job Type Enrollment

Operating System: Windows Server 2003 / Windows Server 2008

Database: Oracle 9i / Oracle 11g

Configuration: All

DFWorks does not allow users to export Job Types and their descriptions and associated accounts and sub-accounts from the DFWorks web page. The following query can be run from SQL Query Editor in the DFWorks web page and exported as a CSV file:

SELECT JT.JOBTYPEID AS "Job Type Name",
JT.DESCRIPTION AS "Description",
AC.DISPLAYSTR AS "Account|SubAccount"
FROM JOB_TYPE_INFO JT,ACCOUNT AC
WHERE JT.ACCOUNTIDFK=AC.ID(+)
ORDER BY JT.JOBTYPEID

UPDATED: November 20, 2017