Skip to main content
G
gbalestrieri1-Visitor
1-Visitor
April 3, 2015
Question

how to export job monitor table in a file

  • April 3, 2015
  • 1 reply
  • 1299 views


We need a report of the current pubblications. The best option would be an export of the Job Monitor table:

JobMonitor.png

As the export in a file is not a provided function, waiting this function will be added, I ask if someone can help me to write a query that join the QUEUEENTRY table to obtain the same info of the Job Monitor.

I haven't idea on the other table and which are the keys to join tables.

Tanks a lot.

1 reply

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
April 3, 2015

Giovanni,

mi verrebbe voglia di scriverti in italiano, ma gli atri non capirebbero.

Take a look at this article from TS https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS23768&lang=en

Also you can read this document I wrote, with a lots of query builder already done Resource for reporting

Marco.

Marco
G
gbalestrieri1-VisitorAuthor
1-Visitor
April 3, 2015

Thank you Marco.

I start to look to QueryBuilder and try to create a new report but I don't understand how relate EPMDocuments with their publication queue.

I open a new report and first I add the class EPM Document after I don't see any class to match the object in the Job Monitor; there are some classes of wt.Queue but I don't find the right one.

QueryReport.png

Do anyone knows the class I need or have a documents that explane all the classes listed in the query builder?

Tank you all.

Giovanni

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
April 3, 2015

Giovanni,

take a look at this Getting query to return even with null (empty) valued attributes

I post a comment on how to search join between windchill types.

Happy Easter / Buona Pasqua

Marco

Marco
Terms & ConditionsCookie settingsAccessibility statement