Database view that connects Services to Service Offerings

[ServNowDev]

i am building out a reference qualifier advanced script that when the service field is populated the service offereing field is filtered based on the selected service. I believe database views would be needed for this but i have no experience in this and most examples are for database views for reporting. Is there anyone who is familar with this process. Thanks

[Allen Andreas]

Hi,

You wouldn't need a database view for this as there's already a relationship there between services and service offerings. In fact, I would refer to the Incident table and the out of box Service and Service Offering fields and you can see on the Service Offering field the filter used to take the Service selected to filter it's own results.

Example:

[ServNowDev]

this only works if the application service is a class = service, it doesnt work if the class is application service or buisness service, and those are the others that i need to tie in