Answers

• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  January 24 Answer ✓

  Hi,

  I'm afraid there is no option to hide specific values in SearchBuilder at this time.

  Allan
• ECEGROUPE Posts: 77Questions: 28Answers: 1

  January 29 edited January 29

  Ok but why do i have a blank value there ? is the value is null in the database and if i set up my render like this :

  render: function (data, type){
                      if (type === "display"){
                          if (data == "1") {
                              return "✖";
                          } else if (data == "2") {
                              return "✔";
                          }
                      } else if (type === "sort" || type === 'filter' ){
                          if (data == "1") {
                              return "1";
                          } else if (data == "2") {
                              return "2";
                          }
                      }
                      return data;
                  }
              },
  

  it should show only ✖ and ✔ ? I don't understand why blank value is an option, can you explain pls ?

  If i select the blank value in the seachbuilder, this error happen and nothing change in the displayed data result :

  

  Thank in advance for your help,
  Mathieu
• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  January 29 Answer ✓

  Something is always returned from the function. In Javascript when there is no return statement the function return undefined. You can see it with this example:
  https://live.datatables.net/nojucevo/1/edit

  You have this:

                      if (type === "display"){
                          if (data == "1") {
                              return "✖";
                          } else if (data == "2") {
                              return "✔";
                          }
                      }
  

  If the value is not 1 or 2 then the function will return undefined because you haven't defined a "default" return value. Try returning an empty string like this:

                      if (type === "display"){
                          if (data == "1") {
                              return "✖";
                          } else if (data == "2") {
                              return "✔";
                          }
                          return "";
                      }
  

  This should stop the error from occurring and will reset the search back to nothing, ie, display all rows.

  Kevin
• ECEGROUPE Posts: 77Questions: 28Answers: 1

  January 30

  Thank you, it work correclty with this modification