Always hidden column

[adribusc]

Hi, i read in documentation that column visibility can be:
fixed: This column is always visible and can not be hided by the user
visible: This column is visible as default but can be hided by the user
hidden: This column is hidden as default but can be showed by the user

sometimes I need to have an hidden column that must remain hidden, but if i set columnSelectable to true, and i right click on header i can see and choose to show every column.
I think it would be nice to have a visibility attribute such as "ghost" or "unvisible" used to keep a column always unvisible.
Thank you

[hikalkan]

You mean that the column is not shown either in table or in column select list, but when you set columnSelectable=true for that column (programmatically with javascript after table is shown) the column will be shown in column select list. Is it true that I understood?

NOTE: If you want to make a column unvisible always, just do not add it to fields list of jtable.

[adribusc]

I mean columns that are never visible for users but always available for internal purpose (just like tag does, but for each table row).
It's usefull when you need to get and manipulate some data that users can't view in browser

[hikalkan]

Then how will you use these fields for invisible columns, or how will you reach them?

[adribusc]

I can reach and use these fields directly in the browser via jquery or javascript, and/or I can receive and use them in insert, update or delete methods.

[hikalkan]

Then you can do it right now.

Every data row (tr element) in table has a data property named 'record' that you can get it and reach all fields (even if ther are not defined in jtable columns).

Also you can reach the field, for instance, in column creation. If you write such a field definition:

UserName: {
title: 'User name',
display: function (data) {
return data.PrivateField;
}
}

Then you can see your PrivateField field in User name column.

But I must add some methods (it may be getRecordById(id) ) to get record directly. Do you have any suggestions?

[hikalkan]

You can reach the row by getRowByKey (http://jtable.org/ApiReference#met-getRowByKey) method. For instance:

var $row = $('#MyTableContainer').jtable('getRowByKey', 42);
var record = $row.data('record');
var age = record.Age;

Thus, you can reach the private Age field of your record.