How to query [me] and [mygroups] with a sql table in the SCSM Portal

Jan_SchulzJan_Schulz Customer IT Monkey ✭

Hi,

i want to create a sql query which shows all the workitems (standard and one of our third party workitems) of the current user and his groups where one of these are in the assignedTo Relationship.

In the Service Management DB from Cireson i dont know how to get these information.

And how is it possible to use OData for workitem queries ?


regards,

Jan

Answers

Sign In or Register to comment.