Hello, Im working with SpiraTestEntities.R_HistoryChangeSets table and would like to output only latest hisoryChange record for each requirement/test set. I was trying to find information about how to use window function with Entity SQl but have found nothing. Looks like it is not supported. Is there any workaround in Spira to use window functions such as ROW_NUMBER() or DENSE_RANK()? Best Regards, Andrii en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/2039.aspxthreadId=2039Andrii Bilous (andrii.bilous@edetek.com)custom report Hello, Im working with SpiraTestEntities.R_HistoryChangeSets table and would like to output only latest hisoryChange record for each requirement/test set. I was trying to find information about how to use window function with Entity SQl but have found nothing. Looks like it is not supported. Is there any workaround in Spira to use window functions such as ROW_NUMBER() or DENSE_RANK()? Best Regards, Andrii Wed, 05 Jun 2019 04:32:20 -04002019-06-07T17:55:57-04:00/Support/Forum/spirateam/reports/2039.aspxmessageId=3607Jim R (donotreply5@kronodesk.net) Hello, That is a good question, please use TOP(x) like this: select value top (2) R from SpiraTestEntities.R_Incidents as R where R.PROJECT_ID = ${ProjectId} OR with specific column names: select top (2) R.INCIDENT_ID, R.NAME from SpiraTestEntities.R_Incidents as R where R.PROJECT_ID = ${ProjectId} Regards Jim Fri, 07 Jun 2019 17:55:57 -04002019-06-07T17:55:57-04:00/Support/Forum/spirateam/reports/2039.aspx#reply3607