Fetch Grid Data

It helps to automate read the value of the desired grid from a single or multiple rows of the selected applet. You can filter the grid using other Siebel activities and fetch the required grid data.

 

NOTE:  

You must first navigate to the screen from where you want to retrieve the grid data. You can use the Navigation activity to navigate to the required screen.

 

Using Set Field Value Activity

  1. In the Canvas Tools pane, click Process Components to expand the tool and view the associated activities.
  2. Drag the Application activity and drop on to the Flowchart designer on the  Canvas.
  3. In the Application Type list, select WebApps.
  4. In the Select An Application list, select the configured Siebel CRM application.

 

 

  1. Double click the Application activity to open the activity block. You must navigate to the desired applet before fetching the grid data. You can use the Navigation activity to navigate to the desired tab, link or view. See the Use Case for better understanding.
  2. In the Canvas Tools pane, click Siebel to expand the tool and view the associated activities.
  3. Drag the Fetch Grid Data activity and drop inside the Application activity. The validation error symbol disappears when required the inputs are provided.

 

 

  1. Click the (Get Applet Name) button to automatically fetch the applet name. If the applet name is not retrieved, enter the applet name manually in the Applet Name field.

 

NOTE:  

  • To know the applet name, navigate to the required screen of the Siebel CRM application manually and then access Help > About View > Applets name.
  • On the Siebel CRM screen, multiple applets can be present. You must choose the applet where you want to perform the automation.

 

  1. Click the (Get Field Name) button. The Available Fields dialog box appears with the list of available field names.

 

 

  1. Select the required field name and then click CONFIRM.  You can select one or multiple field names, as per your requirement.
  2. In the Rows field, enter the specific number of rows to fetch the data from the grid. You can select the Select All check box to retrieve all rows from the grid.
  3. In the Argument list, select the parameter of the data table type to store the extracted grid. You must define the parameter in the Parameter bar to use this option.
    The Fetch Grid Data activity is created.

Fetch Grid Data Activity Properties

The properties of a Fetch Grid Data activity are listed in the following table and can be edited in the Properties grid on the right panel.

 

Property Name

Usage

Control Execution

Ignore Error

When this option is set to Yes, the application ignores any error while executing the activity.

If set to NA, it bypasses the exception (if any) to let the automation flow continue; however, it marks the automation status as a failure, in case of an exception.

By default, this option is set to No.

Delay

Wait After

Specify the time delay that must occur after the activity is executed. The value must be in milliseconds.

Wait Before

Specify the time delay that must occur before the activity is executed. The value must be in milliseconds.

Misc

Breakpoint

Select this option to mark this activity as the pause point while debugging the process. At this point, the process freezes during execution allowing you to examine if the process is functioning as expected.

In large or complex processes, breakpoints help in identifying the error, if any.

Commented

Select this option to mark this activity as inactive in the entire process. When an activity is commented, it is ignored during the process execution.

DisplayName

The display name of the activity in the flowchart designer. By default, the name is set as Get Field Value. You can change the name as required.

IsFieldValueDefault

Indicates if all rows must be retrieved from the grid. Alternatively, you can specify if you want to retrieve all the rows from a grid by selecting Select All check box of the activity block. The value specified in the Properties grid reflects in the activity block and vice versa.

RowCount

Indicates the number of rows that must be retrieved from the grid. Alternatively, you can specify the number of rows in the Rows field of the activity block. The value specified in the Properties grid reflects in the activity block and vice versa.

SelectedColumns

Indicates the field name that you want to retrieve form the grid.  Alternatively, you can specify the field name in the Field Names field of the activity block. The value specified in the Properties grid reflects in the activity block and vice versa.