Answers

• allan Posts: 63,540Questions: 1Answers: 10,476 Site admin

  January 2020

  I might not quite be getting something, but in your Editor JS configuration you have two fields which are select:

  • MasterStops.SMS_StopsID
  • MasterStops.DayNumber

  On the server-side you have a single field which is using the Options class:

  • sms_stops.LOCATIONNM

  I don't see that field in the client-side Editor. So I'm a little confused as to which field those options should be appearing in?

  Thanks,
  Allan
• charlesh Posts: 3Questions: 1Answers: 0

  January 2020

  In my original post I failed to post the ViewModel for the two tables.

  MasterStops is the main table. The field SMS_StopsID joins the sms_stops table to get ‘LOCATIONNM’. The select field needs to show the ‘LOCATIONNM’ with the value being the sms_stops.ID and stored in MasterStops.sms_stopsID. Hope this helps explain better. The issue is that the dropdown list contains no values.

  public class JoinModelMastStops
  {
      //public int ID { get; set; }
      public string USPSTrip { get; set; }
      public string SMS_Stage { get; set; }
      public string Nass_Code { get; set; }
      public string SchArvTime { get; set; }
      public string SchDepTime { get; set; }
      public Nullable<int> DayNumber { get; set; }
      public Nullable<int> StopNumber { get; set; }
      public Nullable<int> SMS_StopsID { get; set; }
  }
  public class JoinModelSMSStops
  {
      //public int ID { get; set; }
      public string LOCATIONNM { get; set; }
      public string STOPTYPE { get; set; }
  }
  

  }

  also here is the new javascript:

  document.getElementById("Loading").style.display = "none";
  $(document).ready(function () {
      $(function () {
          $(".checkinout").mask("99:99");
          $(".time").mask("99:99", { placeholder: "0" });
          //$(".miles").mask("9999.99", { placeholder: "_" });
          $(".hours").mask("999.99", { placeholder: "0" });
          $(".initials").mask("aaa");
      });
      $(".dtp").datepicker();
      var editor = new $.fn.dataTable.Editor({
          ajax: '@Session["RootFolder"]' + '/TripMasters/Table',
          table: '#schedtable',
          fields:
              [
                  { label: 'POTRIP', name: 'MasterStops.USPSTrip' },
                  { label: 'Stage', name: 'MasterStops.SMS_Stage' },
                  { label: 'Stop Name', name: 'options.MasterStops.SMS_StopsID', type: "select" },
                  { label: 'StopType', name: 'sms_stops.STOPTYPE' },
                  { label: 'Nass', name: 'MasterStops.Nass_Code' },
                  { label: 'Arrive', name: 'MasterStops.SchArvTime' },
                  { label: 'Depart', name: 'MasterStops.SchDepTime' },
                  { label: 'Day #', name: 'MasterStops.DayNumber' },
                  { label: 'Stop Order', name: 'MasterStops.StopNumber' }
              ]
      })
  
      $('#schedtable').on('click', 'tbody td.editable', function (e) {
          editor.inline(this, {
              onBlur: 'submit'
          });
      });
  
      $('#schedtable').DataTable({
          dom: 'Bfrtip',
          ajax: '@Session["RootFolder"]' + '/TripMasters/Table',
          model: 'JoinMastStops',
          "scrollY": "300px",
          "scrollCollapse": true,
          "paging": false,
          "bFilter": false,
          "paging": false,
          "bFilter": false,
          "order": [[8, 'asc']],
          columns:
              [
                  { data: 'MasterStops.USPSTrip', className: 'editable' },
                  { data: 'MasterStops.SMS_Stage', className: 'editable' },
                  { data: 'sms_stops.LOCATIONNM', className: 'editable', editField: "MasterStops.SMS_StopsID" },
                  { data: 'sms_stops.STOPTYPE', className: 'editable' },
                  { data: 'MasterStops.Nass_Code', className: 'editable' },
                  { data: 'MasterStops.SchArvTime', className: 'editable' },
                  { data: 'MasterStops.SchDepTime', className: 'editable' },
                  { data: 'MasterStops.DayNumber', className: 'editable' },
                  { data: 'MasterStops.StopNumber', className: 'editable' }
              ],
          columnDefs:
              [
                  { "targets": [0], "orderable": false },
                  { "targets": [1], "orderable": false },
                  { "targets": [2], "orderable": false },
                  { "targets": [3], "orderable": false },
                  { "targets": [4], "orderable": false },
                  { "targets": [5], "orderable": false },
                  { "targets": [6], "orderable": false },
                  { "targets": [7], "orderable": false },
                  { "targets": [8], "orderable": false },
              ],
          select: {
              style: 'os',
              collection: 'Location'
          },
          buttons:
              [
                  //{ extend: "create", editor: editor },
                  //{ extend: "edit", editor: editor },
                  //{ extend: "remove", editor: editor }
              ]
      })
  });
  document.getElementById("TripEdit").style.display = "flex";
  
• allan Posts: 63,540Questions: 1Answers: 10,476 Site admin

  January 2020 Answer ✓

  Thank you for the additional information - try this:

          .Field(new Field("MasterStops.SMS_StopsID")
              .Options(new Options()
                  .Table("sms_stops")
                  .Value("ID")
                  .Label("LOCATIONNM")
              )
          )
  

  That will get the value for the field from MasterStops.SMS_StopsID and then use sms_stops entries for the dropdown list.

  Allan
• charlesh Posts: 3Questions: 1Answers: 0

  January 2020

  Thank you so much. I spent 3 days trying to solve the problem. Have a blessed day.