How to return datetime to use in a function?
How to return datetime to use in a function?
![BradleyO07](https://secure.gravatar.com/avatar/bcb191fbc0addb5efe8a1af2c0e81c71/?default=https%3A%2F%2Fvanillicon.com%2Fbcb191fbc0addb5efe8a1af2c0e81c71_200.png&rating=g&size=120)
I am working on a reporting project for forklifts at my company. The reports from the forklift are done by the operators and are uploaded automatically to our database. I created a table to display these reports that will show a pass or fail. Currently what I am doing is displaying every report one by one. I would like for the report to show just the time, operator and asset. Then when you click a link, within the table, it will display all the reports for that timeframe. Currently when I click on the link I get an error code that just returns "viewReport(2023-07-22 07:57:58)" with an error that says "Uncaught SyntaxError: missing ) after argument list". This is how I currently have my columns set up within my datatable.
columns: [
{ data: null, render: function (data, type, row){
return "<a class=\"default-link\" onClick=\"viewReport(" + data.datetime + ")\">" + data.datetime;
} },
{ data: "operator" },
{ data: "asset" },
{ data: "inspection" },
{ data: "status",
render: function(data,type){
if (type === 'display'){
if(data === 'pass'){
return "<span style='color:green'>\u2714</span>";
} else if (data === 'fail'){
return "<span style='color:red'>\u2718</span>";
}
return data;
}
return data;
}
},
],
What could I add to my code to allow my code to return the date/time and allow me to display all the reports with that date/time? As I said currently the code it return the full date and time but I believe it is trying to subtract the numbers instead of seeing them as a string.
This question has an accepted answers - jump to answer
Answers
You will need to place the datetime value inside quotes. Since you are using double quotes for the
a
attributes you will need to use single quotes to turn the datetime into a string, something like this:It is recommended to use delegated events instead of
onclick()
to create click events as shown in this example. I built a simple example, based on your code, to demonstrate.https://live.datatables.net/rapuyaxo/1/edit
Kevin