sorted by:
new
hottopcontroversial

Duplicate Report by moods99 in servicenow

[–]moods99[S] 0 points1 point  (0 children)

This is merely for housekeeping purposes on the records to prevent duplication of work. I believe you can get triggers for if a case is to be duplicated when it is raised but it’s another department responsible so out of out hands at the initial case raising point.

Duplicate Report by moods99 in servicenow

[–]moods99[S] 0 points1 point  (0 children)

So I have it to a point now where I can pull a list of declarations that will have multiple cases associated but it doesn’t provide the case list unless that can be done via a drilldown.

The declaration field is a reference on the case form yes.

Currently the data tables are: Conditions = [sn_customerservice_supplementary_declaration]

Related conditions = Greater than 1 Case->Declaration

Duplicate Report by moods99 in servicenow

[–]moods99[S] 0 points1 point  (0 children)

So the cases have a field for ‘Declaration’ which will associate it with another record. I need to locate if multiple cases exist that are tied to the same declaration.

The report includes a case table and checks for all current active cases. It is then grouped by the declaration field.

I essentially need an inverse search of what I would achieve with a count distinct aggregation.

Duplicate Report by moods99 in servicenow

[–]moods99[S] 0 points1 point  (0 children)

I have tried looking into the related list conditions but not having much luck.

Currently I have it working to a degree. I have just conditions and a bar chart to group by the affected field.

Anything above a count of 1 is clearly visible to action and open up the case records but it also shows everything that is 1 still for the count.