How to update an entire column of pq grid data

[rushabhwadkar]

We are having 3 columns in PQ grid as below -

• ID
• Timestamp
• Log

The timestamp column contains timestamp in UTC format. Our requirement is to change the timestamp based on the timezone selected by the user from UI. Is there a way to change the column data easily and refresh the view? What would you suggest?

Briefly speaking, If change the timezone to America/New York, I want to run a function which would fetch the data from PQGrid and change the column timestamp value based on the Timezone and update the data in the PQ Grid.

Note - Having the backend to send the updated data is not feasible so we're just currently targeting having the logic on the client side only.

[rushabhwadkar]

Please reply. It's urgent.

[paramvir]

Just iterate ( loop ) through dataModel.data array and update the column values followed by refresh method.