Attachment Searching
Hi
Would it be possible to add an 'Attachment' Search option? And/or have the 'Search Across' option include attachment names?
We have many requests that have attachments. It would be great to be able to search SDP to find a request that included that attachment name. When I search now by attachment name I get way to many results that do not include that attachment.
In searching the SDP SQL Database - I see that the image name is stored in two tables:
So can the SDP search be modified/updated to include an attachment name search that returns the request id?
I see that I can create a report but that just shows every attachment and would not allow my technicians to search by name. And it takes a very long time to execute:
- SELECT ad.ORG_NAME AS "Account",
- wo.WORKORDERID AS "Request ID",
- wo.TITLE AS "Subject",
- ti.FIRST_NAME AS "Technician",
- sa.ATTACHMENTNAME "Attachment Name",
- sa.ATTACHMENTPATH "Attachment Path" FROM WorkOrder wo
- LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
- LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID
- LEFT JOIN queuedefinition qdef ON woq.QUEUEID=qdef.QUEUEID
- LEFT JOIN statusdefinition sdef ON wos.statusid=sdef.statusid
- LEFT JOIN SDUser td ON wos.OWNERID=td.USERID
- LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID
- LEFT JOIN AccountSiteMapping asm ON wo.SITEID=asm.SITEID
- LEFT JOIN AccountDefinition ad ON asm.ACCOUNTID=ad.ORG_ID
- LEFT JOIN Workorderattachment wa ON wo.workorderid=wa.workorderid
- LEFT JOIN Sdeskattachment sa ON wa.attachmentid=sa.attachmentid