Is there an option to clean the data of an entire column (column not row)?

[cesarreyes3]

I would like to clean the data of one or more columns but I can't find that functionality

ChatGPT gave me this option(but it does not take into account the frozen columns, footer row, and perhaps other features)

$("#miGrid").find("td[aria-describedby='myGrid_miColumn']").empty();

Another option would be(but I don't know how it will be in performance)

var ids = $("#myGrid").jqGrid('getDataIDs');
$.each(ids, function (index, rowid) {
    $("#miGrid").jqGrid('setCell', rowid, 'miColumn', '');
});

Does this functionality exist? or could it be a feature?

[tonytomov]

Hello,

Thanks for the recommendation. The recommendation of ChatGTP is ok (in case of performance), but as you say it does not take into account a lot of things. I think it is a good idea to have this feature. Hope to write it in couple of days.

I will let you know.

Best Regards,
Tony

[MymsMan]

Don't have a need at this point but would it make sense to have a function to set a column to any value including empty? Would make the function more generic than just an empty column function

…

On Fri, 7 Feb 2025 at 09:41, Tony Tomov ***@***.***> wrote: Hello, Thanks for the recommendation. The recommendation of ChatGTP is ok (in case of performance), but as you say it does not take into account a lot of things. I think it is a good idea to have this feature. Hope to write it in couple of days. I will let you know. Best Regards, Tony — Reply to this email directly, view it on GitHub <#1072 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AB63QUXATJOOFNFBKJL45FT2OR5TRAVCNFSM6AAAAABWUNX52SVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMNBSGQZTANZRGE> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

-- Bob Buxton

[cesarreyes3]

I had in mind something like cleanCols(columns), (clear one or more columns)
but I get the idea, something like setCol(column, value), (changes a column to a value that can be empty)

[tonytomov]

I have added the method with the two parameters - col - which can be name in colModel or position in colModel. The second parameter is the value to be set. The value can be a function with the following parameters :

value = function(value, data, rowObj)

• value is the value to be set
• data is object (name:val) containing all the data of the row and
• rowObj is the HTML row represented by the rows object in a table

The function should return value to be set in the column.

[cesarreyes3]

Great it works, thanks