Skip to main content
mdebower18-Opal
18-Opal
Jan 31, 2017 5:44 PM UTC
Solved

Is it possible to create a Query Builder report for a ProjectLink Routing?

My company has a need to create a report of routings being done in ProjectLink Projects.   Ideally we would like to report on the following:  (See Screenshots for examples.)

  • Routing Instructions
  • Participants in the routing
  • Participant Comments
  • Participant Votes
  • State of routing

 

Before I spend much time walking down a dead end, does anyone know if this can be done?   Or how would you approach solving the problem?

 

-marc

 

 

20170131-113727.png

 

20170131-113739.png

mdebowerAnswer
18-Opal
Feb 27, 2017 5:44 PM UTC

Well I submitted a case to PTC Tech Support and the answer that they came back with is....  you can't get the routing instructions into a QML report because that information is stored in the database blob.

Which was one of the main reasons we wanted the report....

So attached is the supplied PTC QML file that does everything BUT that.

Oh, well.

-marc

View in thread

4 replies

BineshKumar12-Explorer
2-Explorer
Jan 31, 2017 7:05 PM UTC

We had a requirement for a similar report,that was around a custom workflow. Between the below tables I was able to get most of the information I wanted. The output required some transformation, I was able to use the Cognos developer to present the data, the way the users wanted.

voting.jpg

Translate
    mdebower18-OpalAuthorAnswer
    18-Opal
    Feb 27, 2017 5:44 PM UTC

    Well I submitted a case to PTC Tech Support and the answer that they came back with is....  you can't get the routing instructions into a QML report because that information is stored in the database blob.

    Which was one of the main reasons we wanted the report....

    So attached is the supplied PTC QML file that does everything BUT that.

    Oh, well.

    -marc

    Translate
    BineshKumar12-Explorer
    2-Explorer
    Feb 27, 2017 7:00 PM UTC

    Sorry you hit that road block, routing instructions was not a requirement for us. Did you check with them whether it is possible using Java methods in Query Builder?

    Translate
      mdebower18-OpalAuthor
      18-Opal
      Feb 28, 2017 5:33 PM UTC

      Sorry Binesh,  I did not.

      -marc

      Translate
      Terms & ConditionsAccessibility statement