Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Create query to return 3 records with number is anything

TerryC03
Tera Guru

‎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,437 Views
1 REPLY 1

AshishKM
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