Advance Grid

You have to go through a three-step form wizard to enable this Control, i.e., Design, API & Advance. Let’s explain these steps below:

1st Step – Design

Database Field Name (mandatory): These are the attributes of the form
Label Name (mandatory)
Column Width

2nd Step – API

Data

Data Source: Select data source from the following HTTP, Workflow, No SQL or RDBMS
1. HTTP
  1. Data Connection
  2. Method (mandatory): Select method from the following GET, PUT, POST, PATCH, DELETE or POCO
  3. API URL (mandatory)
  4. Query Parameters
    1. Key
    2. Value
    3. Query Variable
    4. Select Type
  5. Headers
    1. Name
    2. Value
  6. Others
    1. Enable raw query
Response Attribute
Paging Type: Server Side or Client Side
1. Server Side
  1. From Param
  2. Page Size Param
  3. API Field for Total Counts (Optional)
  4. Server Pagination View: Load More or Number Type
    1. Number Type
      1. Show Pagination
      2. Show Pagination Top
      3. Show Pagination Bottom
      4. Page Size Options
  5. Show Total Count
  6. Total Count Label
Page Size
Map With Data Model Property: If true, No Api and client data required. Grid will bind from Page get API
Is API Result Nested
Primary Key
Refresh Component On Close

Mapping

Field Mapping: Click on “Add New” button depending on how many fields you want to map in the grid based on requirement. And click the refresh button to reload the API response. After that start mapping following fields:
1. Binding
  1. Header
  2. Data Field: From API
  3. Data Type: Choose data type from the following None, Date, Title, Image or Link
  4. Show Icon Only
  5. Icon Margin
  6. Column Width
  7. Text Alignment
  8. Is Multi Row Text ?
2. Advance
Enable Nested Data ?
1. Nested Collection Field (mandatory)
2. Field Mapping: Click on “Add New” button depending on how many fields you want to map in the grid based on requirement. And click the refresh button to reload the API response. After that start mapping following fields:
  1. Display Name
  2. Binding Field
  3. Field Type: Choose field type from the following None, Email, Date, Title, Image, etc.
Card Type (Mobile only)

Action

Action Header
Is action on last column
Action Button View At: Popover or Inline
Actions: Click on “Add New” button depending on how many actions you want to configure on the card based on requirement. Then configure the following details:
1. Action
  1. Button Text
  2. Button Type: Select option from the dropdown menu
  3. Action Type: Choose action type from the following Sidebar, New Tab, Same Tab, Popup Window, Submit, Submit & Redirect, etc.
  4. Primary Key
  5. Redirect URL
  6. Primary Key Node (optional)
  7. Bind Action with Column
    1. Column Name
2. Web View
  1. Web Name Type: Choose web name type from the following Name Only, Name & Icon or Icon Only
  2. Web Icon
3. Mobile View
  1. Mobile Name Type: Choose mobile name type from the following Name Only, Name & Icon or Icon Only
  2. Mobile Icon
4. Advance
  1. Mark As Default Action
  2. Action: Choose action from the following Hide, Show, Enable or Disable
  3. Add Rule
    1. Api Field
    2. Operator
    3. Value
    4. Action
    5. Is Value From DataModel?
      1. Model Value From Another Form?
  4. Set data model to page variable: Set this option as "Yes" to access the page variable on sidebar
    1. Page variable
    2. Type: Object or Array
      1. Array

3rd Step – Advance

Design

Default Image Url: This image will display if the image url is missing in data response
Image Width
Image Height
Image Size: Select option from the dropdown menu
Image Position
Is Circle Image
Action Column Width
Bootstrap Column Class
Enable Select Column
Enable Export Link (Csv)
1. Export Page Size
2. Export File Dynamic Name
3. Do you want to remove header?
4. Do you want to remove Serial Number column?
Enable Manage Column
Show Export Link (Pdf)
1. Export Page Size
Enable Freeze Column
Enable Client Side Filter
1. Filter Placeholder
2. Filter Columns Index
Is odd even color row ?

Others

Enable Update Link
1. Choose Update Form Id
2. Enable Group Collection: Updated Collection will be grouped into Group Field
  1. Group Field (mandatory)
3. Data Source: Select data source from the following HTTP, Workflow, No SQL or RDBMS
  1. HTTP
    1. Data Connection
    2. Method (mandatory): Select method from the following GET, PUT, POST, PATCH, DELETE or POCO
    3. API URL (mandatory)
    4. Query Parameters
      1. Key
      2. Value
      3. Query Variable
      4. Select Type
    5. Headers
      1. Name
      2. Value
    6. Others
      1. Enable raw query
4. Response Attribute
Enable Delete Link
1. Data Source: Select data source from the following HTTP, Workflow, No SQL or RDBMS
  1. HTTP
    1. Data Connection
    2. Method (mandatory): Select method from the following GET, PUT, POST, PATCH, DELETE or POCO
    3. API URL (mandatory)
    4. Query Parameters
      1. Key
      2. Value
      3. Query Variable
      4. Select Type
    5. Headers
      1. Name
      2. Value
    6. Others
      1. Enable raw query
2. Response Attribute
Enable Email Link
1. Form Id
2. Email Form Field (Model in Email Form) (mandatory)
3. Email Field (Source Email Id Field) (mandatory)
4. Add in Group
Enable Advance Search
1. API Method: Get or Post
2. Advance Search Form
3. Advance search API mapping
  1. API Param
  2. Advance Search Field
4. Enable Search on Load
5. Is hide search button text
6. Search Button Class
7. Search Button Icon
Enable Selection Submit
1. Selection Attribute
No Data Configuration
1. No Data Image URL
2. Background Color
3. Image Width
4. Cover Height
5. Title
6. Message

Click “Confirm” and “Advance Grid” control is configured.