I keep getting an error on 2 filters I've created and hoping someone can tell me what I'm doing wrong. The aim of the filters is to show on an End User Incident view windows assignments, but only those with no assigned Analyst, and notes with only customer text in them (we have our notes window split with technical note (OOTB attribute Text) and customer note (created attribute _Customer Text). So basically I want them to see their incident has been assigned to Service Desk but not that Joe Bloggs has picked up the incident.
I'll explain how I set up the assignments filter (notes was the basically the same).
Query and Report Designer - New Filter
Gave it a title and description,
Based On Module: Incident Management, Business Object: Assignment
Filter By Module: Incident Management, Business Object: Incident
Created for: Everyone
Selected Attributes: Group.Title and CreationDate
Criteria: User.Name Is NULL
Incident.Reference Number Is Equal To (runtime value) (Id) - I've also tried Incident Is Equal To (Incident) as well
In the settings I have it to return 5 rows per page and have had an interval refresh rate of 15mins and no refresh rate.
So the filter works on the window and returns only the assignments to a group and the creation date, no Analyst names for pesky end users to then contact directly!
But I am continually getting an error (doesn't seem to any logic to when I get the error, not specific to when I've opened the filter or the window) "Error running query '_IncidentEndUserViewAssignments'. This is a Filter query and requires a Filter Data Object to run." What I'm confused about is I have the same thing set up in the Request Domain and don't get any errors with it at all , I'm getting to the tear my hair out point now.
Any help as always greatly appreciated.