Answers

• boraerel Posts: 4Questions: 2Answers: 0

  November 2023

  I want to use data-search tag for searching.
• kthorngren Posts: 22,310Questions: 26Answers: 5,128

  November 2023

  Is your table data sourced from the DOM, AJAX or Javascript?

  If not sourced from the DOM then Datatables won't use the data-search attribute.

  Since you are using columns.render can you use Orthogonal data to return the desired search value for the filter operation?

  I've seen some unexpected behavior when using data-search along with columns.render in the same column. Not sure they are meant to be used at the same time in the same column.

  Kevin
• boraerel Posts: 4Questions: 2Answers: 0

  November 2023

  I am using json data source;
  table.rows.add(data).draw();

  Can you send me an example?

  Thanks
• kthorngren Posts: 22,310Questions: 26Answers: 5,128

  November 2023

  Take a look at the computed values section of the Orthogonal data docs. You will probably want to do something like this:

      render: function ( data, type, row ) {
          // If display return data in the display format
          if ( type === 'display' ) {
              if(data)
                  return '<span style="display:none;">' + data + '</span>' + formatNumber(data, 2) + ' <span class="fs-12">(' + formatNumber(obj[code].strikePricePercent, 2) + '%)</span>';
              return ''; 
          }
  
          // If filter return data formatted for filtering
          if ( type === 'filter' ) {
              // Not sure what you want here so change return as required
              return Math.trunc( data );
          }
   
          // Otherwise the data type requested (`type`) is type detection or
          // sorting data, for which we want to use the integer, so just return
          // that, unaltered
          return data;
      }
  

  Kevin