Is there a way to export complete columns from the database table/view when using Appian Record Type and in the Grid we should be displaying few of the fields from the database table/view?

Yes, you can achieve this in Appian by leveraging Record Types and Grid configurations.

Data Source Configuration:
When creating the Record Type, ensure you select the database table/view as the data source.
Appian will automatically map all the columns from the chosen table/view to the record type.

Grid Configuration:
In the Record List view, you'll find the Grid component where you define the displayed fields.
You can choose which fields to display by dragging and dropping them from the "Available Fields" section to the "Selected Fields" section.
This allows you to configure the Grid to show only a subset of columns while the record type itself holds all the data.

Exporting Data:
Appian offers an "Export to Excel" functionality for Record Lists.
When a user clicks "Export to Excel," all the fields mapped to the record type (including those not displayed in the Grid) will be exported, even if they aren't visible in the grid view.

Yes, you can achieve this in Appian by leveraging Record Types and Grid configurations.

Data Source Configuration:
When creating the Record Type, ensure you select the database table/view as the data source.
Appian will automatically map all the columns from the chosen table/view to the record type.

Grid Configuration:
In the Record List view, you'll find the Grid component where you define the displayed fields.
You can choose which fields to display by dragging and dropping them from the "Available Fields" section to the "Selected Fields" section.
This allows you to configure the Grid to show only a subset of columns while the record type itself holds all the data.

Exporting Data:
Appian offers an "Export to Excel" functionality for Record Lists.
When a user clicks "Export to Excel," all the fields mapped to the record type (including those not displayed in the Grid) will be exported, even if they aren't visible in the grid view.

Hi Shubham,

Thanks for your reply. I did configure this. But, the Export to Excel component of Record Type is exporting only the columns present in the Grid. It's not exporting the entire columns from the grid.