topic Re: Jquery Datatable create a manual ID field in ArcGIS JavaScript Maps SDK Questions

Jquery Datatable create a manual ID field

Anonymous User — Fri, 10 Dec 2021 22:53:06 GMT

Hello all,

I would like the user to be able to input an ID (same ID for all selected features) to a table via an input textbox. I keep getting mixed results.

This wont work:

var input;
 $("#tesr").change(function () {
                  console.log($("#tesr").val());
                  input = $("#tesr").val();
              });

$.each(featureSet.features, function (index, value) {
                      row = [];
                      row.push(input);
                      
                      $.each(value.attributes, function (index2, value2) {
                          row.push(value2);
                      });
                      data.push(dojo.clone(row));
                  });‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

if it is hard coded then it will work as wanted:

$.each(featureSet.features, function (index, value) {
                      row = [];
                      row.push("22");
                      
                      $.each(value.attributes, function (index2, value2) {
                          row.push(value2);
                      });
                      data.push(dojo.clone(row));
                  });‍‍‍‍‍‍‍‍‍

I am not sure what I am missing. Thanks,

Alex

Re: Jquery Datatable create a manual ID field

RobertScheitlin__GISP — Sat, 03 Dec 2016 16:47:02 GMT

Alex,

In your hard coded example you are using a string "28" and in your other I am not sure if it is a string or a number. That may be your issue.

Re: Jquery Datatable create a manual ID field

Anonymous User — Sat, 03 Dec 2016 17:27:22 GMT

I tried jquery .text() but no luck. How would I pass the input text box value to string?

Re: Jquery Datatable create a manual ID field

RobertScheitlin__GISP — Sat, 03 Dec 2016 23:18:55 GMT

In js it is just .toString();

Re: Jquery Datatable create a manual ID field

FC_Basson — Mon, 05 Dec 2016 08:26:53 GMT

Use the "keyup" event instead of the "change" event as listener for setting the value for "input". The .val() function should return the input text value, otherwise go old school and use document.getElementById('tesr').value

Re: Jquery Datatable create a manual ID field

Anonymous User — Fri, 10 Dec 2021 22:53:10 GMT

//keyup results
var input = $("#tesr").keyup(function () {
console.log($("#tesr").val());
$("#tesr").val();
});
 
cols.push({ 'sTitle': "ID" });

//create columns
$.each(featureSet.fields, function (index, value) {
cols.push({ 'sTitle': value.name });

});

//create rows and push into data
$.each(featureSet.features, function (index, value) {
row = [];
row.push(input);

$.each(value.attributes, function (index2, value2) {
row.push(value2);
});
data.push(dojo.clone(row));
});
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Results:

[object Object]

document.getElementById('tesr').value gets me an empty column values.

Any idea why?

Re: Jquery Datatable create a manual ID field

FC_Basson — Wed, 07 Dec 2016 06:31:59 GMT

The only output for your Results should be in the keyup function and element #tesr refers to the input and not the column values. Also, what are you trying to achieve with $("#tesr").val(); in the keyup function?

For future, can you please use the syntax editor. Also, for your JSON objects, be consistent with the definition by using double quotes only e.g. cols.push({ "sTitle": "ID" });

Re: Jquery Datatable create a manual ID field

Anonymous User — Wed, 07 Dec 2016 15:30:31 GMT

Thank you for noticing the JSON inconsistency. Also, I would love to use the code syntax editor but dont see it in the reply toolbar.

What I am trying to achieve is to create a new ID column where the user manually input his ID value in a textbox. This column is added to a table of query results.

I have tried many ways to pass the ID values to this ID column but no success. (I have also tried the keyup function the way you describe).

Re: Jquery Datatable create a manual ID field

Anonymous User — Wed, 07 Dec 2016 16:21:28 GMT

Now I am getting this error.

Re: Jquery Datatable create a manual ID field

Anonymous User — Wed, 07 Dec 2016 21:24:59 GMT

I finally made it work with Robert's solution.

Re: Jquery Datatable create a manual ID field

Anonymous User — Fri, 10 Dec 2021 22:53:12 GMT

Here was my solution. It seems to solve my problem.

var  testresult, table;

$("#tesr").keyup(function () {
testresult = $("#tesr").val();
});


table = $('#example').DataTable({
"columnDefs": [{
"targets":[0],
"data": null,
"defaultContent": testresult
}]
});‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Jquery Datatable create a manual ID field

FC_Basson — Thu, 08 Dec 2016 06:15:41 GMT

This is what my toolbar looks like when posting - notice the Expand toolbar option. If you click on that you'll get an option for More, under which the Syntax Highlighter resides. See this post for a possible reason why: where is my syntax highlighting!!! | GeoNet

Re: Jquery Datatable create a manual ID field

Anonymous User — Thu, 08 Dec 2016 15:31:52 GMT

Thanks!