Skip to main content
M
mdebower18-Opal
18-Opal
January 31, 2017
Solved

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

  • January 31, 2017
  • 2 replies
  • 3136 views

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

Best answer by mdebower

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

2 replies

B
BineshKumar11-Visitor
1-Visitor
January 31, 2017

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

    M
    mdebower18-OpalAuthorAnswer
    18-Opal
    February 27, 2017

    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

    B
    BineshKumar11-Visitor
    1-Visitor
    February 27, 2017

    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?

      M
      mdebower18-OpalAuthor
      18-Opal
      February 28, 2017

      Sorry Binesh,  I did not.

      -marc

      Terms & ConditionsAccessibility statement