Value is not a dropdown field

Value is not a dropdown field

Andreas S.Andreas S. Posts: 208Questions: 74Answers: 4
edited August 2023 in SearchBuilder

I have a problem with the searchBuilder. If is select a condition the value field would be replace from a dropdown field to a input field.
I search for a while in the Forum, but i did not find a similar problem as my problem. Have you an idea whats wrong in my code?

Andreas

     let table = $('#userTable').DataTable({
      ajax: "{{ route('admin.users.index') }}",

      order: [2, 'ASC'],
      searchBuilder: {},

      language: {
        searchBuilder: {
          button: '<i class="fa-duotone fa-user-magnifying-glass fa-lg dt-btn-duotone"></i>',
        }
      },

      columnDefs: [{
        target: [0, 1],
        className: 'text-center'
      }, {
        searchBuilder: {
          defaultCondition: '=',
          orthogonal: {
            display: 'filter'
          }
        },
        target: [2, 3],
        className: '',
        orderable: true,
        searchable: true
      }, {
        targets: '_all',
        className: '',
        orderable: false,
        searchable: false
      }],

      columns: [{
        data: 'user_status'
      }, {
        data: 'user_nation'
      }, {
        data: 'name',
        name: 'name'
      }, {
        data: 'club.shortName'
      }, {
        data: 'roles'
      }, ],
      buttons: dtButtons,
      initComplete: function() {
        $('#userTable').removeClass('d-none').addClass('d-table');
      }
    });

This question has an accepted answers - jump to answer

Answers

  • kthorngrenkthorngren Posts: 21,261Questions: 26Answers: 4,934

    This will happen if you have server side processing enabled. But it doesn't look like you do. Can you post a link to your page or a test case replicating the issue so we can help debug?
    https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

    Kevin

  • Andreas S.Andreas S. Posts: 208Questions: 74Answers: 4

    Send a link via pm

    Andreas

  • kthorngrenkthorngren Posts: 21,261Questions: 26Answers: 4,934
    Answer ✓

    It looks like you have server side processing enabled although your Datatables init code doesn't have serverSide: true. Maybe you Default Settings configured somewhere. Possibly in finsw.stoneship.at/build/assets/datatables-85486f6d.js.

    The SearchBuilder server side processing docs state this:

    There are two caveats that SearchBuilder's server-side integration carries. The first is that anywhere select elements would normally be used on the client-side, input elements are used instead. This reduces strain on the server significantly, drastically improving performance.

    What you are seeing is expected behavior with server side processing. Looks like you have 55 records. Disabling server side processing will allow you to have the select options.

    Kevin

  • Andreas S.Andreas S. Posts: 208Questions: 74Answers: 4

    Thanks for the clarification

    Andreas

Sign In or Register to comment.