<< Click to Display Table of Contents >> Navigation:  »No topics above this level« TOC : Script API > JavaScript > JavaScript API > Component > Band > PageFooterBand > 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.

 

 

 

Example :

 

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

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

 

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

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

 

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

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

 

//Data field (specify DistinctFieldName)

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

 

//Data field (specify ConditionFieldName)

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

 

//Data field (specify DistinctFieldName and ConditionFieldName)

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

 

 

 

Available Events :

 

OnBind,  OnStartBind

 

 

 

See also :

 

GetDataSetSUM, GetDataSetValue