Distribution of values Behind code

Avatar

Avatar

kapilKochar

MVP

Avatar

kapilKochar

MVP

kapilKochar
MVP

09-03-2021

Hi Everyone, 

Can someone please help me to understand from where I can find the code/logic behind "Distribution of values" option we have in query activity

 

kapilKochar_1-1615352775030.png

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar

_Manoj_Kumar

MVP

Avatar

_Manoj_Kumar

MVP

_Manoj_Kumar
MVP

10-03-2021

Hello @kapilKochar 

 

In the backend the query is using GroupBy in the queryDef.

 

You can achieve the same result by adding groupBy attribute in your queryDef code.

 

Here is the same code:

   select: {node:[
      {alias: '@expr', expr: field, groupBy: 'true', noSqlBind: 'true'},
      {alias: '@count', expr: 'COUNT()', label: 'Count'},
    ]},

Let me know if that helps.

 

Avatar

Avatar

akashaj7696

Avatar

akashaj7696

akashaj7696

10-03-2021

Hi Kapil,

This are usually all created using Input forms. You can find the code behind that in there. Go from Administration > Configuration > Input forms and search for Distribution of values form.

Thanks,