Replies

• rf1234 Posts: 2,922Questions: 87Answers: 414

  October 2020

  I don't understand your question at all which doesn't prevent me from answering it

  The only thing I understand is this:

  The most appropriate one was: https://datatables.net/reference/option/ajax however, the example did not help me understand what to do in my case - some columns should display data from several database fields.

  And I can answer this question:

  some columns should display data from several database fields.

  You do that with columns.render: https://datatables.net/reference/option/columns.render

  Here is an example from my own coding using multiple database fields returned from the server: ctr.ctr_name, ctr.serial, ctr.purpose, ctr.soft_deleted and ctr.expired.

  columns: [
      {   data: "ctr.ctr_name",
          render: function ( data, type, row ) {
              var str = renderPurpose(row.ctr.serial, row.ctr.purpose, data);
              if ( row.ctr.soft_deleted > 0 ) { 
                  var del = lang === 'de' ? '[Gelöscht]' : '[Deleted]';
                  str += '<br><span class="text-danger-plus">' + del + '</span>';
              } else if ( row.ctr.expired > 0 ) {
                  var exp = lang === 'de' ? '[Endgültig beendet]' : '[Finally ended]';
                  str += '<br><span class="text-danger-plus">' + exp + '</span>';
              }
              return str;
          }
      },
  

  Just as a hint: It helps typing your question into something like Google Translate or even better: deepl.com - to have it translated into English. English is not my first language either.

  Just did it with the previous paragraph and translated it into German using deepl.com which is far better than Google. Well, that's comprehensible German to me!

  Nur als Tipp: Es hilft, Ihre Frage in etwas wie Google Translate oder noch besser: deepl.com einzugeben, um sie ins Englische übersetzen zu lassen. Englisch ist auch nicht meine erste Sprache.