Replies

• allan Posts: 63,381Questions: 1Answers: 10,449 Site admin

  February 2014 edited February 2014

  > But I don't have a way to define recordsTotal, recordsFiltered, and draw.
  
  Is that information actually in the JSON data? Do you actually want to use server-side processing with the server doing all the processing?
  
  If so, what you will need to do is define dataSrc as a function and map the values that SOLR replies with, to the property names DataTables expects: http://next.datatables.net/reference/option/ajax#function .
  
  [code]
  $('#example').dataTable( {
  "ajax": function (data, callback, settings) {
  var o = {
  recordsTotal: data.response.numFound,
  recordFiltered: data.response.numFound,
  data: data.response.docs
  };
  callback( o );
  }
  } );
  [/code]
  
  or something like that - I doubt I've used the correct parameter names!
  
  Would be interested in seeing your final code if you would be filling to share it, either here or as a comment on the Ajax doc page.
  
  Allan
• SOLR_JOHN Posts: 7Questions: 0Answers: 0

  February 2014

  Thanks for the advice Allan. Yes I was hoping to use SOLR for all the data processing. I'm still having issues mapping the property names that DataTables expects. Using the example and the sample code you showed, I still can't seem to write the correct code to map the values. Again, my javascript knowledge is extremely limited so perhaps I'm doing something wrong or missing something.
  
  [code]
  $('#example').dataTable( {
  "processing":true,
  "serverSide":true,
  "ajax": function (data, callback, settings) {
  var o = {
  recordsTotal: data.response.numFound,
  recordFiltered: data.response.numFound,
  data: data.response.docs
  };
  $.ajax {(
  url": ""solr-url",
  "data": {'wt':'json', 'q':'*:*', 'rows':'10'},
  "dataType": "jsonp",
  "jsonp":"json.wrf",
  "dataSrc": "callback( o )"
  )};
  },
  "aoColumns": [
  {"data" : "company" },
  {"data" : "address" , "sDefaultContent": "" }
  ]
  } );
  
  [/code]
  
  I'm confused as to where to put the parameters for the ajax callback for the solr-url itself. The way I have it right now, I just get an error saying "Requested unknown parameter..." Which tells me it's not being mapped correctly.
• allan Posts: 63,381Questions: 1Answers: 10,449 Site admin

  February 2014 edited February 2014

  > "dataSrc": "callback( o )"
  
  That's not going to work - it is looking for a parameter in the data source called `callback( o )` rather than executing your callback function.
  
  You want something like:
  
  [code]
  "dataSrc": function ( json ) {
  return {
  recordsTotal: json.response.numFound,
  recordFiltered: json.response.numFound,
  data: json.response.docs
  };
  }
  [/code]
  
  Allan
• SOLR_JOHN Posts: 7Questions: 0Answers: 0

  February 2014

  I tried your suggestion and it feels like we're getting closer, but DT returned "no matching records found". That tells me it's not accessing the data correctly. Am I supposed to parse the JSON somehow to point at those values or does DT handle it somehow?
  
  [code]
  $('#example').dataTable( {
  "processing":true,
  "serverSide":true,
  "ajax": {
  url": ""solr-url",
  "data": {'wt':'json', 'q':'*:*', 'rows':'10'},
  "dataType": "jsonp",
  "jsonp":"json.wrf",
  "dataSrc": function (json) {
  return {
  recordsTotal: "response.numFound",
  recordsFiltered: "response.numFound",
  data: "response.docs"
  };
  }
  },
  "aoColumns": [
  {"data" : "company" },
  {"data" : "address" , "sDefaultContent": "" }
  ]
  } );
  [/code]
  
  Thanks again for your help.
• allan Posts: 63,381Questions: 1Answers: 10,449 Site admin

  February 2014 edited February 2014

  > "response.docs"
  
  Why are you giving it strings? The data is in the `json` object. Use the object structured like I suggested above and it might just work.
  
  Edit - I see I had a typo where I used `data` rather than `json` - fixed now. But still don't use strings :-)
  
  Allan
• SOLR_JOHN Posts: 7Questions: 0Answers: 0

  February 2014

  Thanks for the response. I did actually notice the typo prior to my last post. I did try with just the json object and the corresponding json path but no luck. I can't see what else could be missing. The data does return successfully if I just gave it "dataSrc: response.docs" but in the function json format, it doesn't even return any data back. Let alone the records total and filtered.
  
  [code]
  $('#example').dataTable( {
  "processing":true,
  "serverSide":true,
  "ajax": {
  url": ""solr-url",
  "data": {'wt':'json', 'q':'*:*', 'rows':'10'},
  "dataType": "jsonp",
  "jsonp":"json.wrf",
  "dataSrc": function (json) {
  return {
  recordsTotal: json.response.numFound,
  recordsFiltered: json.response.numFound,
  data: json.response.docs
  };
  }
  },
  "aoColumns": [
  {"data" : "company" },
  {"data" : "address" , "sDefaultContent": "" }
  ]
  } );
  
  [/code]
• allan Posts: 63,381Questions: 1Answers: 10,449 Site admin

  February 2014

  I would need to be able to see the page to be able to understand what is going wrong. Can you give me a link?
  
  Allan
• phax Posts: 18Questions: 5Answers: 0

  February 2014 edited February 2014

  Btw. there is a quoting error in [code]url": ""[/code]
  I assume it should be
  [code]"url": "[/code]
• allan Posts: 63,381Questions: 1Answers: 10,449 Site admin

  February 2014

  That'd do it... Eagle eyes :-)
  
  Allan
• SOLR_JOHN Posts: 7Questions: 0Answers: 0

  March 2014

  Sorry for my super delayed response.
  
  The typos are real. But that isn't the reason why the code is not working. I've been working offline, so I definitely have a few (a lot) of typos as I transfer some of my sample code.
  
  I've taken the time to set it up using a solr indexer from berkley and the live datatables (thank you for providing it).
  
  The first example shows the result when I have "dataSrc": "response.docs". And the results (as you can see there data being returned).
  
  http://live.datatables.net/yinobuz/1/edit?html,css,js,output
  
  The 2nd example shows the result when I use "dataSrc" : function(json). As you can see, nothing gets returned back.
  
  http://live.datatables.net/gotucum/6/edit
  
  If anyone has time to take a quick look at this for me and figure out what we can do to get this puppy up and running, I would owe a great debt of gratitude.
• SOLR_JOHN Posts: 7Questions: 0Answers: 0

  March 2014

  Any feedback on this one?
• allan Posts: 63,381Questions: 1Answers: 10,449 Site admin

  March 2014

  Sorry about this - I lead you down the garden path! I thought I'd abstracted this out a bit, but it turns out not - specifically this is the issue here: https://github.com/DataTables/DataTablesSrc/blob/master/js/core/core.ajax.js#L295 .
  
  The data source is evaluated _after_ the length parameters are parsed, and it is expecting the data array to be returned from it, not the full source object.
  
  In which case, you need to make your own Ajax call: http://live.datatables.net/gotucum/9/edit
  
  Allan
• SOLR_JOHN Posts: 7Questions: 0Answers: 0

  March 2014

  Hi Allan,
  
  Thanks so much for your help and patience on this one. I was trying to write my own callback at some point but I just don't know jquery syntax well enough to get there. Your example code looks great and I'm excited to finally use datatables for my solution even if it means writing my own ajax call. I'll need to take some time to learn more client side programming as it's powerful stuff!
  
  Keep up the great work, and I'm looking to donate some money for this awesome support and development. Perhaps this specific case will be covered in a future release of DT?
• allan Posts: 63,381Questions: 1Answers: 10,449 Site admin

  March 2014

  Possibly yet. I'm not 100% sure how at the moment, as dataSrc needs to stay as it currently is, for backwards compatibility. So it would need a new mechanism. There has been a request for being able to change the server-side processing property names before, I just need to work out a clean and simple way of doing it!
  
  Allan