Search
14082 results 361-370
Reference
language.searchBuilder.conditions.string› Set the condition names for the string column typeThis object sets the text for the condition names in the condition select element. The defaults for each language option is listed below. equals: 'Equals' not: 'Not' startsWith: 'Starts With' notStartsWith: 'Does Not Start With' contains: 'Contains' notContains: 'Does Not Contain' endsWith: 'Ends With' notEndsWith: 'Does Not End With' empty: 'Empty' notEmpty: 'Not Empty'language.searchBuilder.conditions.number› Set the condition names for the number column typeThis object sets the text for the condition names in the condition select element. The defaults for each language option is listed below. between: 'Between' empty: 'Empty' equals: 'Equals' gt: 'Greater Than' gte: 'Greater Than Equal To' lt: 'Less Than' lte: 'Less Than Equal To' not: 'Not' notBetween: 'Not Between' notEmpty: 'Not Empty'language.searchBuilder.conditions.date› Set the condition names for the date column typeThis object sets the text for the condition names in the condition select element. The defaults for each language option is listed below. after: 'After' before: 'Before' between: 'Between' empty: 'Empty' equals: 'Equals' not: 'Not' notBetween: 'Not Between' notEmpty: 'Not Empty'language.searchBuilder.conditions.array› Set the condition names for columns that use arraysThis object sets the text for the condition names in the condition select element. The defaults for each language option is listed below. contains: 'Contains' empty: 'Empty' equals: 'Equals' not: 'Not' notEmpty: 'Not Empty' without: 'Without'language.searchBuilder.condition› Set the placeholder text for the SearchBuilder condition `-tag select` elementThis will set the placeholder text for the condition select element, by default this is 'Condition'. This dom element is available in custom conditions and plugins also.searchBuilder.logic› Set the default logic operatorform to use when searching a dataset. When using searchBuilder.preDefined searches, this value is alsosearchBuilder.depthLimit› Impose a limit on the depth of the groupsThis option allows for a limit to be set on how deep sub groups can be placed from the top level. 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. As default the limit is false, meaning that criteria can be indented as far as desired. Take a look at this example to see this in action.searchBuilder.columns› Restrict which columns can be filtered onThis is useful as it allows restrictions to be made on which data points can be filtered on. For tables with a large amount of columns, this prevents having a large set of options within the select element.
Examples
- StateRestore › Don't save column searchesThis example shows how to use the
saveState.columns.visibleconfiguration option (seestateRestoreConfig#saveState) to disable the saving of the table's current column visibility by setting the initialisation option tofalse. The default value istruemeaning that the visibility of the columns will be saved. - SearchPanes › Advanced SearchPanesThis is the section for showing the key configuration options that are available with SearchPanes. This includes showing sub-totals, cascading the panes, selecting which panes to show or hide and pre-selecting rows to name a few.
Forum
- 13th Apr 2022Display sum of column instead of counting rows in search panese in the first search pane that for example
- 13th Apr 2022Search pane filter that returns the top 10 highest valuesthe strings in a search, along with any other
- 11th Apr 2022Alphabet Search Reset Sorting along with DropdownsYou are using this search: column .search(val ? '^' + val + '$' : '', true,
- 11th Apr 2022Search in two columns with multiple values separated by a pipeIn the search plugin you can use any supported Javascript method like regex search(). Kevin
- 9th Apr 2022Grouping in search paneWhen I think about it, this should not be possible as the search panes only contains unique values. There is nothing to group on. Right?
- 9th Apr 2022Change "No data" in search paneThanks! Is it possible to somehow target an indiviual search pane?
- 6th Apr 2022Column Filter SearchBecause that's a dynamic element, you need to get the val() of the select during the search. This example here demonstrates input elements, the same applies for select, Colin
- 6th Apr 2022ServerSide processing failed on search & PostgreSQLOne additional thing - worth noting that since you are using server-side processing, it is only possible to search in ISO8601 format.
- 31st Mar 2022Search Fuction not foundbelieve the API's, like search() is available in 1.9.
- 28th Mar 2022Why is my search returning only one result?the users, and just search on "ACV ACY", and