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,

Thats great. Can you mark this as answered if this is solved. This will help others.

awentz · ‎09-24-2015

Yes, I just marked your original response as Correct since it contained the full code plus the knowledge of not using Aggregate in a UI Policy. Thank you again for your help on this.