Glide addAggregate not working

[aarya]

Hi All,

I am trying to get number of times a field value(reference field) is   used on my table   and update the count as quantity on the reference table.

details:

u_p2p is reference fields on u_component   - referenced table is u_p2p

here is my business rule:

function onBefore(current, previous) {

    //This function will be automatically called when this rule is processed.

    var p2pGr = new GlideAggregate('u_component');

  //gs.addInfoMessage(current.u_p2p.getDisplayValue());

  p2pGr.addQuery(current.u_p2p , current.sys_id)

  p2pGr.addAggregate('COUNT');

  p2pGr.query();

  var sum = 0;

  if(p2pGr.next()){

  sum = p2pGr.getAggregate('COUNT');

  gs.addInfoMessage(sum);

  }

}

i am looking no of times u_p2p is used on u_component table and update quantity on u_p2p table

More info: u_component and u_p2p are related lists on u_cap table - both have common field cap number

in this case u_p2p - 1123 is used 4 times on u_component

so i am looking to update quantity field to 4 on u_p2p table with record number 1123

please help

[nthumma]

Any chance is this on your Sandbox that I can take a look at it?

[aarya]

no... its on our dev...

[nthumma · Accepted solution]

can you try below code, if this does not work can you post the screen shot of component form with the u_p2p field on it?

var count = new GlideAggregate('u_component');
count.addQuery('u_p2p',current.u_p2p);
count.addAggregate('COUNT');
count.query();
var incidents = 0;
if (count.next()) 
     incidents = count.getAggregate('COUNT');
 gs.addInfoMessage('Count is '+incidents);

[aarya]

Thanks Nish...

This worked:)

Appreciate all your time.. this helped me

[nthumma]

is your BR running on before, can you change it to after?