Answers

• dynasoft Posts: 446Questions: 69Answers: 3

  October 2019

  I need to add the underlying table field has a string data type
• colin Posts: 15,240Questions: 1Answers: 2,599

  October 2019

  Hi @dynasoft ,

  If the field is numeric, it would be best to store it without the comma in the DB so you can perform numeric operations, such as sorting. If you need it, it would be best to define the field in Editor as a string, then the entire syntax will be preserved.

  Cheers,

  Colin
• dynasoft Posts: 446Questions: 69Answers: 3

  October 2019

  Hi

  Thanks. I followed whats on https://editor.datatables.net/reference/option/fields.type but get error 'Uncaught Error adding field - unknown field type string'. Kindly advise.

          var editor = new $.fn.dataTable.Editor({
  
              ajax: {
                  url: '/CustomerSNs/CRUDCustomerSNs/',
                  data: {
                      intContTpe: intContTpe1,
                      lngContIdx: lngContIdx1,
                      lngItemIdx: lngItemIdx1
                  },
                  type: 'POST',
                  async: true,
                  cache: false
              },
              table: '#tblDataTable',
              template: '#EditorForm',
              fields: [ 
                  {
                      label: '@(lblo.lblExcludedNumbers)**:',
                      name: 'CustomerVoiceCLI.RangeExcludedNumbers',
                      type: 'string'
                  }
              ],
              i18n: {...}
          });
  
• dynasoft Posts: 446Questions: 69Answers: 3

  October 2019

  The field should be a string. It will hold comma separated values, some values can be numeric.
• allan Posts: 63,535Questions: 1Answers: 10,475 Site admin

  October 2019

  It looks like a bug I'm afraid. I've just managed to reproduce that here. I'll dig into it and post back here when done.

  Allan
• dynasoft Posts: 446Questions: 69Answers: 3

  October 2019

  Thought so as this only occurs when the data with the commas is numeric
• allan Posts: 63,535Questions: 1Answers: 10,475 Site admin

  October 2019 Answer ✓

  Commit here for the fix. I'm going to tag and release Editor 1.9.2 this Friday with that fix.

  Allan