Unpublication requestOffering for workitem

Roman_Nepomniashchii

I want to know how I can check the publication of the requestOffering that was used to create the workitem when changing the publication in the requestOffering. This property i want to use in ServiceManagement

Geoff_Ross

@Roman_Nepomniashchii

You would have to join the Work Item table to the Relationship table where the relationship Is is that of the WorkItem to RequestOffering Relationship, then join again to the Request Offering table to show the published status.

Hope that helps, let us know if you need more help and I'm sure someone can put something together.

Geoff

Geoff_Ross

Hi @Roman_Nepomniashchii

I'm not sure I fully understand. Can you please try explaining what you need in more detail?

Geoff

Roman_Nepomniashchii

Geoff_Ross said:

Hi @Roman_Nepomniashchii

I'm not sure I fully understand. Can you please try explaining what you need in more detail?

Geoff

I get data from table (ServiceManagement.dbo.WorkItem). I count workitems for requests. How ofen we used requests.  I want the counter to ignore workitems if of their requests non-public .

Roman_Nepomniashchii

Geoff_Ross said:

Hi @Roman_Nepomniashchii

I'm not sure I fully understand. Can you please try explaining what you need in more detail?

Geoff

I received task to count the number of uses for specific Requests Offering and  than display 5 most commonly used Requests Offerings. 

Is it possible not to count (ignore) unpublished Requests Offerings while creating query from table

ServiceManagement.dbo.WorkItem.

In other words, is it possible to add status published/unpublished to this table.

Geoff_Ross

@Roman_Nepomniashchii

You would have to join the Work Item table to the Relationship table where the relationship Is is that of the WorkItem to RequestOffering Relationship, then join again to the Request Offering table to show the published status.

Hope that helps, let us know if you need more help and I'm sure someone can put something together.

Geoff

Roman_Nepomniashchii

Geoff_Ross said:

@Roman_Nepomniashchii

You would have to join the Work Item table to the Relationship table where the relationship Is is that of the WorkItem to RequestOffering Relationship, then join again to the Request Offering table to show the published status.

Hope that helps, let us know if you need more help and I'm sure someone can put something together.

Geoff

How can i join [ServiceManagement].[dbo].[RequestOffering] to [ServiceManagement].[dbo].[WorkItem]
What is the name of the Relationship table?

Geoff_Ross

You will need to use the relationship table in ServiceManager database as that relationship is not cached into the ServiceManagement table.