nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get table id filtered by Table Filter from HTML page source?

Aster_quvcb3

I am trying to use HTML macro to extract data from "Confiforms TableView combined with Table Filter" macro and show the content in plain text to serve as a table summary.
Like, we have a table of everyone's expense (filtered in some condition), and we'd like to be able to put a sentence like: "UserA spent the highest amount in last month."

However, seems like the table id in the page source is not fixed, and it changes every time when the page is refreshed. And I tried using "data-cf-form", but it will return unfiltered data.

Wondering if there's a way to come out the summary sentence?

Thanks!

Accepted answers

Stiltsoft support

Hi @Aster ,

Not sure if we got your ticket in our JSM or maybe it was some other customer (we got a similar question there), so I duplicate some hints here for other people to see if they come across this question: you may try to find your table and get the required data as plain text using javascript

tfTableSelector = "table.tf-macro";
document.querySelector(tfTableSelector).innerText;

In your script you need to specify the tfTableSelector, and the innerText option returns all the data, even the filtered out rows.

Note that our app also doesn't set or change any table IDs and table data.

And maybe this hint may come in handy - you can find and show specific cells as plain text using javascript and Table Transformer macro:

Mon 2-1.png

SEARCH AS @Cells RETURN(@Cells->[1]->key) FROM T1;

Mon 2-2.png

Hope this helps your case.

All comments

Alex Medved _ConfiForms_

Cannot tell much about the "table id", as this does not sound like something from ConfiForms app... but to approach your problem I would try to use the ConfiForms ValueView to get the aggregated and filtered number. I believe that should work

Or a separate TableViewMerger macro to show aggregated numbers

Alex

Aster_quvcb3

Hi @Alex Medved _ConfiForms_,

By "table id", I mean the one that can be found in the page source. We are trying to capture the data in a filtered TableView macro, and put them in plain text as summary using HTML codes. Is there a example that ConfiForms ValueView might also be able to do that? Thanks!

Alex Medved _ConfiForms_

If you need something unique and constant you can add a "class" to CSS parameter

Something like

class:iamunique

And then access the table using the class, AJS.$('.iamunique')

Alex

Aster_quvcb3

We can get the unique class from your suggestion. Thanks.

However, it will return the whole table instead of the filtered one...

Would you help to provide some suggestion on how we can capture part of the filtered table and put them in plain text as summary?

Stiltsoft support

Hi @Aster ,

tfTableSelector = "table.tf-macro";
document.querySelector(tfTableSelector).innerText;

In your script you need to specify the tfTableSelector, and the innerText option returns all the data, even the filtered out rows.

Note that our app also doesn't set or change any table IDs and table data.

And maybe this hint may come in handy - you can find and show specific cells as plain text using javascript and Table Transformer macro:

Mon 2-1.png

SEARCH AS @Cells RETURN(@Cells->[1]->key) FROM T1;

Mon 2-2.png

Hope this helps your case.

Aster_quvcb3

Hi @Stiltsoft support

yeah I am the one asked this question in your JSM. For the first solution, using tfTableSelector, I just can't figure out which element I should use to get the filtered table. I think I will just give up on this...

The second solution is great! But if I'd like to add some words in front of the search result, like "Here is 2 - we want to find this cell." And combine 2 search results, like "2 - we want to find this cell and 1,2,5." Could you advise how to get them by Table Transformer?

Thank you!

Stiltsoft support

Hi @Aster ,

You may try the following SQL query:

SEARCH AS @Cells RETURN
(@Cells->[1]->key AS 'Some comment 1',
@Cells->[1]->Platform AS 'Some comment 2')
FROM T1;

Mon 3-1.png

Or if you want to have several entries as plain text, you may reuse your source table several times with the help of the Table Excerpt/Table Excerpt Include macros and use several Table Transformer macros with the queries from the previous answer.

So, you just manually type your description (for example, "Some comment 1") and then extract the required info using the Table Transformer wrapped above the Table Excerpt Include macro.

Aster_quvcb3

Hi @Stiltsoft support

Can I simply add a few words, like "Here is", in the plain text result?

I am asking because the result I get now will be in the new line, so it doesn't look like a complete sentence to users, which makes it weird...

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

filter

table

confiforms