Skip to main content
C
CB_96405611-Visitor
1-Visitor
May 19, 2025
Question

Are the Report Builder Database Functions restricted based on roles, permissions or other?

  • May 19, 2025
  • 2 replies
  • 774 views

I am trying to use the Maximum Database Function in Report builder to get the highest revision and version, as mentioned in this support article: https://www.ptc.com/en/support/article/CS27872

 

The function does not show in the list of available functions for me. Our System admins can see all of the functions and use them but I can not as an Org Admin or Product Manager, I see only a subset of the functions. I also can't successfully run a report that the admin used the Maximum function on.

 

The windchill help center pages mention all the available functions (https://support.ptc.com/help/windchill/r12.1.2.0/en/#page/Windchill_Help_Center/querybuilder/QBSelectOrConstrainDatabaseFunction.html#) and  i do see some of them, just not all of them and i haven't found mention anywhere that these can be restricted based on role or access control rules.

 

I've searched around on the topic a bit, but have not found much info on this issue. 

2 replies

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
May 19, 2025

Take a look at this article

 

QML Database functions such as Maximum or Minimum are missing in Windchill

 

 

Marco
C
CB_96405611-VisitorAuthor
1-Visitor
May 19, 2025

So its a hardcoded restriction that couldn't be modified other than granting Site Administrator access to the user creating the report? 

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
May 20, 2025

You can get the answer to your question directly from PTC support.

Just press on the button at the bottom of the article

Marco_Tosin_0-1747723070638.png

On the next screen select the choice that is most relevant to what you want to ask and do so in the box below the choice.

A support engineer will answer your question

 

 

Marco_Tosin_1-1747723101424.png

 

 

Marco
D
DmitryC14-Alexandrite
14-Alexandrite
May 21, 2025

This issue has 2 parts:

1. Creating report templates

2. Using report templates.

 

I can't really help you with 1st part. You can try creating report templates on a test server, where you can give more people admin rights.

 

With using reports like this - there is a workaround. You can add new reports to the list of the OOTB templates and Windchill won't check if users have rights to use them.

You can find this list 'OOTB_ReportTemplates_advanced.xml' in '\codebase\registry\wt\query\template\' folder.

DmitryC_0-1747795358124.png

 

Regards,

Dmitry

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
May 21, 2025

There is also this article that could help

 

Non-site admin users unable to edit or generate a report from a report template with "Bypass Access Control"

 

I used option 1 among the solutions proposed by PTC.

 

Instead of entering each individual report into the list, simply create a new site-level group and enter the users who need to see or edit the report.

 

 

 

Marco
Terms & ConditionsCookie settingsAccessibility statement