Search

This example shows how to create a pre-defined filter using searchBuilder.preDefined. More details on the structure and properties can be found in the SearchBuilder.Condition documentation. A more detailed walkthrough of preDefined options can be found at this doc page.

This example includes a salary with a decimal place for testing the num-fmt column type (note Ashton Cox's salary). This example also demonstrates that you can search relative to a number with a decimal place, for example greater than 57.6, and you can optionally include the currency symbol and/or the thousand separator.

This example shows the behaviour of SearchBuilder with columns of type html which is present in the age column.

This example shows how SearchBuilder interacts with empty cells and allows for a demonstration of the Empty option.

This example demonstrates the behaviour of SearchBuilder when the searchBuilder.depthLimit is set to limit how deep the Sub-Groups can be nested. The top level is considered the first level. Setting a searchBuilder.depthLimit of 2 would allow for criteria to be indented by 1 level as this would then be at the second level - the limit. In this example a searchBuilder.depthLimit of 2 is set.

This example show SearchBuilder being used with DataTables' built in date() render which will take an ISO 8601 date string and display it in the user's local format. See the manual for more details.

This example includes multiple date formats that are not in the standard format to demonstrate how SearchBuilder operates with formatted dates. It makes use of the datetime() function that is built into DataTables to format dates with either Moment.js or Luxon, depending on what is available on the page (in this case Moment.js).

This example includes multiple date formats that are not in the standard format to demonstrate how SearchBuilder operates with formatted dates. It makes use of the datetime() function that is built into DataTables to format dates with either Moment.js or Luxon, depending on what is available on the page (in this case Luxon).

This example demonstrates the behaviour of SearchBuilder when the searchBuilder.columns is set to limit which columns can be filtered on. It is an array of the type column-selector, allowing a wide range of different ways of selecting columns. Notice in this example that the "Data" select element only has 3 columns to choose from.

This example demonstrates the behaviour of SearchBuilder when initialised using a button. When initialising using a button the config is set using the buttons.buttons.config property. This can then be used to set SearchBuilder options such as searchBuilder.depthLimit.

options is when I init a datatable (dataTable.DataTable({...})).

sure where your Datatables init code is at but

a screenshot and the init code for your DataTable?

by posting your Datatables init code and relevant server

function at Criteria.initSelect [as init] (dataTables.searchBuilder.js:1046:30) at Criteria._clearValue (dataTables.searchBuilder.js:642:80)

maybe an setting in init?). That way, it would

code prior to your initial load. You will need

the following error on init Cannot read properties of

to how api and init are tagged, but I

input fully compatable with init serverSide = true? I know