Query Reports with SQL

[STEVEG]

Last October we upgraded from PDMLink 10.1 to 11.0 and also switched from Oracle to SQL.  Now, many of my reports don't work anymore.  I don't know if it's because of the new version or because of SQL but it's very maddening.

On one of my reports I get a message: ERROR: A statement with aggregate function can not be used with access control.

I have no idea what that means.

This was a simple report that let me know the last time a user logged in.

I used the Audit Record table.

The Selects are User Name and Event Label.  Then I put a Maximum on Persist Info.Created On.

This last Maximum is the problem but I don't know how to fix it.  Anyone have any ideas?

[Marco_Tosin]

Hi Steve,

have you already looked at help guide?

Search for database functions.

As you will see there are many differences between the same function as written in Oracle or in SQL.

[STEVEG]

Thank you Marco.  I will take a look.

[Marco_Tosin]

If your problem is what I think, this idea could be a solution.

https://community.ptc.com/t5/Windchill-Ideas/Possibility-to-load-SQL-statements-in-Query-Builder-Report-in/idi-p/460592

Knowing the syntax to create an SQL command, you could export the query created with Oracle, adapt it to SQL and import it back into the query builder.

[STEVEG]

It might for someone that knows the language.  But I don't know SQL/Oracle much.  I was able to get by creating reports.

[Marco_Tosin]

Same for me.

But if you want, you can still vote for the idea. 

[STEVEG]

Done.  🙂