Script so that Problem cannot be closed with Open Tasks

[germc]

Hi guys,

Im trying to write a Client Script so that if a Problem has any open Tasks, a pop up appears saying 'You cannot close a Problem with open Tasks', please close out the corresponding tasks first'.

Below is the onSubmit Client Script I wrote on the Problem table but I cant get it to work.

Has anybody achieved this?

function onSubmit() {
    //Type appropriate comment here, and begin script below
      var id = g_form.getValue('number');      
var close = g_form.getValue('state');  
//If state changes to Closed, check if there is a related article  
  if (close == '4') {  
  var pt = new GlideRecord("problem_task");  
  pt.addQuery('source', id);  
  pt.addQuery('state', '1');  
  pt.query();  
  if (pt.next()) {  
  alert("test");  
  }  
}  

return false;  

}

[germc]

Hi,

We only have the one state for closing and that is called 'Close/Resolve'.

When I click the button it sets it to that state. and when I do it manually I set it to that state too..

I wonder is it to do with the order in which the button saves the ticket or something.

[Abhinay Erra]

No it should have triggered the business rule, since both are the server side scripts. Can you post your UI action script here

Thanks,

Abhinay

[germc]

No probs, thanks so much,

closeResolvePB();

function closeResolvePB() {
var assgUser = gs.getUserID();
var hg = new GlideRecord ('sys_user');
    hg.addQuery ('sys_id', assgUser);
    hg.query();
   
    while (hg.next()) {
    current.assignment_group = hg.u_home_group;
    current.assigned_to = gs.getUserID();
    current.problem_state = 4 ;
          current.update();
    gs.addInfoMessage('Problem ' + current.number + ' has been set to Close/Resolved');
    }
   
   
    var incident = new GlideRecord("incident");
incident.addQuery("problem_id", "=", current.sys_id);
// incident.addQuery("incident_state", "=", 3);
incident.query();
while (incident.next()) {
    if (incident.state != 7)
      incident.incident_state.setValue(6);
    // incident.active.setValue(false);
      incident.update();
      gs.addMessageInfo ("Incident " + incident.number + ' closed based on closure of problem '+current.number);
    action.setRedirectURL(current);
}
}

[Abhinay Erra]

Gerard,

        In your UI action you are setting problem_state to 4. But in your business rule you are triggering if the state changes to 4. Change your Business rule condition to this,

current.problem_state.changesTo(4) || current.state.changesTo(4)

Thanks,

Abhinay

Please mark Helpful, Like, or Correct depending on the impact of the response

[germc]

Thank you, However, by doing this it seems to give the message to say you cannot close but also gives the message to say it has been closed and it also does close the ticket