11-Garnet

Solved

Query builder - Maximum

3 replies
3424 views
Translate All

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

joe_mortonAnswer

19-Tanzanite

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

19-Tanzanite

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!

Translate

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

Translate

joe_morton

Answer

19-Tanzanite

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"

Translate

Query builder - Maximum

3 replies

Windchill Satisfaction Survey

Take the Survey ↗

Windchill Satisfaction Survey

Take the Survey ↗

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.