Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Table Transformer Macro - Show All but One Column - Hide Columns

I have a very large table, containing several dozen columns and would like to hide one or two columns using the Table Transformer macro.  The only way I know how to do this is to:

SELECT 'header 1', 'header 2', etc. for each column.  Is there an easier way to do this?

I would like to avoid using the table filter macro to hide these columns- why?  Because I have some UI buttons that I am using to filter the table (once my hidden columns are removed).  And if I have an embedded filter within a filter, the filter query breaks and my buttons do not work.  I find that if I can get the table transformer to filter the columns, then the filter macro with UI buttons works perfectly!  Sorry if this is confusing - I can provide more information / images if needed.

Thanks!

Emily

1 answer

1 accepted

Hi @Emily Berg ,

You are right: there are two ways to hide columns.

The first one is not to list the header via the Table Transformer macro.

The second one is to use the Table Filter macro. You can hide columns inside the first (internal) Table Filter macro and hide the filtering panel for your colleagues not to change this setting. The second (external) Table Filter macro can be used strictly for filtering - here you may use predefined filters on the filtering panel, copy filters' URLs for your colleagues, etc.

The only moment we couldn't get is about the UI buttons - what do you mean by them? Maybe you can provide us with some screenshots and a brief summary?

Hi @Katerina Kovriga _Stiltsoft_ ,

I have a page with a large table and I would like to auto-filter for various groups within my team.  So I have added UI Button Macros to the page - goal being that I establish the filters in the Filter Table macro, copy the URL, and apply the URL to the UI button.  When you click the UI Button, it establishes the filtered table.  I have multiple buttons, including one to "clear" the filter and go back to the default table view.

It works beautifully when I use the Table Transformer to initially hide columns that I never want to be able to see.  Then I apply one Table Filter to the remaining table, establish the views, copy the URLs and apply to the button.  But as mentioned in my originally post, this is a very strenuous process because the table is large and selecting all columns to view is difficult - hard to manage if I continue to add / remove columns.  It would be easier if I could select columns to hide or even remove / delete from the table.

I have tried the two Table Filter approach - one embedded that always hides the columns of interest and hides the control panel - then a second that hides the remaining columns of interested depending on which button you click, essentially the global global.  I copy the URL of the filter and apply it to the buttons.  Usually the first click works, but if I click a different button with different set of filters, not all of the columns show, and sometimes the hidden columns from the first macro appear...it doesn't work!

I hope that helps explain the problem.  Any suggestions?

Emily

Hi @Emily Berg ,

We know about such behavior: sometimes our customers use the one URL to filter several similar tables wrapped in the Table Filter macros and located on the same page.

In such cases the URL applies to several Table Filter macros (the same is happening for you: the internal Table Filter begins to show hidden columns).

So, I've added your case to our backlog and created a ticket - I'll get back here when there is an improvement.

Like Shannon likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Marketplace Partner Spotlight: Fine Software

Happy New Year, everybody! What better way to kick off 2022 than with a new Marketplace Partner Spotlight ✨ This month, we're getting to know Daniel Franz, co-founder of Fine Software. Fine Software ...

369 views 2 15
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you