Blog Viewer

HTML Grid Properties Gridview Controls

  

This item is found in multiple S3 file types. Its controls and their order may vary based on the file type.

 

ID

  • What it does: Programmatic ID of the control.
  • How to use it: Enter the text.
  • Other notes: This must be unique. It is prefixed with grv or dgr.



Visible checkbox

  • What it does: Determines whether the user can see the control.
  • How to use it: Click the checkbox to check or uncheck.



Visible Rule

  • What it does: Displays the control if it evaluates to true. Hides the control if it evaluates to false.
  • How to use it: Enter the rule from the entity.
  • Other notes: The rule comes from the entity. It must be configured there for you to use it here.



Resource

  • What it does: Security ID that determines whether the user can access the control.
  • How to use it: Enter the ID from the security table.



Custom Attributes

  • What it does: Custom attribute defined by the developer to be rendered on the HTML page.
  • How to use it: Enter the text.



Entity Field

  • What it does: Entity collection associated with the grid.
  • How to use it: Enter the entity.



Page Size

  • What it does: If paging is allowed, this is the number of rows in the grid per page.
  • How to use it: Enter the number of rows.
  • Other notes: Default is 10.



Data Key Names

  • What it does: Table column the application uses to identify the table row to express as a record.
  • How to use it: Enter the data key.
  • Other notes: Defaults to the primary key.



Base Query

  • What it does: Query used to populate the grid rather than using a collection.
  • How to use it: Enter the entity name and query name or search and select from a list.



Selection

  • What it does: Determines whether the user can select records and if so, whether they can select one or many.
  • How to use it: Select from the available options.
  • Other notes: Options are none, one, or many.



Select Column Visible Rule

  • What it does: Displays the list of initial load rules in the entity.
  • How to use it: Select from the drop down.



Parent Grid

  • What it does: Grid whose record displays in the selected grid as the parent record.
  • How to use it: Select from the drop down.



Allow New

  • What it does: Allows the user to create new entries in the grid.
  • How to use it: Click to check or uncheck the checkbox.



Allow Paging

  • What it does: If paging is allowed, the grid is divided into multiple pages with as many rows as set in the Page Size property. If paging is not allowed, all rows are displayed on one page.
  • How to use it: Click to check or uncheck the checkbox.



Allow Sorting

  • What it does: Allows the user to click column headers to toggle sorting between ascending and descending.
  • How to use it: Click to check or uncheck the checkbox.



Allow Grouping

  • What it does: Allows the user to group grid values by column.
  • How to use it: Click to check or uncheck the checkbox.



Allow Filtering

  • What it does: Allows the user to filter the grid results.
  • How to use it: Click to check or uncheck the checkbox.



Show Settings

  • What it does: Determines whether the settings toolbox displays.
  • How to use it: Click to check or uncheck the checkbox.



Editable

  • What it does: Allows the user to edit the grid values.
  • How to use it: Click to check or uncheck the checkbox.



Load When Required

  • What it does: If checked, the control loads only if the user displays its container.
  • How to use it: Click to check or uncheck the checkbox.



Bind to query button

  • What it does: Directly binds the grid to the query (not the entity collection).
  • How to use it: 
    1. Click the button.
    2. Click the Bind to Query checkbox.
    3. Select the load type.
    4. Select the query.
    5. Click Execute.
    6. Map the controls you want to use.
    7. Click OK.
  • Other notes: You should only do this for non-editable grids.



Row Format button

  • What it does: Changes the appearance of the row containing a specific value.
  • How to use it: 
    1. Click the button.
    2. Select the column that contains the value you want to determine the row's appearance.
    3. Click the plus icon to add a condition.
    4. Enter the value you want to change the row's appearance.
    5. Enter the CSS class you want that row to change to.
    6. Repeat steps 3-5 as many times as desired.
  • Other notes: The CSS class must already be configured in the style sheet.



Data Key & Sort Expression button

  • What it does: Selects the Data Key and sorts the data according to the order provided.
  • How to use it: 
    • Data Key:
      1. Click the button.
      2. Click to check or uncheck.
    • Sort Expression:
      1. Click the button.
      2. For the field, select the sort expression order.



Base Query Parameter button

  • What it does: Sets the parameters used by the base query (if any).
  • How to use it: 
    1. Click the button.
    2. Drag and drop the required parameter to the field.
    3. Click OK.
  • Other notes: This populates when the base query for the grid is configured.



Group Expression button

  • What it does: Allows the user to group grid values by columns according to the provided order.
  • How to use it: 
    1. Click the button.
    2. For the field, select the group expression order.


This post is part of the HTML Forms topic. Click here to open the HTML Forms Overview.

0 comments
26 views

Permalink