Feature request: first() and last() aggregations

Product Suggestions
1

I would like to have a table aggregation “first” (and “last”) that obeys whatever sort order I put on the underlying query. Is this a reasonable request?

2

Hey @wz2b,

One way that we occasionally use to do this is to just add a limit of 1 record to the query, this will return just the first record. Do you have a usecase where this wouldn’t work?

Pete

3

Maybe. Or perhaps I just don’t know how to do it. I’m trying to take that ONE RECORD that matches the query (there should only be one) and put it into a record placeholder.

4

Here is a little more detail on how I would do this

Query-
Just sorting by most recent, limit of 1.

image
image3816×448 60.5 KB

Aggregation-
Return Unique IDs
image
image1682×1116 56.3 KB

Query and then aggregation added to app

image
image504×618 21.7 KB

Save the aggregation to an array, pop the only ID from that array, load record.

image
image3082×1558 217 KB

Does that make more sense?
Pete

5

Yeah. Thanks for walking me through that step by step.

6

To be fair, I forgot an aggregation was needed too! Would have explained it more initially if I remembered this detail!

Glad we got it sorted!
Pete