Replies

• allan Posts: 65,856Questions: 1Answers: 10,956 Site admin

  July 31

  Interesting - thank you for spotting that and bringing it to my attention. I'm not immediately sure what is causing it, but something will be calling the draw() method, probably in a resize update I guess. I will dig into that and get back to you.

  Also, no, I haven't forgotten about the Vue issue. Apologies I haven't gotten to that this week. I'm going to take a little down time next week, but I will look at that issue, probably the following week, as that is something that should very much work.

  Allan
• lbermudez Posts: 5Questions: 0Answers: 0

  August 1

  I have the same problem when using columnControl with server side on date type. (not using vue).

  Putting a valid date on the column search stops the loop but if i clear the value it starts again.

  Seems to happen only with columncontrol.
• allan Posts: 65,856Questions: 1Answers: 10,956 Site admin

  August 2

  I've committed a fix for this issue. The problem is demonstrated with ColumnControl as @lbermudez correctly points out, but it is just the trigger for what was an issue in DataTables core.

  The fix is now in the nightly builds and I would very much welcome if either (or both!) of you could try it out and confirm that addresses the problem you were seeing.

  Regards,
  Allan
• lbermudez Posts: 5Questions: 0Answers: 0

  August 2

  Can confirm that the trigger is no longer causing the loop.
  Sorting now works flawlessly,

  But now i think the search is not autodetecting the date format, im using EU format, and:

  13/08/2026 returns a blank list
  2026-08-13 return the full list (no filter)

      Field::inst('demo.fecha_hora', 'fecha_hora')
          ->getFormatter(Format::dateSqlToFormat('d/m/Y H:i'))
          ->setFormatter(Format::dateFormatToSql('d/m/Y H:i')),
  
      Field::inst('demo.fecha_hora', 'fecha')
          ->getFormatter(Format::dateSqlToFormat('d/m/Y' ))
          ->setFormatter(Format::dateFormatToSql('d/m/Y')),
  
  
  
  
  DataTable.use(moment, 'moment');
  DataTable.datetime('DD/MM/YYYY');
  DataTable.datetime('DD/MM/YYYY HH:mm');
  
  
             {
                      data: 'fecha_hora',
                      title: 'FechaHora',
  
                      columnControl: {
                          target: 0,
                          content: [
                              'order',
                              ['searchDateTime']
                          ]
                      }
                  },
                  {
                      data: 'fecha',
                      title: 'Fecha',
                      columnControl: {
                          target: 0,
                          content: [
                              'order',
                              ['searchDateTime']
                          ]
                      }
                  },
  

  But this might be a problem on my side, since i have done so many tests that my dependences are a mess.
  I'll try more during the week.

  Also, just a side note, if i try to leave target 0 empty (on both elements), by targeting the column index 1. I get an error (im gessing because the second column is not created) this is not that important but prevents using the native sort (since it will disappear from all columns if columncontrol.order is defined in one of them.

  Uncaught (in promise) TypeError: Cannot read properties of undefined (reading '2')

  Thanks for your dedication, Allan
• lbermudez Posts: 5Questions: 0Answers: 0

  August 2 edited August 2

  Edit: I was wrong, it does detect the date format. and works fine with

  'DD/MM/YYYY HH:mm'

  but with my column DD/MM/YYYY fails only with the "equals" condition.
  works fine with before, after, empty, etc...

  And this problem seems to happen too with SearchBuilder, so the main topic on this post, the loop, i think it's fixed.
• allan Posts: 65,856Questions: 1Answers: 10,956 Site admin

  11:16AM

  Excellent - one step forward.

  Are you able to give me a link to your page showing the issue with the date search not matching please? I haven encountered that sort of issue before, but another example demonstrating the problem would be very useful.

  Allan
• lbermudez Posts: 5Questions: 0Answers: 0

  12:50PM edited 1:05PM

  Nevermind, Allan, while preparing a demoIi realized that the problem must be on how php builds the query and since my composer was targeting latest

  "datatables.net/editor-php"

  but i didnt realize the package has changed names to
  "datatables.net/php": "^3.0",

  quick composer update and everything is working as intended

  Thanks so much
• coreyg142 Posts: 20Questions: 1Answers: 0

  6:13PM

  Thanks Allan,
  The nightly build seems to fix the loop issue, thanks for getting on that so quickly!

  I'll let you know if I encounter anything else.
• Sirolli Posts: 3Questions: 1Answers: 0

  6:17PM edited 6:17PM

  I upgraded to 3.0.1 today and am experiencing this issue. I'm using the columnControl searchDropdown, and it looks like the date columns are still breaking it, causing an infinite loop. I have everything in columnDefs:

  {
              targets: '_all',
              columnControl: {
                  target: 0,
                  content: ['reorder', 'order',
                      // // Original content option that breaks
                      // {
                      //     extend: 'searchDropdown',
                      //     allowSearchList: true,
                      //     search: false,
                      //     select: false,
                      // },
                      // // Replaced the above with this to work around the issue:
                      {
                          extend: 'dropdown',
                          text: 'Search',
                          icon: 'search',
                          content: [{
                              extend: 'searchText',
                              allowSearchList: true,
                              search: false,
                              select: false,
                          }]
                      }]
              },
              className: 'collapsing',
              defaultContent: ''
  },
  
• Sirolli Posts: 3Questions: 1Answers: 0

  6:33PM

  My apologies, I thought I saw a comment saying this was fixed in 3.0.1, I just saw the above comments about the nightly builds. I also tested the nightly builds and it fixes the issue for me too.
• allan Posts: 65,856Questions: 1Answers: 10,956 Site admin

  7:21PM

  Awesome - many thanks for the updates everyone. Glad to hear that has fixed that particular issue. I'll tag up and release DT 3.0.2 probably towards the end of next week.

  Allan