Sorting / Filtering Multiple Values from a Single Table Excerpt Include

Scott Dyer February 21, 2024

Is there any way to filter a table excerpt include that contains multiple elements from different pages?

e.g. I have 5 pages, all that have a "table excerpt" macro called "last_run_date"

 

On another page I use the "table excerpt include" macro looking for a macro called "last_run_date" across parent + all child pages which includes all those 5 pages and I get an outcome like:

 

08/10/2023

10/11/2023

11/11/2023

02/01/2024

20/02/2024

 

Which makes it seem like the one macro pulls the data for all of those individual macros and just adds them together. It also seems to do it in order of the oldest page to newest page such that the most recent is at the bottom.


What I really want from that list is just the last date. Is there any way to do this? I've tried putting the data into a table cell and filtering or transforming but even like

select T1.max(last_run_date) from T*

errors. I guess due to the fact that it's a single row with multiple values rather than multiple rows. It would be really great to only get the latest value... is it possible?

1 answer

1 accepted

3 votes
Answer accepted
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 21, 2024

Hi @Scott Dyer ,

Sorry, didn't quite got the case - these five dates are pulled from five different pages, you ticked the "Show as a report" option in the Table Excerpt Include macro and now on the master page you see smth like this:

Wed 5-1.png

But you want to show not the whole table but the row where the date is the latest? 

What do you mean that "it's a single row with multiple values rather than multiple rows"? It contradicts with the first part of your question.

Maybe you can give us a screenshot of your tables within the Table Excerpt macro and what you get after the Table Excerpt Include macro.  

Scott Dyer February 21, 2024

Your reply was helpful, it made me realise that in trying to test using this as a solution, I wasn't putting the initial data into a table, it was just text. 

Once I put the data into tables, even tho they have the same name they just become rows in table with the same column heading and I'm able to transform them correctly.

Thank you!

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events