Dear Friends,
Please help in the below customization:
I need to show thos Incidents as well in IM Consoloe in 7.6.04 which meet
the below critiria as well .
the incidents which are not assigned, but have tasks that are assigned (to
user or groups) will also be shown. In these cases, user will need to look
at task tab for details.
This is not OTB. Workflow needs to be written for this.
The challenge here, multiple task can have same incident number and the
relationship between them is bounded by the incident number
Just for the Scenario: Assigned to ME
Incident qualification is 'Status' < "Resolved" AND (('Assignee Login ID'
= "Allen") OR ('Owner Login ID'="Allen"))
Now we need to make it sth like
('Status' < "Resolved" AND (('Assignee Login ID' = "Allen") OR ('Owner
Login ID'="Allen")))
OR
(Select * from Incident where Incident number in (Distinct *Incidents from
tasks where ('TASK Assignee Login ID' = "Allen") OR ('TASK Owner Login
ID'="Allen")) from Tasks))*
let me check if it is feasible or not.
With Warm Regards,
Bhupesh Gupta
ยท--
Regards,
Bhupesh Gupta
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
