Meera, I'm not quite sure what you are trying to accomplish here. Can you elaborate?
Thanks for replaying.
As you know in HPD:HELP DESK ASSIGNMENT LOG form we get all assigned groups for incident Number, here I am using join between HPD:HELP DESK ASSIGNMENT LOG and HPD:HELP DESK.
In report, I wants to show all assigned groups transfer for each incident which it has been assigned.
For example: Incident Number INC0005 is first assigned to ABC group then got assigned to PQR assigned group and last XYZ assigned group (resolved the ticket).
Incident Number Assigned Group Submit Date Resolved Date Submit -Resolved Date INC000005 ABC->PQR->XYZ 6/17/2019 6/20/2019 3
When I use only incident number, List aggregated column it works fine, otherwise it through Database Error.
Please help me if any work around is there.
Please let me know if is not clear.
I did a similar report, but I used the OOTB incident view that has the Assignment logs. From the Incident Details folder I pulled the current incident and from the Assignment Logs folder I pulled the history of assignments.
From the incident folder I dragged the following fields: Incident ID, Status, Summary, Customer Name, Assigned Group, Assignee, Categorization Tier 1, 2, and 3, Submit Date.
From the assignment logs I dragged the following fields: Assigned Group, Assignee and Actual Duration.
Is there a reason you created your own view? Did you check your view to make sure the join is correct?
I think it's not because of OOTB View or Custom view. Yes, with normal columns it works fine when I am using Date diff calculates field then it gives me Database error.
Will the Actual Duration field in Assignment Logs not work for you?
Can you send a screen shot of the report?
Odd. Have you tried selecting the option to suppress duplicates from the properties of the field?
1 of 1 people found this helpful
Its not really duplicates in my opinion as HPD:Help Desk Assignment Log creates new entries when assigments/re-assigments happen within the group as well.
So there can be multiple records for an Incident with the same group name in this form.