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

[Candice]

Hi Atlassian Community

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

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?

[Katerina Rudkovskaya _Stiltsoft_ · Accepted solution]

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:

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

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.

[Candice]

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

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?

[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.

[Candice]

Thank you, Support! This is what I was looking for - I've tested it out and it works! Thank you very much!

[Candice]

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:

Edit view of my page:

[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]

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]

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]

Glad you've found a working solution!  

[Candice]

Is there another way to do this without doing the method I used?

[Stiltsoft support]

Think that your question was fully solved by the regular expressions in the filter, but nevertheless.

There is no any option to exclude pages from the Table Excerpt Include macro automatically (typing its name in some special list or smth).

The only options are the workarounds that we've mentioned before: using labels and filtering certain pages out by their titles.