How to filter report by Assignment group.location.parent

[Ozgur Baykal]

I am trying to filter ( or group) reports for  incidents , requests , and interactions based on the "Assignment Group's Location. Parent. When I open an Assignment Group form , I see the "Locations" tab at the bottom and its related location is there. ( It is probably originating from Location table, the location's "Office Support Group" field) , but when I try to filter a report based on Assignment Grp field. I can not dot walk to its Location, it is not available. Does anyone know how to filter (or group) reports based on Assignment group.Location.parent ??

[Yousaf]

Hi Ozgur,

On which table you are reporting?

Because you will not see extended tables fields Please refer to this link and see if this is the problem here.

Report on extended tables

Make Sure to watch the video in doc.

Mark Correct or Helpful if it helps.

[Tony Chatfield1]

Hi, I do not believe that Location is an OOB field on sys_user_group table.
If you have added a custom location field to sys_user_group then you may need to scroll down the assignment group fields list in order to see\select your custom field into your filter.

Can you clarify your configuration\customizations made to your instance?

[EricDohr · Accepted solution]

As @Tony Chatfield  mentioned, out of the box, there is no reference from the Group table to the Location table.

There is a related list between Group and Location, but that is a different use case.  I know of one example where you can apply a primary group and use this for logic.

So in summary, you could go by location.group but not group.location.  

[Ozgur Baykal]

Thank you all for your responses. It looks like we either have to add a new custom field "Location" on the [sys_user_group] table and assign a location to our Assignment groups ( if they have) for this, or I have to  create a separate report for each Region ( Location.parent) and hard code the related Assignment Groups in the report filter conditions one by one.