TOC : Script API > JavaScript > JavaScript API > Component > Multiplex > Table > Method >

 

GetDataSetCNT

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

TOC : Script API > JavaScript > JavaScript API > Component > Multiplex > Table > Method >

 

GetDataSetCNT

 

 

Gets the number of dataset rows.

 

 

 

Prototype :

 

double GetDataSetCNT

(

        [ string DataSetPath ],

        [ string DistinctFieldName ],

        [ string ConditionFieldName ]

)

 

 

 

Arguments :

 

DataSetPath

DataSet Path in the form of "ODI name.dataset name"

can be omitted or set to null or ""

DistinctFieldName

Field name for deduplication

ConditionFieldName

Field name for search condition

 

 

 

Reference :

 

If dataset path is omitted or set to null or "", the dataset path of the table will be applied.

 

Refer to GetDataSetSUM function for using DistinctFieldName and ConditionFieldName.

 

When execute the function in the table created in a data band having group header/footer bands, a group header/footer band and a data sub-band, if the function use the dataset field of its band, the return value may be different according to each band. To learn more, refer to  description of GetDataSetCNT of each band.

 

Example :

 

//ODI name : Sample, dataset name : Orders

  _TraceLn(This.GetDataSetCNT("Sample.Orders"));

 

//ODI name can be omitted

 _TraceLn(This.GetDataSetCNT("Orders"));

 

//Dataset path can be omitted or set to null or ""

  _TraceLn(This.GetDataSetCNT());

  _TraceLn(This.GetDataSetCNT(null));

  _TraceLn(This.GetDataSetCNT(""));;

 

//specify DistinctFieldName

  _TraceLn(This.GetDataSetCNT("", "Region"));

 

//specify ConditionFieldName

  _TraceLn(This.GetDataSetCNT("", "", "Flag"));

 

//specify DistinctFieldName and ConditionFieldName

  _TraceLn(This.GetDataSetCNT("", "Region", "Flag"));

 

 

 

Available Events :

 

OnBind,  OnStartBind

 

 

 

See also :

 

GetDataSetSUM