Table Filter and , Charts & Spreadsheets for Confluence add-on app allows you to filter the data presented in tables. Data filtration can be applied to one or several columns at a time. Just paste your table into the Table Filter macro and set the required columns for filtration. Besides table data filtration you can create dynamic charts and generate a pivot table with summarized and aggregated values with the capability to manage their settings while viewing Confluence pages.
| Iconbutton |
|---|
| Title | Documentation |
|---|
URL | https://docs.stiltsoft.com/ |
|---|
|
| dc-server/welcome-to-table-filter-charts-spreadsheets-for-confluence-42239760.html | | name | Documentation |
|---|
| width | 200 |
|---|
|
| Handy Button |
|---|
| blank | true |
|---|
| color | Blue |
|---|
| link | https://marketplace.atlassian.com/apps/27447/table-filter-charts-spreadsheets-for-confluence?hosting=datacenter&tab=overview |
|---|
| name | Try App for Free |
|---|
| width | 200 |
|---|
|
Please select the macro you want to master and proceed to the corresponding page for training.
Image Added
Table Filter macro allows you to filter any type of table data with the available set of filters. Different types of filters can help you filter records listings, financial reports, tables containing dates and media assets.
Image Added
Table Spreadsheet macro allows you to add Excel-like spreadsheets. You can work with them both in the page view and page edit mode.
Image Added
Chart from Table macro allows you to create dynamic and visually appealing charts on Confluence. A variety of avalable charts types can help you present your table in the way you want and like.
Image Added
Pivot Table macro allows you to summarize your data or aggregate it against the specific parameter. It can help you to cope with the tables containing repeated values so you can quickly count, sum or get the average, minimal or maximal values for a specific parameter.
Table Filter and Charts for Confluence
| Button |
|---|
| Title | Download Add-on |
|---|
| URL | https://marketplace.atlassian.com/plugins/com.stiltsoft.confluence.plugin.tablefilter.tablefilter?utm_source=demo&utm_medium=referral&utm_content=tf-landing-download-button&utm_campaign=table-filter-traffic-sources |
|---|
|
| Button |
|---|
| Title | Submit Idea |
|---|
| URL | https://stiltsoft.customercase.com/forums/support-requests/ideas/create?utm_source=referral&utm_medium=demo&utm_content=table-filter-space-page&utm_campaign=table-filter-traffic-sources |
|---|
|
| Button |
|---|
| Title | Report Issue |
|---|
| URL | https://stiltsoft.customercase.com/forums/table-filter-for-confluence/ideas/create?utm_source=referral&utm_medium=demo&utm_content=table-filter-space-page&utm_campaign=table-filter-traffic-sources |
|---|
|
Try the following use cases:
See the following pages for details on advanced usage of Table Filter and Charts add-on and check its compatibility with other add-ons and macros:
Parameters
The add-on adds the Table Filter macro. You can add this macro onto your Confluence page and further paste one or multiple tables into its macro body. You can also insert the macros that generate the table data. The following parameters are available to you:
| Parameter | Parameter Name | Default | Description |
|---|
| column | Dropdown Filter Columns | | The columns by which the table should be filtered. While using filters by several columns simultaneously, their names should be divided by comma. |
|---|
| userfilter | Free Text Filter Columns | | The columns by which the table should be filtered with the user-entered keywords. While using filters by several columns simultaneously, their names should be divided by comma. |
|---|
| cell-width | Set Width of filters | 150 | This option allows you to define width in pixels for each filter on the filtration pane. |
|---|
| button | Hide Filters by Default | false | This option allows you to collapse the filtration pane by default. |
|---|
| hidelabels | Hide Filter Labels | false | This option allows you to hide labels of filters on the filtration pane. |
|---|
| hidePane | Hide Filters by Default | false | This option allows you to hide the filtration pane in the page view mode. |
|---|
| default | Set Filters' Default Values | | The default values for drop-down filters and text boxes, which the table should be filtered by. |
|---|
| limitHeight | Fit Table to Screen Area | | This option allows you to enable the fitting of the table to your screen area. |
|---|
| globalFilter | Global Filter | false | This option allows you to enable the global filter for instant data filtration throughout the whole table. |
|---|
| numbering | Automatic Row Numbering | false | This option allows you to enable dynamic or status automatic row numbering in the ascending or descending order. |
|---|
| showNRows | Show First N Rows | | This option allows you to specify the number of rows to show. |
|---|
| numberfilter | Number Filter Columns | | This option allows you to filter the columns with number values within the specific range. |
|---|
| datefilter | Date Filter Columns | | This option allows you to filter the columns with dates within the specific date range. |
|---|
| datepattern | Date format | | This option allows you to specify the appropriate date format for filtration by date range. |
|---|
| sort | Default Sorting | false | This option allows you to define the default sorting order for one or multiple table columns. |
|---|
| separator | Decimal Separator | Point (.) | This option allows you set the appropriate decimal separator for your number values. |
|---|
Examples
Generic table data filtration
| Info |
|---|
Please select one or multiple values to filter data in the table below. |
| Table Filter |
|---|
| default | Doe|Fry |
|---|
| userfilter | Last Name |
|---|
| column | City,First Name,Occupation |
|---|
| id | 14412827696236c0f2523a350ba0b5a518e2d122a34fc |
|---|
|
Doe | John | Developer | London | Fry | Philip | Delivery boy | New York City | Doe | Janet | Scientist | Tokyo | Farnsworth | Hubert | Scientist | New York City | Farnsworth | Cubert | Student | New York City |
|
Default values for filtration and regular expressions
| Info |
|---|
Please note that Table Filter macro allows you to define default filter values for table columns. These values will be automatically applied upon each reload of the page. You can also use regular expressions for flexible data filtration. |
| Table Filter |
|---|
| default | Doe|Fry |
|---|
| userfilter | Last Name |
|---|
| id | 14412827699406c0f2523a350ba0b5a518e2d122a34fc |
|---|
|
Doe | John | Developer | London | Fry | Philip | Delivery boy | New York City | Doe | Janet | Scientist | Tokyo | Farnsworth | Hubert | Scientist | New York City | Farnsworth | Cubert | Student | New York City |
|
| Table Filter |
|---|
| default | Doe, London |
|---|
| column | Last Name, City |
|---|
| id | 14412827700396c0f2523a350ba0b5a518e2d122a34fc |
|---|
|
Doe | John | Developer | London | Fry | Philip | Delivery boy | New York City | Doe | Janet | Scientist | Tokyo | Farnsworth | Hubert | Scientist | New York City | Farnsworth | Cubert | Student | New York City |
|
Table filtration by the user-entered keyword
| Info |
|---|
Please note that Table Filter macro allows you to add free-text fields for dynamic data filtration depending on the specified query. Try to start entering some values for filters to get dynamic filtration of the table. |
| Table Filter |
|---|
| userfilter | First Name,City,Last Name,Occupation |
|---|
| id | 14412827701126c0f2523a350ba0b5a518e2d122a34fc |
|---|
|
Doe | John | Developer | London | Fry | Philip | Delivery boy | New York City | Doe | Janet | Scientist | Tokyo | Farnsworth | Hubert | Scientist | New York City | Farnsworth | Cubert | Student | New York City |
|
Global filter
| Info |
|---|
The global filter allows you to dynamically filter values in all columns of your table. Enter some query to get the table filtered. |
| Table Filter |
|---|
| globalFilter | true |
|---|
| id | 14412827701766c0f2523a350ba0b5a518e2d122a34fc |
|---|
|
Doe | John | Developer | London | Fry | Philip | Delivery boy | New York City | Doe | Janet | Scientist | Tokyo | Farnsworth | Hubert | Scientist | New York City | Farnsworth | Cubert | Student | New York City |
|
Filtering multiple tables at once
| Info |
|---|
You can filter several tables at a time. Just paste two or more tables into the macro. |
| Table Filter |
|---|
| cell-width | 100,150,200 |
|---|
| column | Last Name,First Name,Occupation |
|---|
| id | 144128277023897c34b7b63f19844ef06df7c0f08bf17 |
|---|
|
Doe | John | Developer | London | Fry | Philip | Delivery boy | New York City | Doe | Janet | Scientist | Tokyo | Farnsworth | Hubert | Scientist | New York City | Farnsworth | Cubert | Student | New York City |
Brown | Adam | Developer | New York City | Fry | Andy | Delivery boy | London | Black | Jane | Scientist | Tokyo | McCarthy | Hubert | Scientist | New York City | McCarthy | Cubert | Student | London |
|
Filtering the number range
| Info |
|---|
Table Filter macro allows you to filter numbers in your tables. Just select the appropriate number range or minimal/maximal value and get the table data filtered. |
| Table Filter |
|---|
| datepattern | yy-mm-dd |
|---|
| numberfilter | Minimal Purchase‚ $,Maximal Purchase‚ $,Average Purchase‚ $ |
|---|
| id | 14412827703130262d9545b6f8ccf650fda78084cb674 |
|---|
|
| Remy Deomampo | 47.50 | 139.13 | 214.00 |
| Rahul Dickstein | 73.50 | 505.88 | 184.00 |
| Radu Donahue | 117.75 | 514.75 | 208.25 |
| Preston Doorey | 61.38 | 571.50 | 334.63 |
| Phill Doyle | 63.38 | 558.75 | 142.00 |
| Philip Druckman | 37.13 | 495.75 | 291.25 |
| Philip Duncan | 74.13 | 88.00 | 125.38 |
| Peter Elia | 121.25 | 573.00 | 338.38 |
| Peter Erickson | 81.00 | 453.38 | 73.75 |
| Peter Espinosa | 26.13 | 427.38 | 63.38 |
| Peter Ferrero | 98.25 | 347.75 | 99.25 |
| Perez Figueiredo | 26.13 | 315.38 | 148.13 |
| Patrick Fixler | 27.88 | 548.00 | 221.13 |
| Patrick Flegal | 119.13 | 185.63 | 250.25 |
| Patino Forsyth | 110.38 | 93.13 | 366.13 |
| Pallavi Fox | 124.50 | 552.50 | 150.13 |
| Owen Franzoni | 77.88 | 462.75 | 359.25 |
| Ophir Friedman | 98.88 | 170.25 | 155.50 |
| Obaid Friis | 25.63 | 331.88 | 277.63 |
| Noelle Fu | 47.38 | 569.63 | 273.75 |
| Noel Gambino | 102.13 | 134.88 | 332.38 |
| Nicole Gao | 34.50 | 608.25 | 141.00 |
| Nishant Gao | 117.13 | 622.25 | 326.50 |
| Nicole Garcia | 87.00 | 260.88 | 179.50 |
| Negrin Gee | 93.13 | 299.38 | 117.63 |
| Expand |
|---|
| title | Click here to expand the table with other data for filtration... |
|---|
|
| Table Filter |
|---|
| datepattern | yy-mm-dd |
|---|
| numberfilter | Average Time per Call (min),Average Time per Ticket (min),Calls per Hour,Tickets per Hour,Earned Money for Support ($),Support Efficiency |
|---|
| id | 1441282770392ed2f08556ae8e335d069f54d639ee427 |
|---|
|
| Remy Deomampo | 2.8 | 5.9 | 2.6 | 7.2 | 5 185.00 | 47.00% |
| Rahul Dickstein | 7.8 | 2.5 | 2.0 | 3.7 | 2 366.00 | 62.00% |
| Radu Donahue | 6.5 | 3.8 | 1.9 | 3.2 | 1 449.00 | 20.00% |
| Preston Doorey | 6.7 | 6.8 | 3.7 | 6.7 | 3 096.00 | 42.00% |
| Phill Doyle | 4.7 | 4.0 | 2.3 | 6.7 | 4 957.00 | 23.00% |
| Philip Druckman | 3.9 | 3.0 | 2.0 | 4 | 3 544.00 | 37.00% |
| Philip Duncan | 7.3 | 5.9 | 1.3 | 5.8 | 4 007.00 | 16.00% |
| Peter Elia | 2.3 | 6.3 | 3.5 | 5.9 | 4 743.00 | 24.00% |
| Peter Erickson | 6.1 | 2.8 | 3.4 | 5.6 | 5 134.00 | 57.00% |
| Peter Espinosa | 5.4 | 2.7 | 4.8 | 4.1 | 2 257.00 | 44.00% |
| Peter Ferrero | 3.7 | 4.5 | 2.4 | 7.2 | 2 350.00 | 40.00% |
| Perez Figueiredo | 8.0 | 4.0 | 4.2 | 3.1 | 2 972.00 | 16.00% |
| Patrick Fixler | 6.4 | 1.4 | 1.5 | 5.9 | 4 490.00 | 11.00% |
| Patrick Flegal | 4.3 | 6.8 | 4.9 | 7.4 | 2 506.00 | 14.00% |
| Patino Forsyth | 5.5 | 7.0 | 3.5 | 4 | 1 489.00 | 73.00% |
| Pallavi Fox | 2.1 | 2.4 | 3.1 | 6.2 | 4 533.00 | 14.00% |
| Owen Franzoni | 6.7 | 5.2 | 4.9 | 4.3 | 1 361.00 | 77.00% |
| Ophir Friedman | 5.3 | 2.1 | 2.0 | 7.8 | 2 032.00 | 47.00% |
| Obaid Friis | 7.5 | 4.0 | 3.8 | 7.5 | 4 812.00 | 16.00% |
| Noelle Fu | 2.8 | 6.8 | 1.2 | 6.6 | 2 167.00 | 10.00% |
| Noel Gambino | 6.7 | 2.9 | 2.5 | 3.1 | 3 090.00 | 47.00% |
| Nicole Gao | 9.0 | 2.3 | 2.6 | 7.8 | 4 518.00 | 61.00% |
| Nishant Gao | 6.0 | 3.9 | 2.0 | 5.2 | 3 411.00 | 71.00% |
| Nicole Garcia | 3.8 | 5.9 | 4.6 | 6.3 | 3 139.00 | 28.00% |
| Negrin Gee | 2.8 | 2.3 | 2.2 | 5.4 | 4 072.00 | 54.00% |
Filtering the date range
| Info |
|---|
Table Filter macro allows you to filter dates in your tables. Just specify the appropriate date format and filter the table by date range. |
| Table Filter |
|---|
| datefilter | Registration Date,First Transaction,Last Transaction |
|---|
| datepattern | m/d/yy |
|---|
| id | 1441282770573a50ab5ad5cf437af728748b0fec2436f |
|---|
|
| Stephen Chan | 5/26/2015 | 7/29/2015 | 7/19/2015 |
| Steven Chan | 6/5/2015 | 7/29/2015 | 8/14/2015 |
| Sompop Chang | 6/16/2015 | 7/21/2015 | 7/25/2015 |
| Spencer Chang | 6/23/2015 | 7/13/2015 | 8/11/2015 |
| Stephanie Chang | 6/14/2015 | 7/23/2015 | 8/9/2015 |
| Simond Chat | 5/18/2015 | 6/20/2015 | 8/20/2015 |
| Simon Chau | 6/17/2015 | 7/19/2015 | 7/27/2015 |
| Shiv Chayet | 5/4/2015 | 7/17/2015 | 7/20/2015 |
| Shannon Cheesebro | 5/11/2015 | 7/4/2015 | 8/20/2015 |
| Scott Chen | 5/3/2015 | 7/27/2015 | 8/2/2015 |
| Se Chen | 6/21/2015 | 7/11/2015 | 7/26/2015 |
| Sean Chen | 6/9/2015 | 7/21/2015 | 7/20/2015 |
| Seth Chen | 5/30/2015 | 7/15/2015 | 8/12/2015 |
| Sevag Chen | 5/15/2015 | 6/24/2015 | 7/20/2015 |
| Scott Cheng | 6/5/2015 | 7/12/2015 | 7/29/2015 |
| Satiya Cheung | 6/5/2015 | 7/25/2015 | 8/27/2015 |
| Sarah Chin | 6/4/2015 | 6/29/2015 | 8/29/2015 |
| Sara Chomitz | 6/13/2015 | 6/27/2015 | 8/17/2015 |
| Samuel Chou | 6/30/2015 | 7/6/2015 | 8/4/2015 |
| Sang Chou | 6/18/2015 | 6/28/2015 | 8/1/2015 |
| Sangjo Chou | 5/14/2015 | 7/6/2015 | 8/2/2015 |
| Samantha Chu | 6/3/2015 | 7/7/2015 | 8/20/2015 |
| Samaneh Chua | 6/21/2015 | 6/20/2015 | 7/22/2015 |
| Salas Chung | 6/6/2015 | 7/25/2015 | 8/23/2015 |
| Saeed Cilento | 5/2/2015 | 7/24/2015 | 8/26/2015 |
| Expand |
|---|
| title | Click here to expand the table with another date format... |
|---|
|
| Table Filter |
|---|
| datefilter | Registration Date,First Transaction,Last Transaction |
|---|
| datepattern | d-M-y |
|---|
| id | 1441282770640341815b5d41b1dc9fd023bfad3cde003 |
|---|
|
| Stephen Chan | 26-May-15 | 29-Jul-15 | 19-Jul-15 |
| Steven Chan | 5-Jun-15 | 29-Jul-15 | 14-Aug-15 |
| Sompop Chang | 16-Jun-15 | 21-Jul-15 | 25-Jul-15 |
| Spencer Chang | 23-Jun-15 | 13-Jul-15 | 11-Aug-15 |
| Stephanie Chang | 14-Jun-15 | 23-Jul-15 | 9-Aug-15 |
| Simond Chat | 18-May-15 | 20-Jun-15 | 20-Aug-15 |
| Simon Chau | 17-Jun-15 | 19-Jul-15 | 27-Jul-15 |
| Shiv Chayet | 4-May-15 | 17-Jul-15 | 20-Jul-15 |
| Shannon Cheesebro | 11-May-15 | 4-Jul-15 | 20-Aug-15 |
| Scott Chen | 3-May-15 | 27-Jul-15 | 2-Aug-15 |
| Se Chen | 21-Jun-15 | 11-Jul-15 | 26-Jul-15 |
| Sean Chen | 9-Jun-15 | 21-Jul-15 | 20-Jul-15 |
| Seth Chen | 30-May-15 | 15-Jul-15 | 12-Aug-15 |
| Sevag Chen | 15-May-15 | 24-Jun-15 | 20-Jul-15 |
| Scott Cheng | 5-Jun-15 | 12-Jul-15 | 29-Jul-15 |
| Satiya Cheung | 5-Jun-15 | 25-Jul-15 | 27-Aug-15 |
| Sarah Chin | 4-Jun-15 | 29-Jun-15 | 29-Aug-15 |
| Sara Chomitz | 13-Jun-15 | 27-Jun-15 | 17-Aug-15 |
| Samuel Chou | 30-Jun-15 | 6-Jul-15 | 4-Aug-15 |
| Sang Chou | 18-Jun-15 | 28-Jun-15 | 1-Aug-15 |
| Sangjo Chou | 14-May-15 | 6-Jul-15 | 2-Aug-15 |
| Samantha Chu | 3-Jun-15 | 7-Jul-15 | 20-Aug-15 |
| Samaneh Chua | 21-Jun-15 | 20-Jun-15 | 22-Jul-15 |
| Salas Chung | 6-Jun-15 | 25-Jul-15 | 23-Aug-15 |
| Saeed Cilento | 2-May-15 | 24-Jul-15 | 26-Aug-15 |
| Expand |
|---|
| title | Click here to expand the table with another date format... |
|---|
|
| Table Filter |
|---|
| datefilter | Registration Date,First Transaction,Last Transaction |
|---|
| datepattern | MM d, yy |
|---|
| id | 14412827707005257026debe1bfcab03b435797ebd132 |
|---|
|
| Stephen Chan | May 26, 2015 | July 29, 2015 | July 19, 2015 |
| Steven Chan | June 5, 2015 | July 29, 2015 | August 14, 2015 |
| Sompop Chang | June 16, 2015 | July 21, 2015 | July 25, 2015 |
| Spencer Chang | June 23, 2015 | July 13, 2015 | August 11, 2015 |
| Stephanie Chang | June 14, 2015 | July 23, 2015 | August 9, 2015 |
| Simond Chat | May 18, 2015 | June 20, 2015 | August 20, 2015 |
| Simon Chau | June 17, 2015 | July 19, 2015 | July 27, 2015 |
| Shiv Chayet | May 4, 2015 | July 17, 2015 | July 20, 2015 |
| Shannon Cheesebro | May 11, 2015 | July 4, 2015 | August 20, 2015 |
| Scott Chen | May 3, 2015 | July 27, 2015 | August 2, 2015 |
| Se Chen | June 21, 2015 | July 11, 2015 | July 26, 2015 |
| Sean Chen | June 9, 2015 | July 21, 2015 | July 20, 2015 |
| Seth Chen | May 30, 2015 | July 15, 2015 | August 12, 2015 |
| Sevag Chen | May 15, 2015 | June 24, 2015 | July 20, 2015 |
| Scott Cheng | June 5, 2015 | July 12, 2015 | July 29, 2015 |
| Satiya Cheung | June 5, 2015 | July 25, 2015 | August 27, 2015 |
| Sarah Chin | June 4, 2015 | June 29, 2015 | August 29, 2015 |
| Sara Chomitz | June 13, 2015 | June 27, 2015 | August 17, 2015 |
| Samuel Chou | June 30, 2015 | July 6, 2015 | August 4, 2015 |
| Sang Chou | June 18, 2015 | June 28, 2015 | August 1, 2015 |
| Sangjo Chou | May 14, 2015 | July 6, 2015 | August 2, 2015 |
| Samantha Chu | June 3, 2015 | July 7, 2015 | August 20, 2015 |
| Samaneh Chua | June 21, 2015 | June 20, 2015 | July 22, 2015 |
| Salas Chung | June 6, 2015 | July 25, 2015 | August 23, 2015 |
| Saeed Cilento | May 2, 2015 | July 24, 2015 | August 26, 2015 |
Changing the width of the filter boxes
| Info |
|---|
Please note that Table Filter macro allows you to alternate width of filters on the filtration pane. |
| Table Filter |
|---|
| cell-width | 100,150,200 |
|---|
| column | Last Name,First Name,Occupation |
|---|
| id | 14412827707586c0f2523a350ba0b5a518e2d122a34fc |
|---|
|
Doe | John | Developer | London | Fry | Philip | Delivery boy | New York City | Doe | Janet | Scientist | Tokyo | Farnsworth | Hubert | Scientist | New York City | Farnsworth | Cubert | Student | New York City |
|
Hiding the filters
| Info |
|---|
Please note that Table Filter macro allows you to hide or show the filtration pane on the page. Click Show filter to expand the filtration pane and Hide filter to collapse it. |
| Table Filter |
|---|
| button | true |
|---|
| column | Last Name |
|---|
| id | 14412827708196c0f2523a350ba0b5a518e2d122a34fc |
|---|
|
Doe | John | Developer | London | Fry | Philip | Delivery boy | New York City | Doe | Janet | Scientist | Tokyo | Farnsworth | Hubert | Scientist | New York City | Farnsworth | Cubert | Student | New York City |
|
Fitting table to the screen area
| Info |
|---|
Please note that Table Filter macro allows you to automatically fit long tables to your screen area. |
| Table Filter |
|---|
| numbering | true |
|---|
| column | Customer Status,Suspicious Transaction Activity,Target Transaction City |
|---|
| id | 1441282770894fc02ae92d220e111df089cb784761aa7 |
|---|
| limitHeight | true |
|---|
|
| Reuben | Barnett | $129.42 | Guápiles | Tunisia | Blocked | Yes | 8 |
| McKenzie | Cleveland | $216.75 | Savannah | United States | Blocked | Yes | 1 |
| Portia | Lang | $422.53 | Meerut | Côte D'Ivoire (Ivory Coast) | Rejected | No | 5 |
| Eagan | Mcgee | $253.03 | Orangeville | Afghanistan | Approved | No | 2 |
| Rahim | Velazquez | $454.06 | Lac-Serent | Georgia | Approved | Yes | 6 |
| Roth | Hull | $142.57 | Luziânia | Sao Tome and Principe | Blocked | No | 4 |
| Jack | Griffin | $146.60 | Georgia | Bahamas | Blocked | No | 4 |
| Faith | Newton | $324.96 | Okigwe | Sri Lanka | Rejected | Yes | 1 |
| Basia | Ray | $260.39 | Valcourt | Equatorial Guinea | Rejected | Yes | 4 |
| Leandra | Duncan | $380.33 | My | Swaziland | Rejected | No | 6 |
| Cameran | Velasquez | $144.75 | Schiltigheim | Bangladesh | Rejected | Yes | 8 |
| Amery | Poole | $418.48 | Zolder | Azerbaijan | Rejected | Yes | 1 |
| Owen | Welch | $279.12 | Springdale | Benin | Rejected | Yes | 4 |
| Germaine | Hines | $347.08 | Bellingen | Algeria | Approved | No | 6 |
| Thane | Cortez | $338.56 | Penrith | Tunisia | Approved | Yes | 1 |
| Sean | Delacruz | $421.67 | Vietri di Potenza | Libya | Rejected | No | 4 |
| Willow | Skinner | $216.70 | Ham-sur-Sambre | Venezuela | Approved | No | 1 |
| Camilla | Good | $311.10 | Saint-Hilarion | Malawi | Rejected | No | 7 |
| Ingrid | Horne | $365.20 | Crato | Dominica | Approved | Yes | 4 |
| Claire | Raymond | $126.99 | Wieze | Western Sahara | Blocked | Yes | 9 |
| Akeem | Holder | $131.59 | Sutton | Samoa | Blocked | Yes | 7 |
| Yuli | Hubbard | $107.57 | Hudson Bay | Bolivia | Rejected | No | 4 |
| Gregory | Sampson | $339.91 | Stroud | Mozambique | Blocked | No | 1 |
| Freya | Osborn | $198.86 | Rexton | Luxembourg | Approved | Yes | 5 |
| Kylan | Dillard | $264.70 | Market Drayton | Yemen | Rejected | No | 3 |
| Curran | Dickson | $360.20 | San Francisco | Saint Martin | Blocked | No | 7 |
| Sylvester | Campos | $338.44 | Riparbella | Armenia | Blocked | Yes | 5 |
| Hadley | Gates | $363.39 | Chelmsford | New Zealand | Rejected | Yes | 7 |
| Willa | Stevens | $137.89 | Glabais | Japan | Approved | No | 2 |
| Keelie | Byers | $236.10 | Cavaion Veronese | Palestine, State of | Approved | No | 3 |
| Jordan | Weber | $249.33 | Shepparton | Anguilla | Blocked | Yes | 9 |
| Karly | Walls | $200.81 | Charlottetown | Guatemala | Approved | Yes | 7 |
| Octavius | Cervantes | $235.63 | Merksem | Dominica | Approved | Yes | 4 |
| Tyrone | Alvarez | $303.65 | Thame | Iraq | Blocked | Yes | 5 |
| Jolene | Howe | $321.67 | Maple Creek | Togo | Blocked | No | 3 |
| Cody | Ross | $219.44 | Gent | Austria | Blocked | Yes | 6 |
| Chase | Bryant | $493.65 | Moustier-sur-Sambre | Czech Republic | Approved | No | 9 |
| Lynn | Cummings | $484.17 | Metairie | Liechtenstein | Approved | No | 3 |
| Lars | Shaw | $170.60 | Pittsburgh | British Indian Ocean Territory | Rejected | No | 4 |
| Cassidy | Porter | $142.39 | Saint-Maur-des-Fossés | Zambia | Approved | Yes | 3 |
| Whilemina | Goodwin | $255.81 | Amaro | Guinea | Rejected | No | 3 |
| Jordan | Mullen | $151.41 | Alajuela | Eritrea | Approved | No | 9 |
| Curran | Bond | $207.97 | Wattrelos | Belize | Approved | Yes | 4 |
| Shad | Shelton | $177.90 | Salt Lake City | Estonia | Rejected | No | 4 |
| Eve | Hines | $113.99 | Montpellier | Netherlands | Rejected | No | 7 |
| Amir | Odom | $203.43 | Manavgat | Albania | Blocked | Yes | 5 |
| Evan | Coffey | $489.53 | Prince Albert | Brunei | Rejected | No | 5 |
| Quynn | King | $393.43 | São Luís | Chile | Blocked | No | 9 |
| Ivy | Alvarado | $198.75 | Guwahati | Cape Verde | Approved | No | 2 |
| Seth | Vasquez | $333.66 | Greater Hobart | Malaysia | Blocked | No | 3 |
| Guy | Cotton | $168.20 | Saint-Pierre | Denmark | Blocked | No | 4 |
| Xyla | Spears | $368.74 | Jamoigne | Guernsey | Rejected | No | 2 |
| Haviva | Hancock | $136.33 | Chelsea | Zimbabwe | Approved | No | 5 |
| Juliet | Barlow | $326.73 | Solingen | Iran | Approved | Yes | 7 |
| Kay | Cole | $158.75 | Clare | Netherlands | Approved | Yes | 2 |
| Zenaida | Kirkland | $315.19 | Yellowhead County | Mongolia | Blocked | No | 4 |
| Ryan | Ware | $367.76 | Tuticorin | Armenia | Rejected | Yes | 8 |
| Maite | Lowe | $256.17 | Muno | Poland | Blocked | No | 1 |
| Sandra | Schultz | $273.51 | Nampa | Colombia | Approved | Yes | 9 |
| Karina | Horton | $443.37 | Esslingen | Taiwan | Rejected | Yes | 2 |
| Lysandra | Black | $322.36 | Strombeek-Bever | Swaziland | Blocked | Yes | 8 |
| Alden | Buckner | $249.18 | San Marcello Pistoiese | Hungary | Blocked | No | 1 |
| Levi | Nolan | $478.53 | Chambord | Ukraine | Rejected | No | 7 |
| Buckminster | Ewing | $239.77 | Haren | Argentina | Blocked | No | 1 |
| Aidan | Henson | $340.93 | Valpelline | Jersey | Approved | No | 3 |
| Howard | Crosby | $201.61 | Chambave | Cameroon | Blocked | No | 2 |
| Ginger | Castro | $473.40 | Isle-aux-Coudres | Latvia | Approved | No | 4 |
| Hyatt | Mullins | $450.40 | Oldenzaal | Slovenia | Rejected | No | 4 |
| Rachel | Head | $166.15 | Bautzen | Nauru | Blocked | No | 7 |
| Shoshana | Underwood | $336.12 | Parkland County | Liechtenstein | Blocked | No | 2 |
| Colt | Kent | $482.74 | Jalgaon | Grenada | Approved | Yes | 3 |
| Amethyst | Dunn | $313.64 | Dipignano | Western Sahara | Approved | Yes | 9 |
| Plato | Duke | $229.55 | Exeter | India | Blocked | Yes | 1 |
| Jared | Dale | $391.90 | Béziers | Mauritius | Approved | Yes | 3 |
| Luke | Vang | $375.44 | Vorselaar | Jersey | Blocked | Yes | 1 |
| Phillip | Reed | $431.70 | Chittoor | Christmas Island | Approved | Yes | 6 |
| Brandon | Lowery | $213.54 | Cork | Chad | Rejected | Yes | 1 |
| Rafael | Elliott | $281.05 | Little Rock | Jamaica | Approved | Yes | 4 |
| Lyle | Black | $437.51 | Mold | Palau | Rejected | Yes | 6 |
| Wendy | Rosa | $219.66 | Fortaleza | Egypt | Approved | No | 7 |
| Priscilla | Dodson | $414.83 | Polpenazze del Garda | Christmas Island | Approved | Yes | 1 |
| Quamar | Crawford | $465.99 | Treglio | Suriname | Blocked | Yes | 2 |
| Shad | Flores | $442.84 | Vezirköprü | Guyana | Blocked | Yes | 6 |
| Lana | Wheeler | $202.64 | St. Neots | Palau | Rejected | No | 1 |
| Vanna | Farmer | $351.21 | Millport | Maldives | Approved | Yes | 9 |
| Cadman | Ray | $352.24 | Cheyenne | South Sudan | Blocked | No | 7 |
| Kimberley | Savage | $429.55 | Miami | Vanuatu | Approved | No | 9 |
| Armand | Sears | $477.13 | Mussy-la-Ville | Saint Vincent and The Grenadines | Approved | No | 8 |
| Sawyer | Vance | $492.63 | Davoli | Benin | Rejected | No | 4 |
| Tanek | Lyons | $172.85 | Rocky View | Afghanistan | Approved | No | 9 |
| Nayda | Hickman | $295.47 | Newcastle-upon-Tyne | Kiribati | Blocked | No | 3 |
| Aileen | Waters | $202.47 | Idar-Oberstei | Slovakia | Blocked | Yes | 3 |
| Forrest | Larsen | $269.64 | Gulfport | Korea, North | Blocked | Yes | 3 |
| Willa | Kemp | $239.89 | Somma Lombardo | Wallis and Futuna | Approved | Yes | 2 |
| Eugenia | Byrd | $466.08 | Caruaru | Northern Mariana Islands | Rejected | Yes | 8 |
| Kato | Beck | $396.49 | Khanpur | Solomon Islands | Approved | Yes | 2 |
Hiding table columns
| Info |
|---|
Please note that Table Filter macro allows you to hide columns if you have a too wide table. Select one or multiple columns to hide in the table below. |
| Table Filter |
|---|
| hideColumns | true |
|---|
| column | Bank Account Number,Customer Status,Suspicious Transaction Activity |
|---|
| id | 14412827709541e93cce7f63b88534c8ba89cee553d7e |
|---|
|
| Reuben | Barnett | 0500 009888 | 12/14/14 | DO07819385109432271545550865 | $129.42 | $10.28 | Guápiles | Tunisia | Blocked | Yes | 8 |
| McKenzie | Cleveland | 07624 785373 | 09/15/14 | CH6046131558340157475 | $216.75 | $46.19 | Savannah | United States | Blocked | Yes | 1 |
| Portia | Lang | (011247) 04420 | 09/27/14 | EE967962637165872502 | $422.53 | $16.29 | Meerut | Côte D'Ivoire (Ivory Coast) | Rejected | No | 5 |
| Eagan | Mcgee | 07212 430492 | 09/19/14 | MK83589588636375406 | $253.03 | $26.26 | Orangeville | Afghanistan | Approved | No | 2 |
| Rahim | Velazquez | 0325 526 8440 | 12/31/14 | FO0682149824230550 | $454.06 | $27.73 | Lac-Serent | Georgia | Approved | Yes | 6 |
| Roth | Hull | 0500 311844 | 10/11/14 | LU056987267796106873 | $142.57 | $14.14 | Luziânia | Sao Tome and Principe | Blocked | No | 4 |
| Jack | Griffin | 07624 307488 | 09/04/14 | BA714509342088998370 | $146.60 | $34.55 | Georgia | Bahamas | Blocked | No | 4 |
| Faith | Newton | 0800 1111 | 09/24/14 | LU521764205226552485 | $324.96 | $24.60 | Okigwe | Sri Lanka | Rejected | Yes | 1 |
| Basia | Ray | 0346 983 8340 | 08/13/14 | TR280491289079508593611789 | $260.39 | $45.19 | Valcourt | Equatorial Guinea | Rejected | Yes | 4 |
Leandra | Duncan | 0359 889 6822 | 01/11/15 | CR0942393063075420342 | $380.33 | $34.57 | My | Swaziland | Rejected | No | 6