Listing out all task types(eg.Change,Incident) on clicking on module 'Tasks- Assigned to my group'

[Ashok10]

Hello,

Actually I know that today we can create a module, on click which will give the all incidents or service request assigned to our groups like 'My group Incidents'.

configuring   a module on single table is possible.

But I have one requirement that is " we should be able to see all the tasks regardless of task type (e.g., change task, incident task or problem task) assigned to current user's group by clicking on 'Tasks- Assigned to my group'".

[User140988]

Hi Sai Kumar,

You can still go ahead and create a module on task table (task) which is the parent of all the tables like change task, incident task or problem task and in case you want to add conditions, you can also filter out the task types in the query you can set on module. Ofcourse you have to place a query on the logic which gives what groups the user belongs to and all the child tables use the same field assignment group which is inherited from task table.

Hope this helps.

[poyntzj]

Couple of things to be aware of, is that if you try to display this as a list, you will potentially get blank columns as unless it is an INC,, the caller field is not normally used.

you may also see column headers like

request.request_for

where some dot walking has taken place.

Also consider the STATE field

To me it seems that each ticket type was created by a different teams, who used whatever State values they wanted.   As a result, you may find that State 2 is either "Active" or "In Progress" or "Scheduled" depending on the ticket type

How the query will determine which to use is based on the priority in the Choice List.

so if you search for all tickets where the state is 2, then you find other tickets some in too.

We have a business rule that updates a u_state_text field which is populated when the state changes.

Messy, not always 100% and can confuse people when generating reports.

we had some dashboards here that are based on the task table (a specific managers whim) and getting the users off these onto other dashboards where each type is broken out (and therefore numerous View Styles can be applied) is proving to be hard now.