jQuery Datatable access row data ( render parameter ) on jQuery click event

Question

I have created link in datatable as:

$('#example').dataTable( {
    "columnDefs": [ {
        "targets": 1,
        "render": function ( data, type, full, meta ) {
            return '<a href="'+data+'" data-id="'+full.id+'">Download</a>';
         }
      } ]
} );

I can access id on clicking <a> tag using jQuery click event, but I have several fields to access. And I don't want to use data- attribute to access each field.

How can I access row object i.e.(full) , in jQuery event ?

What I have tried is:

"render": function ( data, type, full, meta ) {
    alert(full);
    return '<a href="'+data+'" data-full="'+full+'">Download</a>';
}

In jQuery event alert( $(this).data('full') ); I can see only [Object object].
I have tried to convert it to String but no success.

Instead of alert use console.log($(this).data('full'))

Offir
– Offir

2017-03-15 10:01:12 +00:00
Commented Mar 15, 2017 at 10:01 — Offir
– Offir, Commented Mar 15, 2017 at 10:01
ok, I will try and let u know

Shantaram Tupe
– Shantaram Tupe

2017-03-15 10:04:29 +00:00
Commented Mar 15, 2017 at 10:04 — Shantaram Tupe
– Shantaram Tupe, Commented Mar 15, 2017 at 10:04
@OffirPe'er still printing [object Object]

Shantaram Tupe
– Shantaram Tupe

2017-03-15 10:07:01 +00:00
Commented Mar 15, 2017 at 10:07 — Shantaram Tupe
– Shantaram Tupe, Commented Mar 15, 2017 at 10:07
Its ajax call, will take time to create fiddle

Shantaram Tupe
– Shantaram Tupe

2017-03-15 10:09:56 +00:00
Commented Mar 15, 2017 at 10:09 — Shantaram Tupe
– Shantaram Tupe, Commented Mar 15, 2017 at 10:09

Gyrocode.com · Accepted Answer · 2017-03-15 11:27:47Z

1

Use row().data() API method to get data for any given row.

For example:

$('#example').on('click', 'tbody a', function(){
   var $tr = $(this).closest('tr');
   var data = table.row($tr).data();
   console.log(data);
});

See this example for code and demonstration.

answered Mar 15, 2017 at 11:27

Gyrocode.com

59k16 gold badges157 silver badges192 bronze badges

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

4 Comments

Shantaram Tupe Over a year ago

I already tried this it only gives me visible column values, but one of my requirement is to get hidden field also

Gyrocode.com Over a year ago

@shantaram_t, It's not true, it will return the array/object that was received from the server including data fields that are not shown in the table.

Shantaram Tupe Over a year ago

then I will give another try , and let u know

Shantaram Tupe Over a year ago

Thanks it worked now, problem I tried to access it using array notation [ ]

Daniel Wei · Accepted Answer · 2017-03-15 10:04:52Z

0

Try jquery .data() to set / get data

$(your_component).data("full", full)

or

JSON.stringify(full) // convert json to string

answered Mar 15, 2017 at 10:04

Daniel Wei

6391 gold badge8 silver badges12 bronze badges

9 Comments

Shantaram Tupe Over a year ago

I just want to get it also tried JSON.stringify( $(this).data(full) ) , but no success

Daniel Wei Over a year ago

To get data, you should use $(this).data('full'), the param is not an object. You can try alert(JSON.stringify($(this).data('full'))) to check your object is right. If you are using Chrome, developer tools for debugging is better.

Daniel Wei Over a year ago

Change return '<a href="'+data+'" data-full="'+full+'">Download</a>'; to return '<a href="'+data+'" data-full="'+JSON.stringify(full)+'">Download</a>';

Shantaram Tupe Over a year ago

This will do trick, but I have large data, only need to access 5-6 attributes, then It will be better if I use data- for these fields

Shantaram Tupe Over a year ago

JSON.stringify(full) will be long String, can't I pass it as an Obect ?

|

Collectives™ on Stack Overflow

jQuery Datatable access row data ( render parameter ) on jQuery click event

2 Answers 2

4 Comments

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related