MVC JQUERY ROW field value

Question

MVC JQUERY ROW field value

SSinhg 316

Hi - I am using JqueryDatatables to display data on page.
How do I get value of a field inside row ?

Screengrab of what I tried

AgaveJoe 30,126 Reputation points

2022-06-21T12:32:31.02+00:00

Unfortunately, you have not provided enough code to understand the actual problem.

The jQuery DataTable column definition has the render callback you can use to fetch the row values and manipulate the results.

columns.render

If you are trying to fetch values using a jQuery selector, then we need the actual HTML otherwise we cannot answer this question. However, you can the browser dev tools to find the selector.

The jQuery DataTable forum is a better place to get jQuery DataTable help.

https://datatables.net/forums/

Accepted answer

0 additional answers

Your answer

AgaveJoe 30,126 Reputation points

2022-06-21T12:32:31.02+00:00

Unfortunately, you have not provided enough code to understand the actual problem.

The jQuery DataTable column definition has the render callback you can use to fetch the row values and manipulate the results.

columns.render

If you are trying to fetch values using a jQuery selector, then we need the actual HTML otherwise we cannot answer this question. However, you can the browser dev tools to find the selector.

The jQuery DataTable forum is a better place to get jQuery DataTable help.

https://datatables.net/forums/

Answer 1

AgaveJoe 30,126

You have to understand that it is impossible to suggest an accurate solution when you do not provide all the information. Especially when you do not provide the HTML and property names. The screenshot looks like the property name has a space; "P Action". If there is a space then the syntax is...

var TFQ = row["P Action"]

The screenshot also shows a space in front of Required; " Required".

Lastly, .val() is used to get the value of an input element. Are you trying to grab the value of an input or the row data?

If there are no spaces in the property name or value then the syntax is...

    if(row.PropertyName == "SomeValue") {   
       //Do something  
    }

SSinhg 316

Thanks @AgaveJoe
I used Render to tap into the row.

Row contains all the values in an array. e.g. below

Sample code for render

"targets": [10],  
                            "render": function (data, type, row, meta) {  
                                debugger;                                  
                                if (type === 'display') {  
                                    data = "<input type='button' value='Add' id='addEntry' onclick='onclickdetails(" + data + ")'  class='btn btn-primary btn-xs' />"; // Here I add button  
                                    var TFQ = $(row.PAction).val(); // based on some value I wish to change the behaviour like disale the button if value is not "Rocket science"  
                                    if (TFQ == "Required") {  
                                        alert("HI");  
                                    }  
                                }  
                                return data;  
                            }

SSinhg 316 Reputation points

2022-06-21T21:03:31.28+00:00
Thanks for hanging on!

your response pointed out many mistakes I was making. I was putting $(row.PAction).val() and this would never work.

row.PAction got things going....

How do I accept your response as answer?
Lan Huang-MSFT 30,186 Reputation points Microsoft External Staff

2022-06-22T06:03:32.577+00:00

Hi @SSinhg ,
You just need to click "More"-->"Convert to answer"-->"Accept answer".

Best regards,
Lan Huang

Share via

MVC JQUERY ROW field value

0 additional answers

Your answer