Name | Required | Description |
version | The version of RAQL that is used in this statement. This version affects what attributes are required and the meaning of some attributes in <loadfrom>. Possible values are:  1.0 = the initial version of RAQL released in MashZone NextGen 3.6. See <loadfrom> forMashZone NextGen3.6 for information on the available attributes when this version is in effect.2.0 = the default. This is the current version of RAQL. | |
cache | yes | The name of the In-Memory Store where the dataset to load resides. Note: Store names can be a literal value or you can assign them dynamically using mashup expressions. See Dynamic Mashup Expressions for more information. For dynamic In-Memory Stores, this name is a simple string. For declared In-Memory Stores, this name is in the form data-source-name.store-name. See Declared Versus Dynamic
In-Memory Stores for more information. |
variable | yes | The name of the variable to hold the dataset or specific rows to retrieve. This variable must have been explicitly declared previously in the mashup. |
period | Defines an optional time period used to retrieve specific rows in the dataset based on their timestamp. Valid time periods include: ns = the last n secondsnm = the last n minutesnh = the last n hoursnd = the last n daysnw = the last n weeksn = with no period specified, this defaults to the last n minutesSee Load Dataset Rows for Specific Time Periods for an example. | |
fetchsize | The numbers of rows to request from the In-Memory Store at one time during loading. This can be used to fine tune performance with very large datasets or datasets with a large number of columns per row. |