Hello,
I have an Interactive Grid with many columns and I have a Region above it with Switches for each column. I use a dynamic action to change the visibility of the columns, it works perfectly, but when I hide a column, it doesn't changes its "Displayed" value in the Actions menu, and it has no affect on the export (that hided column will be aso exported) and I cannot save it as a Report. I assume that it is related to this value in the Actions menu, but I'm also interested in other solutions for the export and the Report saving.
This is the Javascript code I use:
let col01_col = ["COLUMN_NAME01"],
view = apex.region("interactive_grid_static_id").widget().interactiveGrid("getCurrentView").view$;
col01_col.forEach(function(columnName){
view.grid( ( apex.items.SWITCH_COLUMN_NAME01.value === "Y" ? "showColumn" : "hideColumn" ), columnName );
});
Can somebody please suggest a solution? Thank you in advance!