Answers

• ak47 Posts: 16Questions: 5Answers: 2

  June 2022 edited June 2022

  And of course I can't do this:

   editor = new ($.fn.dataTable.Editor)(
      ajax: {
        url: 'listings/' + $('.selected').attr('id')
        method: 'PUT'
        data: (d) ->
          console.log $('.selected')
          console.log $('.selected').attr('id')
          d.id = '123'
        }
      table: '#listings_table'
      fields: [...
  

  Because $('.selected').attr('id') is blank on page load.
• kthorngren Posts: 21,354Questions: 26Answers: 4,955

  June 2022 Answer ✓

  Looks like you can use the ajax() API to change the URL.

  Kevin
• ak47 Posts: 16Questions: 5Answers: 2

  June 2022

  It works on the DataTable object, but I kept getting:

  editor.ajax.url is not a function
  

  editor is indeed defined earlier in my Javascript, so, not sure what's going on there.

  I found this:

  https://editor.datatables.net/reference/option/ajaxUrl

  which almost gives me the flexibility I need but unfortunately it's deprecated. I'm trying to hook Editor up against a REST API where I need different urls for each CRUD action, as well as different methods (POST, PUT, DELETE).
• ak47 Posts: 16Questions: 5Answers: 2

  June 2022

  The only thing I can think of is I'm going to have to override the ajax of the editor upon click of the New, Edit, and Delete buttons.
• ak47 Posts: 16Questions: 5Answers: 2

  June 2022

  Check it out, I got it working. First I add classes to the buttons in the DataTable:

      buttons: [ 'copy', 'excel', 'pdf',
          { extend: 'create', editor: editor, className: 'table-button create' },
          { extend: 'edit',   editor: editor, className: 'table-button edit' },
          { extend: 'remove', editor: editor, className: 'table-button delete' }
      ]
  

  Then I listen for a click on those specific buttons, and set the ajax using different values:

    $("body").on 'click', '.table-button', (e) ->
      classList = $(this).attr("class")
      if ~classList.indexOf('edit')
        editor.ajax ({
          url: location.pathname + '/' + $('.selected').attr('id')
          method: 'PUT'
          data: (d) ->
            d.id = $('.selected').attr('id')
          })
      else if ~classList.indexOf('create')
        editor.ajax ({
          url: location.pathname
          method: 'POST'
          data: (d) ->
            d.id = $('.selected').attr('id')
          })
      else if ~classList.indexOf('delete')
        editor.ajax ({
          url: location.pathname + '/' + $('.selected').attr('id')
          method: 'DELETE'
          data: (d) ->
            d.id = $('.selected').attr('id')
          })
  

  Works across all my controllers automatically in my Ruby on Rails application.
• kthorngren Posts: 21,354Questions: 26Answers: 4,955

  June 2022

  editor.ajax.url

  Looks like you are using the ajax() API incorrectly. It is different than the Datatables ajax.url() API. See the example in the docs.

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

  June 2022

  In Editor's ajax option, you can use {id} in the URL string and Editor will substitute it:

  ajax: {
    url: 'listings/{id}',
    ...
  }
  

  There is an example of that available here.

  Allan