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

 

 

Gets the occurrence count of the given value from the given field.

 

 

 

Prototype :

 

integer GetDataSetFREQ

(

        string FieldPath,

        string Value

        [ string DistinctFieldName ],

        [ string ConditionFieldName ]

)

 

 

 

Arguments :

 

 

 

 

Reference :

 

Refer to GetDataSetValue function for how to set the field path.

 

Refer to GetDataSetSUM function for using DistinctFieldName and ConditionFieldName.

 

If set FieldPath using dataset of the data sub band itself, GetDataSetFREQ will return the same value as its parent band case. The parent bands of a data sub band are the data band or group header/footer band. Therefore, refer to the GetDataSetFREQ function of the data band or group header/footer band.

 

 

 

Example :

 

//Data field (ODI name : Sample, dataset name : Orders, field name : Price)

 _TraceLn(This.GetDataSetFREQ("Sample.Orders.Price", "1000"));

 

//Data field (ODI name and dataset name can be omitted)

 _TraceLn(This.GetDataSetFREQ("Orders.Price", "1000")); //omit ODI name

 _TraceLn(This.GetDataSetFREQ("Price", "1000")); //omit ODI name and dataset name

 

//ODI parameter field (ODI name : Sample, ODI parameter field name : TotalAmount)

 _TraceLn(This.GetDataSetFREQ("Sample.OZParam.TotalAmount", "1000"));

 

//ODI parameter field (ODI name can be omitted)

 _TraceLn(This.GetDataSetFREQ("OZParam.TotalAmount", "1000"));

 

//form parameter field(form parameter field name : Quantity)

 _TraceLn(This.GetDataSetFREQ("OZFormParam.Quantity", "1000"));

 

//Data field (specify DistinctFieldName)

  _TraceLn(This.GetDataSetFREQ("Price", "1000", "Region"));

 

//Data field (specify ConditionFieldName)

  _TraceLn(This.GetDataSetFREQ("Price", "1000", "", "Flag"));

 

//Data field (specify DistinctFieldName and ConditionFieldName)

  _TraceLn(This.GetDataSetFREQ("Price", "1000", "Region", "Flag"));

 

 

 

Available Events :

 

OnBind,  OnStartBind

 

 

 

See also :

 

GetDataSetSUM, GetDataSetValue