Feature request - export table information by filtering on columns contained in / excluded from form(s)

[ArneRustad]

Hi,

Once again a feature request from me. When exporting table information it would be very useful to be able to filter on whether a column is included in a specific form or alternatively excluded from a particular form. Especially the excluded from one (or more) form would be very useful in combination with the new delete column functionality. Then, we could easily export all columns of the table which are not part of our forms of interest and choose which we should delete from a much shorter list. The Metadata Document Generator implements this kind of filtering, therefore it should at least be possible, even though I do not know difficult it would be to implement.

Kind regards, Arne

[MscrmTools]

This one is more tricky as, for now, Attributes Factory can be used in both ways (export or import attributes) and each column is useful for that. Adding one or more columns that adds data that is just an information won't respect the current paradygm and will eventually be annoying to handle if extra columns are required for metadata. Moreover, I have seen implementation with many forms for the same entity, not sure the document will be readble enough in this situation

[ArneRustad]

I agree that adding it as a column to the exported Excel file would not be a good idea. What I was imagining was something similar to what Metadata Document Generator does, i.e. before starting the export, we can choose some filtering based on forms (does not affect the layout of the excel file). I include a screeenshot from the Metadata Document Generator below:

The Metadata Document Generator uses a dropdown menu such as this to decided if the filtering should include or exclude the columns in the selected forms.

In this way the exact same Excel format could be used (and the format would remain identical for export and import). I envision that it could be added to this pop-up that opens when you press "Export tables" in your app.

What do you think?

[MscrmTools]

Ok, I understand better. This is something I can add

[ArneRustad]

Fantastic!