How to show last record from each table in table merger?

[Ute D_Agostino]

I have about 40 confluence sites which contain a status table view each. Each table is merged to another site (status overview) by the Confiforms TableViewMerger makro.

It works so far, as it shows all entries of all 40 tables. But as you can imagine it bloats the table to the point of illegibility. Therfore I want the TableViewMerger on the status overview site to show only the latest record from each of this 40 tables of each site.

As each record in each table has a sequential number, I've tried to sort them asc and tried to filter in table merger for latest number, but it doesn't worked like this.

Could you please assist?

Thanks

[Shikha Verma · Accepted solution]

Hi @Ute D_Agostino, Welcome to the community!
Try the sequential number in descending order (sortField="sequential_number:desc").
Use the limit=1 parameter in the TableViewMerger macro to show only the topmost (latest) record from each table and then Configure the Merger. 

[Ute D_Agostino]

Hi @Shikha Verma 

Thanks for responding. I've tried this already before asking, but it doesn't worked as I tried to sort in the Table View Makro on each page instead of in Table View Makro linked within the TableViewMerger Makro.

Your way shows exactly what I was looking for.

Many thanks!

[Shikha Verma]

You're Welcome @Ute D_Agostino