Database view using list field

[Blair5]

I need to join 3 tables in our instance: Application (cmdb_ci_appl), Task (task) and Business Capabilities (cmdb_ci_business_process).

Use case:

An incident is opened for an application. That application has several level 3 capabilities referenced directly in it. The capabilities also reference level 1 and level 2 capabilities.

I'm able to get data back for this if only one application is referenced in the list field on the capability table. However, most capabilities have more than one application referenced. I was hoping I could use 'contains' in the where clause of the database view, but that isn't an option. Does anyone else have any suggestions? Screenshots attached which will hopefully add clarity.

[Blair5]

Sachin,

Thank you.

[praveenkumarcho]

Hi Sachin/Blair,

I am looking for the solution for the same requirement. Please provide me an example, how to call the script include in Database views.

Thanks in advance.

[Blair5]

Unfortunately, I was never able to get this working.