<< Click to Display Table of Contents >> Navigation:  »No topics above this level« TOC : Script API > JavaScript > JavaScript API > Component > Band > DataHeaderExpanderBand > Method >   GetDataSetCNT

 

 

Gets the number of dataset rows.

 

 

 

Prototype :

 

double GetDataSetCNT

(

       [ string DataSetPath ],

       [ string DistinctFieldName ],

       [ string ConditionFieldName ]

)

 

 

 

Arguments :

 

 

 

 

Reference :

 

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

 

Refer to GetDataSetSUM function for using DistinctFieldName and ConditionFieldName.

 

 

 

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