<< Click to Display Table of Contents >> Navigation: »No topics above this level« TOC : Script API > JavaScript > JavaScript API > Component > ReportTemplate > 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" |
DistinctFieldName |
Field name for deduplication |
ConditionFieldName |
Field name for search condition |
Reference :
Refer to GetDataSetSUM function for DistinctFieldName and ConditionFieldName.
Example :
//ODI name : Sample, dataset name : Orders
_TraceLn(ReportTemplate.GetDataSetCNT("Sample.Orders"));
//specify DistinctFieldName
_TraceLn(ReportTemplate.GetDataSetCNT("Sample.Orders", "Region"));
//specify ConditionFieldName
_TraceLn(ReportTemplate.GetDataSetCNT("Sample.Orders", "", "Flag"));
//specify DistinctFieldName and ConditionFieldName
_TraceLn(ReportTemplate.GetDataSetCNT("Sample.Orders", "Region", "Flag"));
Available Events :
OnBind
See also :