Answers

• colin Posts: 15,161Questions: 1Answers: 2,588

  October 2023

  I'm not clear what the issue. Could you you take this example, please, and give step-by-step instructions on what you'd like to happen rather than the default behaviour?

  Colin
• jankumar1980 Posts: 6Questions: 2Answers: 0

  October 2023

  please see attachement image and how to implement. please share. Thank you
• jankumar1980 Posts: 6Questions: 2Answers: 0

  October 2023 edited October 2023

  My code is below

  $(document).ready(function () {
              var table = $('#Search').DataTable({
                  lengthChange: true,      
                  dom: 'lBfrtip',
                  buttons: [
                      'copy',
                      'excel',
                      'csv',                 
                      {
                          text: 'PDF',
                          extend: 'pdfHtml5',
                          action: function (e, dt, node, config) {
                              PrintDiv();
                          }
                      },
                      'colvis',
                  ],
                  searchBuilder: {
                      conditions: {
                          num: {
                              'MultipleOf': {
                                  conditionName: 'Multiple Of',
                                  init: function (that, fn, preDefined = null) {
                                      var el = $('<input/>').on('input', function () { fn(that, this) });
                                      if (preDefined !== null) {
                                          $(el).val(preDefined[0]);
                                      }
                                      return el;
                                  },
                                  inputValue: function (el) {
                                      return $(el[0]).val();
                                  },
                                  isInputValid: function (el, that) {
                                      return $(el[0]).val().length !== 0;
                                  },
                                  search: function (value, comparison) {
                                      return value % comparison === 0;
                                  }
                              }
                          }
                      }
                  }
              });           
              var buttonContainer = table.buttons().container().appendTo('#Search_wrapper .col-md-6:eq(0)');
              var searchBuilderContainer = table.searchBuilder.container();
              buttonContainer.insertBefore(table.table().container());
              searchBuilderContainer.insertBefore(table.table().container());
          });
  

  Edited by Allan - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.
• allan Posts: 61,822Questions: 1Answers: 10,127 Site admin

  October 2023

  You can put SearchBuilder into a button as shown here. Is that what you are looking for?

  Allan