check to see if incident has incident task

[sonita]

I need to check if the incident has incident task or not:

If the incident has an inc task, the incident state should stay the same & If the incident does not have an inc task, I need to change the incident state to new.

this is what I've done :

I should mention that 'u_inc' is a field in the inc task table and it has the corresponding incident.

var rec=new GlideRecord('incident');

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

//rec.addQuery('assigned_to.active',false);

rec.addQuery('active',true);  

rec.addQuery('state','!=',6);

rec.addQuery('state','!=',7);

rec.query();  

while(rec.next())

{

  rec.assigned_to = '';

    rec.work_notes = "This ticket has been reassigned to the group because the original assignee is no longer active.";

  rec.setWorkflow(false);  

  rec.autoSysFields(false);  

var grIncidentTask = new GlideRecord('u_inc_task');

grIncidentTask.addQuery('u_inc',current.sys_id);

grIncidentTask.query();

if(grIncidentTask.getRowCount() == 0 )//If the incident does not have an inc task

{

        rec.state = 1;//change the incident state to new

  gs.addInfoMessage('incident does not have an inc task');

}

  else if(grIncidentTask.getRowCount()!= 0 )//If the incident has an inc task

{

  //the incident state should stay the same

  gs.addInfoMessage('incident has an inc task');

}

  rec.update();  

}

MY problem:   no matter if the incident has inc task or not it changes the state to new!! and I get this msg! --> gs.addInfoMessage('incident does not have an inc task');

I need in situations that inc has inc task , the state should stay the same

[joshua_bice]

Change the line:

if(grIncidentTask.getRowCount() == 0)

to:

if(!grIncidentTask.next())

and just use an else instead of an else if.

[sonita]

that's correct but how do I say that the state should remain the same.

I just tested that the 'gs.addInfoMessage('incident has an inc task');' triggers perfectly but how to say don't change the state of incident?

rec.state=rec.state;??????

[david_legrand · Accepted solution]

Easy one

grIncidentTask.addQuery('u_inc',current.sys_id);

not current but rec I think

[sonita]

you mean I should write this line in the else section?

grIncidentTask.addQuery('u_inc',rec.sys_id);