Displaying Lists of Objects in a Data Grid
  • 04 Aug 2022
  • 1 Minute to read
  • Dark
    Light

Displaying Lists of Objects in a Data Grid

  • Dark
    Light

Article Summary

Overview

The Data Grid Form control displays a list of data objects in a grid, where each row in the grid represents an object, and each column represents an object property. 


Example

This example will populate a Data Grid with a list of accounts from the Portal. 

Below is a downloadable example to import into Decisions.


  1. In a Designer Project, create a new Flow.
  2. On the Toolbox panel, navigate to INTEGRATION > INTERNAL SERVICES > ACCOUNTSERVICE and attach the Get All step to the Start step.
  3. Next, click the Done path. On the Add After dialog window, select the Show Form step and click ADD.
  4. On the Properties panel, click PICK OR CREATE FORM and create a new Form. On the Form Designer, click and drag the Data Grid control and a Button control (OK) to the Form.


  5. Next, select the Data Grid control. Under INPUT DATA on the Properties panel, enter "Accounts" in the Data Name field. Then, in the Type field enter "account" and select Account [Decision.Framework...].
  6.  When the Input Data is set, the COLUMN INFORMATION category will display in the Properties panel. Users can remove, add, and sort the different fields in this section. Select the pencil icon to edit a column and click the arrows to reorder the column. Click Save and then close the Form Designer.
    Field NameDescription
    Is VisibleAutomatically visible if set to true. 
    Can GroupAble to group by this field.
    Can SortAble to sort by this field.
    Sort OrderAscending or Descending order.
    Is Read OnlyWill not be able to copy/edit this field if set to true.
    WidthSet the width of the column
    Allow Text AlignmentWill display the options to align the text in the column to be left, center, or right-aligned.

  7. Next, select the Form, and under the INPUTS category, click Unknown next to Accounts. Then, click Select From Flow. On the Pick Data For Input dialog, choose the output for the Get All step (Get All 1_ Output) and click DONE.
  8. Connect the OK path to the End step. Click Save to save changes to the Flow.

Debug

  1. On the top action bar, click Debug. 
  2. Click START DEBUGGING. 
After the Debugger runs, the Form will display a data grid of accounts.


For further information on Forms, visit the Decisions Forum.

Was this article helpful?