Can we identify how many requests of a particular catalog raised has attachments?

[Rajashekar316]

Hi Team,

Can we identify how many requests of a particular catalog raised has attachments? For example, let's say i have a tax audit catalog item for which i would like to know how many such requests have attachments? can i extract a report which shows tax audit catalog requests that only have attachments? 

I have checked sys_attachment table but i would require identifying only 1 catalog item requests with attachments & not all catalog items in sc_req_item table.

Let me know whether this is achievable? if yes please share the knowledge here.

Many Thanks,

Rajashekar.

[palanikumar]

Hi,

I'm not sure whether we have a direct solution. You can create a database view by joining sc_req_item and sys_attachment table. Add condition in the table that filters only your catalog item.

Thank you,

Palani