How to use Datatables column data (done in js) in action button url’s last segment
I have a column data that gives the output of from a database table. I want to one of the columns data at the last segment of the url. My provided attachment photo shows the details. If anyone could help
data: ‘file_id’ to be used in url
JavaScript
x
35
35
1
<script type="text/javascript">
2
$(document).ready(function(){
3
4
$('#empTable').DataTable({
5
'processing': true,
6
'serverSide': true,
7
'serverMethod': 'post',
8
'ajax': {
9
'url':'<?=base_url()?>admin/Employee/empList'
10
11
},
12
dom: 'Bfrtip',
13
buttons: [
14
{extend: 'copy', attr: {id: 'allan'}}, 'csv', 'excel', 'pdf'
15
],
16
'columns': [
17
{ data: 'id_no' },
18
{ data: 'customer_name' },
19
{ data: 'seized_remarks' },
20
{ data: 'seized_date' },
21
{ data: 'release_probability' },
22
{ data: 'file_id' },
23
24
{ data: null,
25
defaultContent: '<a href="https://202.40.176.13/mahindra_portal/admin/seized_vehicles/individual_view/$file_id"><button ><i class="fa fa-search"></i></button></a> <input type="button" id="go" value="Upload Image" /> <button>Edit</button>' },
26
27
28
29
30
]
31
});
32
});
33
34
</script>
35
Advertisement
Answer
What you can do is define a render function, e.g.:
JavaScript
1
27
27
1
$('#empTable').DataTable({
2
'processing': true,
3
'serverSide': true,
4
'serverMethod': 'post',
5
'ajax': {
6
'url':'<?=base_url()?>admin/Employee/empList'
7
8
},
9
dom: 'Bfrtip',
10
buttons: [
11
{extend: 'copy', attr: {id: 'allan'}}, 'csv', 'excel', 'pdf'
12
],
13
'columns': [
14
{ data: 'id_no' },
15
{ data: 'customer_name' },
16
{ data: 'seized_remarks' },
17
{ data: 'seized_date' },
18
{ data: 'release_probability' },
19
{ data: 'file_id' },
20
{ data: null,
21
render(data) {
22
return `<a href="https://202.40.176.13/mahindra_portal/admin/seized_vehicles/individual_view/${data.file_id}"><button ><i class="fa fa-search"></i></button></a> <input type="button" id="go" value="Upload Image" /> <button>Edit</button>`;
23
}
24
},
25
]
26
});
27
This then lets you access whatever’s in the data
object. See the documentation