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; } } }

Multiple words in "Filter whole table" with Table Filter macro

Candice_oc81dt

Hi Atlassian Community

How do you use the Filter whole table part of the Filter Table macro?

Filter whole table.PNG

I am using a Table Transformer where users are inputting free format text in multiple cells. I'd like to display information that does not show certain words/phrases, ie "pulled", "parking lot", and "on hold".

However, I cannot add multiple words into the filter.

Eg. Row 1 will have the word "pulled" and will not display.

When I add "parking" to the filter [ pulled, parking ], Row 1 is displayed.

Am I not using this feature correctly?

Accepted answers

Katerina Rudkovskaya _Stiltsoft_

Hi @Candice,

Yes, you use the “Filter whole table” option correctly. The option to use AND/OR operators is active for other filter types, for example, a dropdown.

As you need to find several “parts” of text and then hide the corresponding rows, you may use the Table Transformer macro:

Wed 4-1.png

SELECT * FROM T*
WHERE 'Project' NOT LIKE "%AM%" AND 'Project' NOT LIKE "%BM%"
AND 'Data' NOT LIKE "%a3%"

Wed 4-2.png As you can see, here we show rows that don’t contain “AM” or “BM” in the ‘Project’ column and “a3” in the ‘Data’ column. As a result, only the 4th row is present.

All comments

Candice_oc81dt

Alternatively, is there a way to exclude a page from Table Excerpt Include?

I have a page called 2023 Release. There are child pages for each month AND a "Pulled/Parking Lot" page. Each month and "Pulled" page contains multiple pages for projects.

I'd like to exclude the "Pulled/Parking Lot" page.

Table Excerpt Include settings:

Table Excerpt Include.PNG

Edit view of my page:
Edit View.PNG

Katerina Rudkovskaya _Stiltsoft_

Hi @Candice,

Yes, you use the “Filter whole table” option correctly. The option to use AND/OR operators is active for other filter types, for example, a dropdown.

As you need to find several “parts” of text and then hide the corresponding rows, you may use the Table Transformer macro:

Wed 4-1.png

SELECT * FROM T*
WHERE 'Project' NOT LIKE "%AM%" AND 'Project' NOT LIKE "%BM%"
AND 'Data' NOT LIKE "%a3%"

Wed 4-2.png As you can see, here we show rows that don’t contain “AM” or “BM” in the ‘Project’ column and “a3” in the ‘Data’ column. As a result, only the 4th row is present.

Katerina Rudkovskaya _Stiltsoft_

What concerns your question about the Table Excerpt Include macro, you may just use page labels and collect your Table Excerpts using a specific label. Any page that doesn’t have this label won’t be searched for an excerpt.

Or you may choose to show page titles as meta data and later filter out unwanted pages by their titles.

Also, from your screenshot it seems that you use your Table Transformer macro to merge your tables into one report, but you may just tick the “Show as a report table” option inside the Table Excerpt Include macro.

Candice_oc81dt

Hi Katerina.

Thanks for your responses.

1. Unfortunately, using labels will not be feasible as some of the users will forget to add it - there are 200+ pages that I would have to go through to see if labels have been added. I've read that the feature to copy a parent label onto child pages is not possible at present.

2. Thanks for the tip on "Show as a report table". I'll play around with this.

Candice_oc81dt

Here's an example of what my table looks like:

Data Table.PNG

The words "pulled, hold, and parking lot" are mentioned in multiple columns. Would I need to write the SQL query for ALL the columns? Is there a way to write the SQL query to read the whole table for these phrases and filter them out?

Candice_oc81dt

After playing around with the macros, I came up with a different solution to exclude data from a specific page.

I selected "Parent page" under "Show page metadata". Then in my table filter, I used the "Filter whole table" function and typed in the name of the page (as a reversed filter).

Stiltsoft support

Yes, you are correct - you should list all the columns that you want to check in the SQL query.

Stiltsoft support

Hi @Candice ,

An update from our developers regarding the "Filter whole table" option: you may use regular expressions for your filter.

The "OR" option looks like "|": pulled|parking|hold for your case.

Welcome!

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

Quick Links

Find more posts tagged with

confluence

filter

table

unknown-hosting-type