Answers

• kthorngren Posts: 21,343Questions: 26Answers: 4,954

  July 2020

  Does the Nested Objects example help?

  Kevin
• Pliachas Paschalis Posts: 69Questions: 13Answers: 1

  July 2020

  I'll try that and let you know.
• Pliachas Paschalis Posts: 69Questions: 13Answers: 1

  July 2020

  Sorry but i can't find out how this works.
  This is the place i need the returned value.

  ```

      editor.dependent(
  
          "tblMembers.CountryId",
          function (val, data, callback) {
  
              Object.keys(data).forEach(function (key) {
                  console.log(key, data[key]);
              });
  
              console.log(data.tblMembers[0].CountryId)
  
              // console.log(data.data['tblMembers.CountryId']);
              var fCountryCode = $('tblMembers.CountryId').val();
              console.log(fCountryCode);
              $.ajax({
                  url: 'php/regions.php',
                  dataType: 'json',
                  data: ({
                      fCountryCode: '1'//data.values.CountryId                        
                  }),
                  success: function (json) {
                      callback(json);
                      console.log(json);
                  }
              }
              )
          },
          {
              event: 'keyup change'
          }
      );
  

  i tried to get fCountryCode using jquery but with no success.
• allan Posts: 63,530Questions: 1Answers: 10,473 Site admin

  July 2020

  Where do you want access to it? For use in a DataTable column you would use data: 'tblMembers.CountryId'.

  Allan
• Pliachas Paschalis Posts: 69Questions: 13Answers: 1

  July 2020

  my table.members.js file is like that:

  ````

         var editor = new $.fn.dataTable.Editor({
          ajax: 'php/table.tblMembers.php',
          table: '#tblMembers',
          fields: [
              //some fields...
            {
                  "label": "Country:",
                  "name": "tblMembers.CountryId",
                  type: "select",
                  placeholder: "Select a Country",
                  //options: json.options['tblMembers.RegionId']//.RegionId
              },
              {
                  "label": "Region:",
                  "name": "tblMembers.RegionId",
                  type: "select",
                  placeholder: "Select a Region"
              },
             //other fields...
          ]
      });
     editor.dependent(
  
          "tblMembers.CountryId",
          function (val, data, callback) {
  
              var pCountryId = this.field( 'tblMembers.CountryId');
              var cfCountryCode =pCountryId.val();
              console.log(cfCountryCode);
              if (  pCountryId.val() ) {
                  console.log("pas");
                  $.ajax({
                      url: 'php/regions.php',
                      dataType: 'json',
                      data: ({
                          fCountryCode: cfCountryCode                     
                      }),
                      success: function (json) {
                          console.log(json);
                          console.log("pas");
                          callback(json);
  
                      }
                  })
              }
  
          },
          {
              event: 'keyup change'
          }
      );
     var table = $('#tblMembers').DataTable({
          dom: 'Bfrtip',
          ajax: 'php/table.tblMembers.php',
          columns: [
             //some columns....
              {
                  "data": "TblCountries.CountryName"
              },
              {
                  "data": "TblRegions.NameOfRegion"
              },
             //other columns....
          ],
          select: true,
          lengthChange: false,
          buttons: [
              { extend: 'create', editor: editor },
              { extend: 'edit', editor: editor },
              { extend: 'remove', editor: editor }
          ]
      });
  });
  

  my php file returns:
  {"options":{"tblMembers.RegionId":[{"label":"West Macedonia","value":"1"}]}}

  but until now i am unable to fill the "select" "name": "tblMembers.RegionId", with the returned json values.
  Am i missing the obvious?
• allan Posts: 63,530Questions: 1Answers: 10,473 Site admin

  July 2020

  Not unless I'm missing it as well! That response should cause the Editor field to have one option in the select list.

  Can you give me a link to the page so I can help to debug it please?

  Thanks,
  Allan
• Pliachas Paschalis Posts: 69Questions: 13Answers: 1

  July 2020

  thanks for your response. This is the link
  https://pliachaspaschalis.com/4plus-project/mainpage_demo.php
• allan Posts: 63,530Questions: 1Answers: 10,473 Site admin

  July 2020

  Thank you - but I'm afraid I'm not understanding then. Loading the page and clicking the New button shows me that the tblMembers.RegionId select is being populated with 4 options.

  

  Allan
• Pliachas Paschalis Posts: 69Questions: 13Answers: 1

  July 2020

  But the problem is that when the user selects the first country it should show only the records (from Regions table) that have the countrycode =1 or when select the second country only the records with countrycode=2.
  Now you see all the records instead of 3 in first case and one on the second case.
  
• Pliachas Paschalis Posts: 69Questions: 13Answers: 1

  July 2020 edited July 2020

  After making some corrections to region.php file it's working
• allan Posts: 63,530Questions: 1Answers: 10,473 Site admin

  July 2020

  Thanks for the update. Good to hear you’ve got it working.

  Allan