Query Case Activites

MStritt
Tera Guru

‎11-10-2023 08:55 AM

I'm trying to query/search for a specific file name in all Cases. The file name shows in the Activities (Attachment uploaded) portion of the Case. I've tried searching on Keywords, but that's not working. How would I run a query/search on any/all Cases that contain Mike_Test.txt (for example) in the Activities of a Case?

Case Activities.png

0 Helpfuls
  • 293 Views
2 REPLIES 2

Brad Bowman
Kilo Patron
Kilo Patron

‎11-10-2023 09:19 AM

One way to do this is to create a Database View joining the Case and Attachment tables.  It would look something like this - depending on which table you're referring to as 'Case'

BradBowman_0-1699636699866.png

You can then choose fields from the Case table to be displayed, and file_name from the attachment table and filter on ones matching your search.

0 Helpfuls

MStritt
Tera Guru
In response to Brad Bowman

‎11-10-2023 09:31 AM

 Thanks Brad. I can search the attachment table to see what files are attached to a Case. But, this file is no longer attached (deleted). But, it should still note the file name in the Activities, showing when it was attached. That's what I need to search on. But, I don't see a field on the Case table that searches the Activities.

0 Helpfuls