Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Mybanner

This version of the app's documentation is outdated. Please find the information you're looking for here:



Panel
bgColorwhite
titleBGColor#f5f5f5
titleFiltering Table in Page Edit Mode

Table Filter and Charts for Confluence add-on allows you to filter your table data while you are editing it on the page. You can manage all the necessary filters while working with table data and filter it on the fly.

Starting from version 3.3.0 Table Filter and Charts for Confluence add-on supports filtration of table in the page view mode. It can be very convenient when you need to add modifications into multiple rows having one or multiple similar parameters.

Info

This functionality is not available for Confluence Cloud.

 


Note

For resolving the issue with the collaborative editing available since Confluence 6.0, please see our FAQ.



Adding Filters

You can add filters in two ways:

  • Standard - you can edit the macro settings as in old versions of the add-on.
  • On-the-fly - you can add filters as you get used to adding them in the page view mode.

All the filters saved in the macro body will be available for data filtration in the page edit mode.

  1. Click the first line in the macro body or click the macro body.
Image Removed
  1. Click Show filter. The filtration pane will be embedded into the editor panel.
  2. On the appeared
panel
  1. pane, click the
Add filter Image Removed icon
  1. cogwheel icon.
  2. Select the appropriate filter type and the column for filtration. The process of adding filters is quite similar
to Image Removed
  1. Click Add filter.
  2. To save the filter or filters, click the
Save settings Image Removed icon
  1. cogwheel icon.
  2. Click Save changes.
Note

All the filters added for table filtration in the page edit mode will be preserved in the page view once you save them through the filtration pane.


Note

When adding the Date Range Filter, you will have to edit the macro settings as usual and

enable the Date Range Filter and

specify the

required

correct date format.


Image Added



Filtering Table Data

  1. Select or specify the required values in the added filters. Your table will be filtered and only the matching values will remain.

Image Removed

  1. To save the selected or specified values as defaults, click the Save settings Image Modified icon.
  2. To reset the specified filter values, click
the
  1. the Reset all filters Image Modified icon.
Note

Once you have applied some filters to your table data, you may need to add new rows or correct the existing data.

All the made corrections or newly added rows will be preserved in the table if they match the defined filters. If they do not match the defined filters, they will be preserved in the table until you perform any action on the table through the native table management pane.


Image Added



Talk
idtalk-668
Optimizing Work with Table Data

Table Filter macro allows you to more efficiently work with table data with the following options:

  • sorting table one or multiple columns while holding the Ctrl key or Ctrl + Shift keys correspondingly
  • fitting a long table to the available screen area
  • enabling automatic row numbering

For the details on how to activate these options, see Managing Look of the Table and Filtration Pane.

All these options are available while working with the table data in the page edit mode

.

 

 

 

Transaction IDTransaction AmountFee AmountTransaction TypeService AgentTransaction DateCustomer TypeTransaction TypeCustomer ID592061126716.131.43Check CashingAshley Stone9/1/2015BusinessRejected2979CDBBE26575663556291096.8817.55Loan SettlementPeter Jacobs9/16/2015BusinessProcessed3792FFAFI271257717901854.750.11Money DepositGustavo Sanchez9/27/2015MixedRejected3731JGFIH2387587860150684.1310.95Mortgage LoansAshley Stone9/8/2015MixedPending3844BDIGH2763534767834264.253.70Loan SettlementChristine Palmer9/15/2015BusinessRejected2770GHCGB3756519995723689.7511.04Mortgage LoansGustavo Sanchez9/11/2015PersonalArchived1181CBGCC10575580939181237.757.43Loan SettlementPeter Jacobs9/15/2015BusinessPending3886FDHGF1518590598165770.139.24Money DepositChristine Palmer9/6/2015MixedProcessed2815BAJCJ2062584792520595.637.15Loan SettlementAshley Stone9/21/2015BusinessRejected2994ADJHE2204505178770759.381.52Loan SettlementGustavo Sanchez9/5/2015BusinessProcessed3083DDDIC35565454179331037.8810.38Check CashingAshley Stone9/24/2015MixedRejected3331EDCFC260152864418867.880.41Loan SettlementAshley Stone9/10/2015MixedPending2917FDJAF1201560357546158.751.91Mortgage LoansAshley Stone9/9/2015MixedArchived2658EBDCD1833566274679548.132.19Mortgage LoansChristine Palmer9/5/2015MixedProcessed1708EIGGI3227546197476811.384.87Check CashingGustavo Sanchez9/26/2015BusinessPending1759HBJED2704566257403916.007.33Money DepositGustavo Sanchez9/24/2015PersonalPending2382IBJIE1952513773675473.250.95Check CashingAshley Stone9/10/2015BusinessPending1900JEDGJ116652590138861.880.25Mortgage LoansAshley Stone9/15/2015MixedPending1713DEDJE24095881731661002.636.02Check CashingChristine Palmer9/16/2015BusinessRejected1789IBHIH2970531803759901.259.01Mortgage LoansGustavo Sanchez9/11/2015MixedArchived3801DICJI1006563125372252.504.04Mortgage LoansChristine Palmer9/26/2015MixedArchived2852CAFGB11355890234311052.0010.52Mortgage LoansChristine Palmer9/23/2015MixedArchived1522BAFHE3758532582219426.135.97Money DepositGustavo Sanchez9/21/2015PersonalArchived1931IBHBA3685599480798365.752.93Mortgage LoansGustavo Sanchez9/2/2015PersonalRejected3530IGGBB34655340805531217.8817.05Money DepositChristine Palmer9/19/2015BusinessRejected3981CBCBH22505136297941144.384.58Mortgage LoansAshley Stone9/9/2015PersonalPending1498GICHB3791540391774113.130.45Mortgage LoansChristine Palmer9/20/2015BusinessArchived2291AJFAJ164059761953369.880.70Loan SettlementGustavo Sanchez9/2/2015MixedProcessed1765DEACA13915525701341022.0016.35Money DepositChristine Palmer9/20/2015PersonalPending2832FJAFG27355110202841064.882.13Mortgage LoansGustavo Sanchez9/25/2015BusinessArchived2058DJIFH3475549848808391.752.35Check CashingGustavo Sanchez9/2/2015BusinessRejected3467DIAAG1771563158856286.881.15Mortgage LoansAshley Stone9/30/2015PersonalArchived3714GJJGH3685595627365475.383.80Mortgage LoansAshley Stone9/26/2015BusinessArchived2716JBAGG3338556182316270.003.78Money DepositChristine Palmer9/3/2015PersonalProcessed2980GCHIJ2342533711679200.881.21Loan SettlementChristine Palmer9/16/2015MixedArchived3223DEJDJ3980568769865150.500.30Money DepositChristine Palmer9/5/2015BusinessPending1433IBIHE2910573553435210.252.10Check CashingAshley Stone9/21/2015MixedProcessed1271GBDCI2950598765703522.382.09Check CashingGustavo Sanchez9/27/2015PersonalPending2821BEGFA29405225022211005.134.02Loan SettlementChristine Palmer9/6/2015PersonalArchived1644FAGEJ2771520979678333.130.67Check CashingGustavo Sanchez9/22/2015MixedRejected2436EFADH128355805818817.880.21Check CashingPeter Jacobs9/26/2015BusinessProcessed3167BDICE20625116104561146.132

.

29Check CashingPeter Jacobs9/30/2015MixedRejected2220EFICG11025536427131033.8812.41Mortgage LoansAshley Stone9/16/2015PersonalProcessed3634HFIEG182358335759057.250.46Money DepositAshley Stone9/26/2015PersonalPending3687IDGBA3224542964349124.380.75Loan SettlementPeter Jacobs9/3/2015MixedPending2561HJGAF1658502083681815.6314.68Mortgage LoansAshley Stone9/28/2015BusinessProcessed1267IFCGJ1334513162587409.507.37Check CashingPeter Jacobs9/3/2015BusinessRejected2304IIACA3483547506830899.5012.59Loan SettlementPeter Jacobs9/8/2015MixedRejected3027IGCIC1949525124816519.251.04Check CashingPeter Jacobs9/8/2015PersonalArchived1747JDEIG1270518784790908.3816.35Money DepositGustavo Sanchez9/29/2015PersonalArchived2332DCJHC33955116514901085.8817.37Money DepositAshley Stone9/4/2015MixedArchived3588DHEIE3407560119640575.008.05Mortgage LoansGustavo Sanchez9/13/2015PersonalPending3577DHBHJ1159531593051321.002.57Money DepositGustavo Sanchez9/27/2015BusinessPending3302IGDCI31965760982041165.2513.98Loan SettlementPeter Jacobs9/25/2015MixedRejected3158HDCAG1365543400468337.382.02Loan SettlementAshley Stone9/15/2015PersonalRejected3970CEEBF32375551522181110.504.44Mortgage LoansPeter Jacobs9/3/2015MixedProcessed2067HGHFB3334565842701108.501.30Loan SettlementGustavo Sanchez9/11/2015BusinessPending3305AFHAD34515353775391109.0011.09Money DepositGustavo Sanchez9/4/2015BusinessRejected1354GHCII209753546168214.250.14Money DepositChristine Palmer9/10/2015MixedArchived1137GAIFC332258595289046.130.55Money DepositChristine Palmer9/7/2015PersonalArchived1116JCCJG3744586131017203.880.82Check CashingAshley Stone9/13/2015PersonalPending2016EEJEH19435591790391167.0018.67Check CashingPeter Jacobs9/22/2015MixedRejected2511HIHAD2852536691888130.251.82Mortgage LoansChristine Palmer9/10/2015BusinessArchived1146HAEIC1756503015034859.1315.46Check CashingAshley Stone9/2/2015BusinessPending1571HFAIF1226548445950145.382.62Mortgage LoansGustavo Sanchez9/30/2015BusinessProcessed2123JGDEI1843504695366886.3815.95Loan SettlementPeter Jacobs9/12/2015BusinessProcessed1377CBIHC2129536044526457.251.83Loan SettlementChristine Palmer9/8/2015MixedPending2080HECFG366258716299955.880.56Loan SettlementChristine Palmer9/2/2015MixedPending3252DBEIE13005905001091130.1320.34Check CashingGustavo Sanchez9/13/2015PersonalPending3634BICFE1722557285085353.754.25Mortgage LoansGustavo Sanchez9/26/2015MixedArchived2376BFIDG2296573917691245.632.46Money DepositGustavo Sanchez9/14/2015BusinessPending1991JCHHF2879581267366452.882.72Loan SettlementAshley Stone9/28/2015MixedArchived1071FAHJB18795942133901083.6315.17Mortgage LoansChristine Palmer9/4/2015PersonalPending2907BIGGC3503525616009682.634.10Money DepositChristine Palmer9/9/2015BusinessProcessed1166CIDFB1393592349858619.503.72Money DepositPeter Jacobs9/30/2015BusinessArchived1472AJEBJ386558755069413.130.11Mortgage LoansPeter Jacobs9/12/2015MixedProcessed2171EHDBE1380585136995997.131.99Mortgage LoansChristine Palmer9/9/2015PersonalProcessed3951JBIGI23655476200811123.258.99Loan SettlementAshley Stone9/7/2015MixedRejected3224EAIFJ3064514925865404.381.62Loan SettlementChristine Palmer9/27/2015BusinessProcessed2014CHIFA32275474024351119.888.96Money DepositGustavo Sanchez9/13/2015MixedPending3871HBCFE2178565478704610.7510.99Mortgage LoansGustavo Sanchez9/13/2015BusinessPending3233HFBIB3700542263335140.250.28Loan SettlementChristine Palmer9/27/2015MixedPending2746HAAJG3815534805411941.1311.29Money DepositChristine Palmer9/2/2015PersonalPending1147AEJIH3256539494191742.884.46Loan SettlementAshley Stone9/26/2015BusinessRejected2528DBBGB3736503928121748.2511.97Mortgage LoansPeter Jacobs9/19/2015MixedArchived1564AHBBG1504598853712174.880.35Loan SettlementPeter Jacobs9/13/2015PersonalRejected1536CIGGC10295955601601114.6311.15Loan SettlementGustavo Sanchez9/12/2015BusinessProcessed3721IGCHF2489508241767944.2511.33Mortgage LoansChristine Palmer9/14/2015PersonalProcessed3250DDCEE3891577016511493.386.91Loan SettlementAshley Stone9/8/2015MixedPending3509BGGCJ3385559247478220.503.97Mortgage LoansAshley Stone9/15/2015PersonalArchived2562AJHEJ1897516354344372.383.72Loan SettlementGustavo Sanchez9/27/2015BusinessRejected1064GDGAB265857223963933.000.20Money DepositPeter Jacobs9/2/2015BusinessArchived3445EEFCG111353084622126.250.47Check CashingGustavo Sanchez9/18/2015BusinessPending1027HHICJ2856587730080562.502.25Money DepositGustavo Sanchez9/4/2015BusinessRejected1144EHDDE3292586836659322.002.58Check CashingChristine Palmer9/22/2015MixedRejected3628IAJHB2504568739279597.258.36Check CashingGustavo Sanchez9/9/2015BusinessPending1686CFHCD1661548535751493.754.94Check CashingChristine Palmer9/10/2015PersonalArchived2317EGHDJ3176562857665629.633.78Money DepositGustavo Sanchez9/9/2015MixedProcessed2646JHCCF118053269812860.000.84Loan SettlementChristine Palmer9/10/2015PersonalPending3420BBCCA21995936752491132.2513.59Money DepositChristine Palmer9/16/2015BusinessPending1951DDCAI2125