Community Forums
Results 1 to 3 of 3

Thread: WFM: Custom SQL Query Report

  1. #1
    Join Date
    Mar 2014
    Posts
    2

    WFM: Custom SQL Query Report

    To any one who can help:

    I currently manage a team of packagers within Flexera's Workflow Manager and I would like to create multiple reports using the custom SQL Query Report type within Report Center to streamline my reporting process. I am looking to create a couple of reports. I would like to pull all the applications that are in an ON HOLD status for a particular project. The following column names I would like the report to show are:

    Project Name, User Name, Application Name, Status, Issue Date, Issue Owner


    The other report I would like to illustrate are the issues in more detail. I would like to show the following fields and be able to see all my packagers. The fields I would like to report on are:

    Issue Abstract, View/Respond, Attach File, Application Name, Issue Type, Issue Date, Created By, Owner, Issue Due Date, Issue Message Text

    Name:  Columns.JPG
Views: 210
Size:  23.3 KB

  2. #2
    Join Date
    May 2010
    Location
    Rochester, NY
    Posts
    51
    I'm not sure what you're asking. Are you trying to figure out which fields to select for the report data?

  3. #3
    Join Date
    Aug 2017
    Posts
    8

    WFM Custom SQL Query Report

    Hi Phil

    I am using PL/SQL Developer to run the query and all I get is the column headings when I execute, but no data

    rgds

    Norman

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •