Table filter options

[KPV CAPITAL]

Hi, I have multiple columns in the table filter and I am looking to add different kinds of filter for each field automatically using the html

<ac:structured-macro ac:name="table-filter">

    <ac:parameter ac:name="numberfilter">

GROUP1, GROUP2,GROUP3

<ac:parameter>


I need GROUP2 and GROUP3 to be dropdown and free text filters and also introduce a hidecolumns into the html I am importing into confluence. 

Can you please suggest how this can be done

Thank you!

[Nikita Kamai]

Hello,

This is Nikita of Table Filter, Charts & Spreadsheets team.

The filters can be added as follows via page storage format manipulations -

<ac:parameter ac:name="hideColumns">true</ac:parameter> - for Hide Columns filter

<ac:parameter ac:name="column">GROUP2</ac:parameter> - for Dropdown filter

<ac:parameter ac:name="userfilter">GROUP3</ac:parameter> - for Freetext filter

<ac:parameter ac:name="numberfilter">GROUP1</ac:parameter> - for Number filter

Overall, a simple macro insertion layout looks as follows - 

<ac:structured-macro ac:name="table-filter" ac:schema-version="1" data-layout="default">

<ac:parameter ac:name="YOUR FILTER TYPE">COLUMN NAME(-s, if plural, should be added via comma)</ac:parameter>

<ac:rich-text-body>

Your table layout here

</ac:rich-text-body>

</ac:structured-macro>

Hopefully, this helps.

Best wishes,
Nikita