thosphor
thosphor

Reputation: 2781

Bootstrap table filter control selects matching subset

I'm using bootstrap-table and bootstrap-table-filter to filter results in a table, however the "select" filter is matching subsets of strings which match the filter. E.g., if I select (not search) for "oat", I get matches in the column for "goatherd" as well as for "oat". It's obviously doing some kind of string search rather than matching whole values. Is there a way to change this behaviour?

Example html:

<link href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/font/bootstrap-icons.css">
<link rel="stylesheet" href="https://unpkg.com/[email protected]/dist/bootstrap-table.min.css">
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"></head>

      <table id="table" data-url="json/data1.json" class="dataframe" data-filter-control="true" data-show-search-clear-button="true" data-show-filter-control-switch="true">
      <thead>
        <tr style="text-align: right;">
          <th data-field="oats_goats" data-filter-control="select">Porridge or milk</th>
        </tr>
      </thead>
      <tbody>[Insert data]</tbody>
    </table>
    
<script src="https://cdn.jsdelivr.net/npm/jquery/dist/jquery.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"</script>
<script src="https://unpkg.com/[email protected]/dist/bootstrap-table.min.js"></script>
<script src="https://unpkg.com/[email protected]/dist/extensions/filter-control/bootstrap-table-filter-control.min.js"></script>

<script>
  $(function() {
    $('#table').bootstrapTable()
  })
</script>

Upvotes: 0

Views: 1826

Answers (1)

Rsquare
Rsquare

Reputation: 81

Try using the column option filterStrictSearch.

https://bootstrap-table.com/docs/extensions/filter-control/#filterstrictsearch

<th data-field="oats_goats" data-filter-control="select" data-filter-strict-search="true">Porridge or milk</th>

Upvotes: 1

Related Questions