Creat an UI action button that should check all the child tickets are closed before closing the parent

[vijay23]

Hi all,

I have an urgent requirement 

I have to create an UI action button name as 'close' on 'Issue table' that should be visible to only users having some role. when state is resolved in issue table. It should check that all the related "issue tasks"(child table of issue table) should be closed before closing the issues. If all the tasks are closed issues should also be closed. 

I tried the code below but it is not working as expected

Condition - gs.hasRole('issue_mgmt_worker')

code- 

var rec = new GlideRecord('u_issue_task');

rec.addQuery('u_parent_issues', current.sys_id);

rec.addQuery('state', '3');

rec.query();

if(rec.next()){

gs.addErrorMessage('All issue taks should be closed before resolving/closing issue ' + current.number + ' record'); // use valid number field

current.setAbortAction(true);

}
else
{
current.state='3';
current.update();
}
action.setRedirectURL(current);

[vijay23]

Hi All,

Thanks for Immediate reply

I tried to execute the code with  rec.addQuery('state','!=','3'); but, it is directly executing the else condition in my code 

[Ankur Bawiskar]

Hi,

Did you check the state value is 3 for closed on your custom table

Regards
Ankur

[Ankur Bawiskar]

@vijay

Hope you are doing good.

Let me know if I have answered your question.

If so, please mark appropriate response as correct & helpful so that this thread can be closed and others can be benefited by this.

Regards
Ankur

[Ankur Bawiskar]

Hope you are doing good.

Did my reply answer your question?

If so, please mark appropriate response as correct & helpful so that the question will appear as resolved for others who may have a similar question in the future.

Thanks!
Ankur