Identify multiple Child Tasks linked to Parent Task

awentz · ‎09-24-2015

I'm trying to disable choices on a choice drop-down (via UI Policy) if there is more than one Active Child record linked to the Parent. It's not working and throwing unexpected results. My guess is I'm not using the aggregate function correctly to identify the Parent-Child Relationship. Both these tables - Case (parent) and Case Task(child) are tables that extend from the Primary Task table.

Here's the first code I used (UI Policy):

Unexpected Results:

It cannot be the 'disableOption' calls because I can get those to work on a simple UI Policy when I use a Condition on the 'When to Apply'.

Any help would be appreciated.

manikorada · ‎09-24-2015

Angela,

I doubt if you can use GlideAggregate in Client side thing like UI policy and you can't use 'current' in UI policy

Try something like this:

var count = new GlideRecord('u_ap_case_task');

count.addQuery('active', true);

count.addQuery('parent', g_form.getUniqueValue());

count.query();

var total = 0;

while(count.next())

{

total++;

}

if(total > 1)

{

//do your code here

}

View solution in original post

manikorada · ‎09-24-2015

angela,

Are you sure the example you are testing with has more than one child attached to it? and all are active?

awentz · ‎09-24-2015

yes, I' created a 2nd Task for the Case - both are active.

awentz · ‎09-24-2015

So I'm on the form for the APTASK.... and it should count the CASE ID (parent) which there are two active records.

manikorada · ‎09-24-2015

Angela,

My bad, I thought you are on the form of 'AP'.

If you are on the form of 'APCASE', you need to change your code to :

count.addQuery('parent', g_form.getValue('parent')); // assuming the 'parent' field is on the the APCASE form.

awentz · ‎09-24-2015

You are awesome!! That did it. Thank you for helping!!