Answers

• colin Posts: 15,142Questions: 1Answers: 2,586

  November 2022

  This section of the manual may help, it's showing how to perform field validation. In your case, what would cause the server side error to occur?

  Colin
• 3phi Posts: 5Questions: 1Answers: 0

  November 2022

  Colin, Thanks for the reply but I'm not sure how that would help me because I don't use PHP (nor .NET) libraries.

  I believe my use case is pretty simple. When I submit a "create" via ajax the server returns an error if the record to create already exists (or for whatever reason). All I want to do in this case is display an error message.

  Thanks

  PT
• kthorngren Posts: 20,269Questions: 26Answers: 4,765

  November 2022

  I think you just return the error in the fieldErrors object as described in the Client/server data docs.

  Kevin
• 3phi Posts: 5Questions: 1Answers: 0

  November 2022

  kthorngren, that actually worked! The "fieldErrors" did the trick however for it to work properly I have to call success() (on line 14) with the fieldErrors object. I was hopping to call error() instead but maybe I'm still missing something?

  In the code below, when the server returns HTTP status 406 I have to capture the status in the error: function and call success() with the fieldErrors info.

  exemple = new $.fn.dataTable.Editor( {
      table: "#exemple",
      ajax:function(method, url, data, success, error) {
          $.ajax({
              type: "POST",
              dataType: "json",
              data:data,
              url: url,
              success: function (response) { 
                  success( response );
              },
              error: function (xhr, err, thrown) {
                  if (xhr.status == 406) {
                      success( xhr.responseJSON );
                  } else {
                      error( xhr, err, thrown );
                  }
              }
          })
      },
      fields: [
          {
              type:  "select",
              label: "Select a Product from the Dropdown list :",
              name:  "prod.items",
              options: CIM.catgOptions()
          }
      ]    
  })
  

  Here's what the server returns:

  {
      "fieldErrors": [
          {
              "name": "prod.items",
              "status": "Product (709) $100 Deposit already added."
          }
      ]
  }
  

  

  Thanks,

  PT
• allan Posts: 61,650Questions: 1Answers: 10,093 Site admin

  November 2022

  There is a distinction in Editor between a "known error" and an "unknown error". We consider a validation error that is handled correctly to be a successfully handled request by the server (which is counter to how REST typically works, and what you are running into here). We do this because the code is all running successfully and as expected at that point.

  The error callback should only be called in the event of an unknown error - e.g. a JSON formatting error or the like.

  Allan
• 3phi Posts: 5Questions: 1Answers: 0

  November 2022

  Thanks Allan, Makes sense, it's all good.