Answers

• khanzain Posts: 1Questions: 0Answers: 0

  September 6

  The issue you're facing occurs because DataTables SearchBuilder doesn't automatically detect date columns for filtering. To fix this, you need to define the column's type as "date" in the DataTable initialization. You can use columns.type or create a custom filter for dates in SearchBuilder. Here's an example:

  $('#example').DataTable({
      columns: [
          { data: 'curr_gr_wef', type: 'date' },
          // other columns
      ],
      searchBuilder: {
          columns: [0], // adjust the column index as needed
      }
  });
  

  Ensure the date format is consistent across your data to enable proper filtering.

  Still have doubts here are some excellent programm learning platforms that can guide you through your learning journey:-
  1. W3school 2. Iqra Technology 3. Javatpoint
• NaveenVarma Posts: 4Questions: 2Answers: 0

  September 11

  Thank you very much for response. But the problem is we don't know what data will come in which column. We are using single jsp page for all reports. Is there any way to determine date format in this case. I am using datatime and moment plug-in. Please guide me.
• NaveenVarma Posts: 4Questions: 2Answers: 0

  September 11

  Also I want to add In my pc environment , search builder displays date related filter options. The issue is when in production environment only.