Answers

• allan Posts: 63,471Questions: 1Answers: 10,467 Site admin

  July 2021

  Do you mean like this?

  Allan
• ubdpeters Posts: 26Questions: 8Answers: 0

  July 2021

  Yes, kind of like that. I'll look at that example a little more.
• ubdpeters Posts: 26Questions: 8Answers: 0

  July 2021 edited July 2021

  I looked at the example some more and understand how it's working.
  Is there a way to pass data to the ajax request for the datatable field in the editor? I only want to display specific items from a table. Not all items the example.
  If I have a part number: 1234 and items 1, 5, 10 are associated with it, I only want to display those items in the editor datatable. Not items 1 - 10.

  From nested.html:

              }, {
                  label: 'Site:',
                  name: 'users.site',
                  type: 'datatable',
                  editor: siteEditor,
                  optionsPair: {
                      value: 'id',
                  },
                  config: {
                      ajax: '../../controllers/sitesNested.php',
  ****Like this                     data: function(d) {
                                            d.Id = dataFromAnotherTable;
                                          },
                      buttons: [
                          { extend: 'create', editor: siteEditor },
                          { extend: 'edit',   editor: siteEditor },
                          { extend: 'remove', editor: siteEditor }
                      ],
                      columns: [
                          {
                              title: 'Name',
                              data: 'name'
                          },
                          {
                              title: 'Continent',
                              data: 'continent'
                          }
                      ]
                  }
              }
  

  Edited by Colin - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.
• colin Posts: 15,240Questions: 1Answers: 2,599

  July 2021 edited July 2021 Answer ✓

  You can access the main table still in that ajax.data function - so something like:

  $('#mainTable').DataTable().row('selected: true').data()
  

  which you can then pull out the field you're interested in and include like you are. Hope that helps,

  Colin
• ubdpeters Posts: 26Questions: 8Answers: 0

  July 2021

  I'm getting: Uncaught TypeError: Cannot read property 'DT_RowId' of undefined
  when I try using the ajax.data function.
• colin Posts: 15,240Questions: 1Answers: 2,599

  July 2021

  We would need to see that. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

  Cheers,

  Colin
• ubdpeters Posts: 26Questions: 8Answers: 0

  July 2021

  I get the same error message if I add the ajax.data function to the example nested.html file.

          fields: [ {
                  label: 'First name:',
                  name: 'users.first_name'
              }, {
                  label: 'Last name:',
                  name: 'users.last_name'
              }, {
                  label: 'Phone #:',
                  name: 'users.phone'
              }, {
                  label: 'Site:',
                  name: 'users.site',
                  type: 'datatable',
                  editor: siteEditor,
                  optionsPair: {
                      value: 'id',
                  },
                  config: {
                      ajax: '../../controllers/sitesNested.php',
                      data: function(d) {
                          console.log("hello");
                      },
                      buttons: [
                          { extend: 'create', editor: siteEditor },
                          { extend: 'edit',   editor: siteEditor },
                          { extend: 'remove', editor: siteEditor }
                      ],
                      columns: [
                          {
                              title: 'Name',
                              data: 'name'
                          },
                          {
                              title: 'Continent',
                              data: 'continent'
                          }
                      ]
                  }
              }
  
• tangerine Posts: 3,365Questions: 39Answers: 395

  July 2021

  We would need to see that. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.