AnsweredAssumed Answered

Stored Query - Department

Question asked by nicolas.ioannou1.1 on Aug 18, 2015
Latest reply on Aug 18, 2015 by Raghu.Rudraraju

Hi

 

I need some assistance on creating a stored query that will give me a list of incidents for users of a particular department.

I've tried the following:

orig_user_dept.id = 1000058 AND active = 0 AND type = \'I\'

 

When I add it to the scoreboard I get the following error:

AHD03053:Bad where clause: Parse error at : "orig_user_dept.id = 1000058 AND active = 0 AND type = 'I'" (Attr not found or not atomic)

 

Any ideas?

 

Thanks in advance.

 

Nic

Outcomes