JQuery DataTables Object Keys as Rows

Question

I'm using JQuery DataTables, and have an object like:

{
  table_rows: {
     row1: {val: value1},
     row2: {val: value2},
     ...
     rown: {val: valuen}
  }
}

I need to tell DataTables to use the object keys of the table_rows object as rows, but it will not. Every example I can find has table_rows as an array of objects, which would be have table_rows [ {val: val1}, {val: val2} ...]

Any ideas how to make the former work?

EDIT: Added example:

http://jsfiddle.net/mbaranski/gh95yhqe/

Here is an example.

How about creating the array in required format from the given object. — vinayakj
– vinayakj, Commented Nov 17, 2015 at 19:40
I'm using the ajax: { url: 'xyz', type: 'GET'}, columns: [ ???? ] spec. I cannot even figure out how to specify a value function with DataTables because they all want to pass 1 row at a time — mikeb
– mikeb, Commented Nov 17, 2015 at 19:42
do you have a minimal example that you can share on jsFiddle? — vinayakj
– vinayakj, Commented Nov 17, 2015 at 19:44
You need to convert object table_rows into array of objects before passing it to DataTables. Can you show expected table structure, i.e. what table columns do you expect to see? — Gyrocode.com
– Gyrocode.com, Commented Nov 17, 2015 at 20:13
See the edit, example is at: jsfiddle.net/mbaranski/gh95yhqe — mikeb
– mikeb, Commented Nov 18, 2015 at 12:42

Gyrocode.com · Accepted Answer · 2015-11-18 21:28:01Z

1

You can write your own function to convert one format to another, for example:

function formatData(data){
   var result = [];
   for(prop in data['indices']){
      if(data['indices'].hasOwnProperty(prop)){
         result.push({ 'indices': prop });
      }
   }
   return result;
}

See updated jsFiddle for code and demonstration.

If you're using Ajax sourced data, see this jsFiddle for an idea on how to use the function above.

edited Nov 18, 2015 at 21:28

answered Nov 18, 2015 at 19:49

Gyrocode.com

59k16 gold badges157 silver badges192 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

mikeb Over a year ago

That does indeed work, but I think you are missing an important point: I'm using the ajax: { url: 'xyz', type: 'GET'}, columns: [ ???? ], which does not work as you suggested.

mikeb Over a year ago

I had hard coded the data in the fiddle because the "echo" stuff didn't work and I was in a bit of a hurry

Gyrocode.com Over a year ago

@mikeb, updated answer with an example for Ajax-sourced data.

mikeb Over a year ago

That is it, couldn't find that particular bit in the documentation. Thank you very much.

Collectives™ on Stack Overflow

JQuery DataTables Object Keys as Rows

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related