Skip to main content
Solved

Is it possible to exclude columns when exporting data?


Dennis van Leeuwen
Hero
Forum|alt.badge.img+11

 

Is it possible to exclude columns when exporting data? I already marked these columns as Hidden but you can still select them if you want. 
 

Example for excluding Hidden fields

 

The order seems to be taken from the order in Subjects > Components > Grid.

I know that you can modify the column sequence before executing the export when you choose for the option "Advanced option” and drag and drop the chosen field. But I want a default ordering of columns for export deviating from the order in the grid.
 

How to modify the "Standard order”

 

Best answer by Jasper

You’re right, primary key columns are always available for export because you need those columns when importing data or updating data using an import file.

Unfortunately, there is no way to set the order of columns for export, apart from using the Grid ordering.

View original

Jasper
Superhero
  • June 4, 2020

Hi Dennis, 

If you set these columns hidden at column level instead of the grid or form, then they won’t be available for export. 


Dennis van Leeuwen
Hero
Forum|alt.badge.img+11

Hi Jasper,

The Software Factory (2019.2) doesn't seems to behave that way. Even if I make the column type "Hidden" on META-level it remains selectable with the advanced export functionality. 

Maby it's because these colums are a Primary key :thinking: ?

 

Hidden on META level

 

Hidden on Subjects > Columns level

 

Number* and Invoice* still available for export

Besides that I'm still wondering or you can set a default ordering of columns for export. 


Jasper
Superhero
  • June 4, 2020

You’re right, primary key columns are always available for export because you need those columns when importing data or updating data using an import file.

Unfortunately, there is no way to set the order of columns for export, apart from using the Grid ordering.


Dennis van Leeuwen
Hero
Forum|alt.badge.img+11

Okay clear, in that case I'll make a variant specifically for exporting the columns in the ordering we want, disable all the other options and only allow the export functionality.

Is it worth putting it up as an idea on the platform?


Jasper
Superhero
  • June 4, 2020

Sure, feel free to submit an idea!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings