Query builder - Maximum

Forum|Forum|4 years ago
November 16, 2021
1 reply
3355 views

Hi

What is the right way to retrieve the Maximum (Last modified) date in Query builder?

I have tried this option (see picture) but didn't succeed

Thanks

Ilan.M

Reporting

Best answer by joe_morton

Here's an example of using the Max function. I believe you can only use it in a Subselect.

This query will return info on the Part with the highest value for "Persist.Info.Object.Identifier.Id"

joe_morton

18-Opal

Maximum doesn't really work that way. You can return the maximum value for a number value, but not for a date.

If you just want to get the last modified version of a document, you can use a subselect to get the latest revision, and add the criteria to get the latest iteration. Since you have the latest version that typically should be the last modified of the document.

If you wanted to be more sure to get the latest modified (again, I'll use a document as an example), you could do a subselect and return the maximum object persist ID. I believe Windchill assigns these numbers sequentially, so the maximum you get will be the most recent created.

Hope that helps!

I

Ilan_Mor

Author

11-Garnet

Hi Joe

I'm trying to understand how to use the Database function, so I tried to display maximum of 'Height' (defined as Real Number) ,but I got an error message (see attached picture).

What am I doing wrong?

thank you

Ilan .M

joe_morton

Answer

18-Opal

Here's an example of using the Max function. I believe you can only use it in a Subselect.

This query will return info on the Part with the highest value for "Persist.Info.Object.Identifier.Id"

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded