Jump to content

Count widget


Alisha
 Share

Recommended Posts

Hello,

I'd like to create a count widget to count how many Activities with a specific title have not been completed, but I think I would need to join h_sys_tasks and h_itsm_requests. Is this possible please?

Many thanks,
Alisha

Link to comment
Share on other sites

  • 5 weeks later...

@Alisha not sure if you did get this working but just in case, for reference... I assume you mean the team name that the task is assigned to? If yes, then this information is in "h_assigned_to" field in tasks table. It does not store the team name, but the team ID as the entity reference as opposed to just the ID. What does this mean? For example if the team ID is "Team_3" then the entity reference for this team would be "urn:sys:group:Team_3". So in the WHERE clause you can include the team ID criteria as follows: WHERE ... AND h_assigned_to = 'urn:sys:group:Team_3'

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...