Skip to main content

RtBaseline_GetAFTable

The RtBaseline_GetAFTable method/function returns a matrix with the desired AFTable. The format of the returned matrix depends on the selected table and the output specification passed to the method.

Web Method Synopsis (C# Syntax)​

public DataSet RtBaseline\_GetAFTable( 
 string sAFPath, 
 string sAFTable, 
 string sColumnList, 
 string sWhereCondition);

Output Result​

DATASET® Returns a matrix of the retrieved results based on table selection and output specifications (sColumnList). The returned columns format and names depend only on the table itself. For an EAI scenario, the output format is a standard XML DIFFGRAMM document. (For further information, refer to Microsoft XML DIFFGRAM v1.x and v2.x specifications.)

Input Parameters​

sAFPath (STRING) ® AF PATH (must exist) in the following format \\Server\Database.

sAFTable (STRING) ® AF Table name (must exist)

sColumnList (STRING) ® This field specifies which columns pick up from the source table instead of having the whole table. If no specifications are provided, the whole table without any column filter is returned. This field uses a specific sintax described below:

Column1;Column2;Column3;…… ColumnN

ClosedEXAMPLE: RtBaseline_GetAFTable

ValueTime;ForecastValue

sWhereCondition (STRING) ® In this string field, the method caller is specified by a SQL “where” clause in order to filter the returned rows. The syntax is the standard ANSI 92 syntax. No placeholders are supported.

EXAMPLE: sWhereCondition

(Temperature \> 30) AND (Pressure \< 1.22)