Complete button should be visible on request only if all the child table is close

[Nisha Mishra23]

I want complete button visible on request only if all the child task is complete or close where are under that parent request

[Dr Atul G- LNG]

Hi @Nisha Mishra23 

A request gets automatically closed when the SC task is closed, so I’m not sure what your exact requirement is. Please provide some more details so we can understand and guide you better.

[Nisha Mishra23]

Actually it is a custom table 

[JackieZhang]

create checkAttachments function in script include and call this function in condition in UI action complete.

[Ankur Bawiskar]

@Nisha Mishra23 

is this a OOTB UI action or custom one?

You can use UI action condition field and call script include and that function will check and return true/false

something like this

var RequestUtils = Class.create();
RequestUtils.prototype = {

  initialize: function() {},

  areAllChildTasksCompleteOrClosed: function(requestSysId) {
    var taskGR = new GLideRecord('sc_task');
    taskGR.addQuery('request', requestSysId);
    taskGR.addQuery('stage', '!=', 'Complete');
    taskGR.addQuery('stage', '!=', 'Closed');
    taskGR.query();
    return !taskGR.hasNext(); // true means all child tasks are Complete or Closed
  },

  type: 'RequestUtils'
};

UI Action condition:

new RequestUtils().areAllChildTasksCompleteOrClosed(current.sys_id)

If my response helped please mark it correct and close the thread so that it benefits future readers.