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?

Question

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

Abhishek Karumuru · Answer

hi shobhits6437 you need have export to excel button separately on the interface and use export to excel smart service to export all columns from your table / view when the export button is clicked. By default show data the in grid what ever the columns required

Shubham Aware · Answer

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.

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?

Top Replies