Jump to content

Field name on Activities (sys tasks) table


Joyce
 Share

Recommended Posts

Hi,

which field on h_sys_tasks table are the columns seen on 'Activities view' linked with?

I am after columns 'Assigned to', and  'Status' .

I am trying to create a  widget for count of open/active task by team (assigned to a team).

Thanks.

 

Regards,

JOyce

 

Link to comment
Share on other sites

Guest Ehsan

Hi @Joyce,

The column "h_sys_tasks.h_assigned_to" stores the assigned-to detail of an Activity. The column "h_sys_tasks.h_state" stores the status of an Activity. Statuses include:

  • 1 for assigned
  • 10 for cancelled
  • 4 for completed

You can find more information on reporting on Activities, in the following post.

Hope this helps.

Ehsan

 

Link to comment
Share on other sites

Thanks @Ehsan. The value i have on 'Assign to' from  running select query on database direct is something like 

urn:sys:group:Instance/company/department/team/.

I am interested on filtering by Team.  So if I say:  h_sys_tasks.h_assigned_to like '%department%'

I am not getting any data returned, but sql error.

Thanks.

 

Regards,

Joyce

Link to comment
Share on other sites

Guest Ehsan

@Joyce,

That's strange.

The following statement works for me.

  • SELECT * FROM h_sys_tasks WHERE h_assigned_to LIKE '%SecondLineSupport%'.

You can also use the Reports feature (Admin Tool > "Hornbill Service Manager" Tile > "Reports" Tile > Create a Report and select "SQL Schema Designer" option under "Reporting Using" field).

Below, I've added a filter to report on h_sys_tasks -> Assigned To field. Please refer to this as an example.

Screen Shot 2017-06-20 at 13.29.47.png

 

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...