Forum Discussion

SK07's avatar
SK07
Contributor
7 years ago

Groupby using groovy

I want to display by groupby item and count the rate using groovy in ReadyAPI.(Like this: Item 12: Count(Rate) : 400 Json1 : {"prods": [{"Item":"11","rate": 100},{Item":"12","rate":200},{Item":"12",...
SK07's avatar
SK07
Contributor
7 years ago

I want to print  how many nulls, 1's and 2's seperately.

Json : {"prods": [{"Item":13,"rate":200, "Ids": []}, {"Item":13,"rate":200, "Ids": []},
{"Item":11,"rate": 100, "Ids": [ {"level": 1}]},
{"Item":13,"rate":200, "Ids": [ {"level": 1}]},
{"Item":12,"rate":200, "Ids": [ {"level": 2} ], [{"level": 2}, {"level": 2}]} ]}.

def jsonids = json.Ids
log.info jsonids
[[], [], [1], [1], [2, 2, 2]]

I tried and couldnt seperate...Any help is appreciated.

  • HimanshuTayal's avatar
    HimanshuTayal
    Community Hero
    7 years ago

    any example what you exactly want to do.

    • SK07's avatar
      SK07
      Contributor
      7 years ago

      For that request,I wanted to get results like :
      Level nulls : 2
      Level one's : 2
      Level two's : 3