Return top X results from Query Builder report

Forum|Forum|1 year ago
December 19, 2024
2 replies
587 views

Version: Windchill 13.0

Use Case: I have a query that can return thousands of results but only need to see the first 10 to 20 based on sort order.

Description:

I can return the top 10 results in TSQL with:
SELECT TOP 10 {column} ... ORDER BY {column} DESC
Can we do this with Query Builder?

Reporting

Best answer by avillanueva

https://www.ptc.com/en/support/article/CS424612?source=search

Looks like not supported.

avillanueva

Answer

23-Emerald I

https://www.ptc.com/en/support/article/CS424612?source=search

Looks like not supported.

avillanueva

23-Emerald I

Hmm, if we had the ability to display the row number, it would be possible to put a condition that shows row numbers less than a value. ROW_NUMBER() or ROWNUM is a function but not one that is listed. I tried using it as a constant and it did not like it. No way to trick it to reading it like pure sql.

R

RandyJones