include additional fields in JSon data from the server in exports only

crcucb

I'm using standard server side editor tools return data set from the main table and from various attached views. The data table utilizes some of the fields and allow updates for fields in the base table. I also utilize search builder and I have a drop-down column where they could select column visibility. When they export, I want to include additional fields that were part of the JSON data return from the server. but I don't want the feels to be viewable in the drop-down button to hide columns nor do I want them available in the search builder. is there a way to do this without having to add the fields as hidden than dealing with the column visibility and search builder?

allan

I want to include additional fields that were part of the JSON data return from the server. but I don't want the feels to be viewable in the drop-down button to hide columns nor do I want them available in the search builder

If you want them in the export, then they need to be columns in the DataTable. They can be set to hidden (columns.visible). You can also instruct SearchBuilder and the column visility controls to ignore them:

• searchBuilder.columns
• columns option for colvis.

So a little extra configuration, but it is possible.

Allan