Create query to return 3 records with number is anything

TerryC03
Tera Expert

‎03-08-2024 08:41 AM

Hello,

is it possible to return only three records with the query condition "number is anything"? For example, I have a script include the only returns three records for a report on a SAFe Team Dashboard with the SAFe Sprint table.

TerryC03_0-1709915473673.png

It returns three most recently updated records.

TerryC03_1-1709915700454.png

However, I'm using this with an interactive filter, "SAFe: Team" on the SAFe Team Dashboard (OOTB) and want to show a SAFe Team's 3 most recent updates. I'm thinking that changing the query to something like "All > SAFe Team >  Number is anything, Number is anything, Number is anything". 

 

Is this even possible? If so, how would I go about this? If not, is there another approach besides a script include I should take?

 

Thanks.

 

0 Helpfuls
  • 4,215 Views
1 REPLY 1

AshishKM
Kilo Patron
Kilo Patron

‎03-08-2024 08:50 AM

Hi @TerryC03 , 

In the shared screen shot, line no.7 gr.setLimit(3) , when this setLimit applied, query will return only that number of records. You can change the setLimit() parameter and test.

 

-Thanks,
AshishKM


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution
0 Helpfuls