<< 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 :