DATABASE VIEW to bring Groups which users are located in specific location

[Vinicius Luz1]

Hi All,

I have the following setup on my database view and I'm not sure why is not working:

@Brad Bowman   can you help?

[Brad Bowman]

I think you probably want something more like this if you want to show one row for each user that is in the assignment group of the task:

You don't need to include the user table as you can add the User column from the grmember table, then dot-walk to any fields on the user table that you want to see

To limit the results to only Incident, Problem, and Request Items, create a before Query Business Rule using the Database View name as the Table.  The script would look like this:

(function executeRule(current, previous /*null when async*/) {
	current.addEncodedQuery('task_sys_class_name=incident^ORtask_sys_class_name=problem^ORtask_sys_class_name=sc_req_item');
})(current, previous);