Load only selected columns in jqGrid

Question

In jqGrid I am using available columns to display columns. Now, if I want to save these names of the selected columns in the database and during grid loading I want to display only the columns that were selected earlier, then how can I implement this?

Another thing is when I load only selectable columns, and if I click the add button, then it displays only the fields that are selected in jqGrid, but I want to display all fields when creating an entry in the add form.

Answer 1

You can save the fields in the database as CSV or whatever, and when you extract, you can specify colModel and colNames, which would make the grid display only the specified fields.