Answers

• bindrid Posts: 730Questions: 0Answers: 119

  May 2017 Answer ✓

  I did not do it that way. I appended the search criteria to the existing structure that is passed to the server in the ajax:data function so it looks something like this:

  $("example").DataTable({
      serverSide:true,
      ajax:{url:"mypath",
              data:function(parms) {
                  // user picks column name from select box
                  var colNum = parseInt($("#sel").val());
                 // the search value from a text box
                var val = $("#txt").val();
            
                parms.columns[colNum].search.value = val;
                return parms;
  
                 
             }
  
  }
  }) 
  
  
  

  If you use the name options as you did in your code, you can search through columns until you find parms.columns[x].name == "columnName"
• allan Posts: 64,756Questions: 1Answers: 10,715 Site admin

  May 2017 Answer ✓

  I think the issue is the column selector - there is no { name: ... } option (that will be getting passed to the selector-modifier.

  Instead use:

  orgTabTable.column('OrgID:name')....
  

  The full list of options for the column selectors are available in the column-selector documentation.

  orgTabTable.column( 1 ).search(_orgId).draw();

  That's odd. Does _orgId definitely have a value?

  Allan
• Enaldi Posts: 6Questions: 2Answers: 1

  May 2017 edited May 2017

  Thank you, Allan!!! After fixing the syntax mistake, I was able to get it to work with the column name.

  And thank you @bindrid! I also got your approach to work, and I may use it in the future.