Forms › The Form Designer › Form Element Functions › Form Elements › Data Sources › ca_pam_getDatasetData(dataSetExpression,callBack)

ca_pam_getDatasetData(dataSetExpression,callBack)

Retrieves the value of a variable from a CA Process Automation dataset.

Note: In CA Process Automation releases before 04.1.00, this method was named ca_pam_getDataFromDatasetQuery.

Input Parameters

datasetExpression (string)

Defines a string, expression, or function call that results in an absolute path to a dataset. This parameter includes the Datasets keyword, the library path to a dataset object, and the ValueMap array variable name.

Datasets["/BR412-DATA-FOLDER-20111214/Folder_FORMS_20120328/dataset_forms_demo/My_Dataset55"].MyVal

callBack (object)

Defines a reference to the function object to call after retrieving the data, including its onSuccess and onFailure methods.

Return Value

When the function retrieves the data, either the onSuccess(result) or onFailure(caught) callBack function runs. The function itself does not return any value.

Example

ca_pam_getDatasetData(ca_pam_getTextFieldValue('Form.TxtFieldWithDatasetPath'),callBack)

The example code contains the following information:

• The TxtFieldWithDatasetPath Text field stores the dataset expression.
• The getTextFieldValue function gets the value of the dataset expression.
• The getDataUsingDatasetExpression function gets the dataset values and calls the callBack function to determine what happens next.
• To continue with this example, you can use the following functions in the callBack.onSuccess declaration to apply the data to a table or Lookup field, respectively:

  ca_pam_setTableData('Form.employeeList',result);
  ca_pam_showDataInTable(result,'Form.Results','Dataset results');