Methods
The Methods API of Bootstrap Table.
The calling method syntax: $('#table').bootstrapTable('method', parameter)
.
getOptions
-
Parameter:
undefined
-
Detail:
Return the options object.
-
Example: Get Options
refreshOptions
-
Parameter:
options
-
Detail:
Refresh the table
options
. -
Example: Refresh Options
getData
-
Parameter:
params
-
Detail:
Get the loaded data of table at the moment that this method is called
useCurrentPage
: if set to true the method will return the data only in the current page.includeHiddenRows
: if set to true the method will include the hidden rows.
-
Example: Get Data
getSelections
-
Parameter:
undefined
-
Detail:
Return selected rows, when no record selected, an empty array will return.
-
Example: Get Selections
getAllSelections
-
Parameter:
undefined
-
Detail:
Return all selected rows contain search or filter, when no record selected, an empty array will return.
-
Example: Get All Selections
load
-
Parameter:
data
-
Detail:
Load the
data
to table, the old rows will be removed. -
Example: Load
append
-
Parameter:
data
-
Detail:
Append the
data
to table. -
Example: Append
prepend
-
Parameter:
data
-
Detail:
Prepend the
data
to table. -
Example: Prepend
remove
-
Parameter:
params
-
Detail:
Remove data from table, the params contain two properties:
field
: the field name of remove rows.values
: the array of values for rows which should be removed.
-
Example: Remove
removeAll
-
Parameter:
undefined
-
Detail:
Remove all data from table.
-
Example: Remove All
insertRow
-
Parameter:
params
-
Detail:
Insert a new row, the params contain following properties:
index
: the row index to insert into.row
: the row data.
-
Example: Insert Row
updateRow
-
Parameter:
params
-
Detail:
Update the specified row(s), each params contain following properties:
index
: the row index to be updated.row
: the new row data.replace
(optional): set totrue
to replace the row instead of extending.
-
Example: Update Row
getRowByUniqueId
-
Parameter:
id
-
Detail:
Get data from table, the row that contains the
id
passed by parameter. -
Example: Get Row By Unique Id
updateByUniqueId
-
Parameter:
params
-
Detail:
Update the specified row(s), each params contain following properties:
id
: a row id where the id should be the uniqueid field assigned to the table.row
: the new row data.replace
(optional): set totrue
to replace the row instead of extending.
-
Example: Update By Unique Id
removeByUniqueId
-
Parameter:
id
-
Detail:
Remove data from table, the row that contains the
id
passed by parameter. -
Example: Remove By Unique Id
updateCell
-
Parameter:
params
-
Detail:
Update one cell, the params contain following properties:
index
: the row index.field
: the field name.value
: the new field value.
To disable table re-initialization you can set
{reinit: false}
. -
Example: Update Cell
updateCellByUniqueId
-
Parameter:
params
-
Detail:
Update the cell specified by the id, each params contain following properties:
id
: row id where the id should be theuniqueId
field assigned to the table.field
: field name of the cell to be updated.value
: new value of the cell.
-
Example: Update Cell By Unique Id
showRow
-
Parameter:
params
-
Detail:
Show the specified row. The params must contain at least one of the following properties:
index
: the row index.uniqueId
: the value of the uniqueId for that row.
-
Example: Show/Hide Row
hideRow
-
Parameter:
params
-
Detail:
Hide the specified row. The params must contain at least one of the following properties:
index
: the row index.uniqueId
: the value of the uniqueId for that row.
-
Example: Show/Hide Row
getHiddenRows
-
Parameter:
show
-
Detail:
Get all rows hidden and if you pass the
show
parametertrue
the rows will be shown again, otherwise, the method only will return the rows hidden. -
Example: Get Hidden Rows
showColumn
-
Parameter:
field
-
Detail:
Show the specified
field
column. The parameter can be a string or a array of fields. -
Example: Show/Hide Column
hideColumn
-
Parameter:
field
-
Detail:
Hide the specified
field
column. The parameter can be a string or a array of fields. -
Example: Show/Hide Column
getVisibleColumns
-
Parameter:
-
-
Detail:
Get visible columns.
-
Example: Get Visible/Hidden Columns
getHiddenColumns
-
Parameter:
undefined
-
Detail:
Get hidden columns.
-
Example: Get Visible/Hidden Columns
showAllColumns
-
Parameter:
undefined
-
Detail:
Show All the columns.
-
Example: Show/Hide All Columns
hideAllColumns
-
Parameter:
undefined
-
Detail:
Hide All the columns.
-
Example: Show/Hide All Columns
mergeCells
-
Parameter:
params
-
Detail:
Merge some cells to one cell, the params contain following properties:
index
: the row index.field
: the field name.rowspan
: the rowspan count to be merged.colspan
: the colspan count to be merged.
-
Example: Merge Cells
checkAll
-
Parameter:
undefined
-
Detail:
Check all current page rows.
-
Example: Check/Uncheck All
uncheckAll
-
Parameter:
undefined
-
Detail:
Uncheck all current page rows.
-
Example: Check/Uncheck All
checkInvert
-
Parameter:
undefined
-
Detail:
Invert check of current page rows. Triggers
onCheckSome
andonUncheckSome
events. -
Example: Check Invert
check
-
Parameter:
index
-
Detail:
Check a row, the row
index
start with 0. -
Example: Check/Uncheck
uncheck
-
Parameter:
index
-
Detail:
Uncheck a row, the row
index
start with 0. -
Example: Check/Uncheck
checkBy
-
Parameter:
params
-
Detail:
Check a row by array of values, the params contain:
field
: name of the field used to find records.values
: array of values for rows to check.
-
Example: Check/Uncheck By
uncheckBy
-
Parameter:
params
-
Detail:
Uncheck a row by array of values, the params contain:
field
: name of the field used to find records.values
: array of values for rows to uncheck.
-
Example: Check/Uncheck By
refresh
-
Parameter:
params
-
Detail:
Refresh/reload the remote server data, you can set
{silent: true}
to refresh the data silently, and set{url: newUrl, pageNumber: pageNumber, pageSize: pageSize}
to change the url (optional), page number (optional) and page size (optional). To supply query params specific to this request, set{query: {foo: 'bar'}}
. -
Example: Refresh
destroy
-
Parameter:
undefined
-
Detail:
Destroy the Bootstrap Table.
-
Example: Destroy
resetView
-
Parameter:
params
-
Detail:
Reset the Bootstrap Table view, for example reset the table height, the params contain:
height
: the height of the table.
-
Example: Reset View
resetWidth
-
Parameter:
undefined
-
Detail:
Resizes header and footer to fit current columns width.
showLoading
-
Parameter:
undefined
-
Detail:
Show loading status.
-
Example: Show/Hide Loading
hideLoading
-
Parameter:
undefined
-
Detail:
Hide loading status.
-
Example: Show/Hide Loading
togglePagination
-
Parameter:
undefined
-
Detail:
Toggle the pagination option.
-
Example: Toggle Pagination
toggleFullscreen
-
Parameter:
undefined
-
Detail:
Toggle fullscreen.
-
Example: Toggle Fullscreen
toggleView
-
Parameter:
undefined
-
Detail:
Toggle the card/table view.
-
Example: Toggle View
resetSearch
-
Parameter:
text
-
Detail:
Set the search
text
. -
Example: Reset Search
filterBy
- Parameter:
filter - An Object of filter
Default:{}
options - An Object of options
Default:{ 'filterAlgorithm': 'and' }
-
Detail:
(Can use only in client-side) Filter data in table. There are multiple ways to filter:
- Leave the options blank to use the
and
filter. - Set the
filterAlgorithm
(see at parameter) toor
to use theor
filter. - Pass a function to the
filterAlgorithm
(see at parameter) to use acustom
filter.
Filter Algorithm
- And
- Filter
{age: 10}
to show the data only age is equal to 10. You can also filter with an array of values, as in:{age: 10, hairColor: ['blue', 'red', 'green']}
to find data where age is equal to 10 and hairColor is either blue, red, or green.
- Filter
- Or
- Filter
{age: 10, name: "santa"}
to show all Data which has a age of 10 or the name is equals to santa.
- Filter
- Custom
- Filter by your Custom algorithm
- Function parameters:
- Row
- Filters
- Return
true
to keep the row and returnfalse
to filter the row.
- Leave the options blank to use the
- Example: Filter By
scrollTo
-
Parameter:
value|object
-
Detail:
- value
- Scroll to the number
value
position, the unit is'px'
, set'bottom'
means scroll to the bottom.
- Scroll to the number
- object
- Scroll to the unit (
px
orrows (index starts by 0)
) Default:{unit: 'px', value: 0}
- Scroll to the unit (
- value
-
Example: Scroll To
getScrollPosition
-
Parameter:
undefined
-
Detail:
Get the current scroll position, the unit is
'px'
. -
Example: Get Scroll Position
selectPage
-
Parameter:
page
-
Detail:
Go to the a specified
page
. -
Example: Select/Prev/Next Page
prevPage
-
Parameter:
undefined
-
Detail:
Go to previous page.
-
Example: Select/Prev/Next Page
nextPage
-
Parameter:
undefined
-
Detail:
Go to next page.
-
Example: Select/Prev/Next Page
toggleDetailView
-
Parameter:
index
-
Detail:
Toggle the row that has the
index
passed by parameter if the detail view option is set totrue
. -
Example: Toggle Detail View
expandRow
-
Parameter:
index
-
Detail:
Expand the row that has the
index
passed by parameter if the detail view option is set totrue
. -
Example: Expand/Collapse Row
collapseRow
-
Parameter:
index
-
Detail:
Collapse the row that has the
index
passed by parameter if the detail view option is set totrue
. -
Example: Expand/Collapse Row
expandAllRows
-
Parameter:
undefined
-
Detail:
Expand all rows if the detail view option is set to
true
. -
Example: Expand/Collapse All Rows
collapseAllRows
-
Parameter:
undefined
-
Detail:
Collapse all rows if the detail view option is set to
true
. -
Example: Expand/Collapse All Rows
updateColumnTitle
-
Parameter:
params
-
Detail:
Update the field title of column, the params contain following properties:
field
: the field name.title
: the field title.
-
Example: Update Column Title
updateFormatText
-
Parameter:
formatName, text
-
Detail:
Update the localizations format text.
-
Example: Update Format Text