Here is a great way to show attachments from a parent record on a child record without having to copy the attachment.
Example 1: Display Change Request attachments on Change Tasks.
1. Go to System Definition > Relationship
2. Click New
3. Add Relationship
Name: Change Request Attachments
Applies to table: Change Task [change_task]
Queries from Table: Attachment [sys_attachment]
Query with:
current.addQuery("table_name", "change_request");
current.addQuery("table_sys_id", parent.change_request);4. Go to a Change Task
5. Right-click > Personalize > Related Lists. Add Change Request Attachments
6. Results
Example 2: Display Requested Item attachments on Catalog Tasks.
1. Go to System Definition > Relationship
2. Click New
3. Add Relationship
Name: Requested Item Attachments
Applies to table: Catalog task [sc_task]
Queries from Table: Attachment [sys_attachment]
Query with:
current.addQuery("table_name", "sc_req_item");
current.addQuery("table_sys_id", parent.request_item);4. Go to a Catalog Task
5. Right-click > Personalize > Related Lists. Add Requested Item Attachments
6. Results
Example 3: Display Project attachments on Planned Tasks.
1. Go to System Definition > Relationship
2. Click New
3. Add Relationship
Name: Project Attachments
Applies to table: Planned task [planned_task]
Queries from Table: Attachment [sys_attachment]
Query with:
current.addQuery("table_name", "pm_project");
current.addQuery("table_sys_id", parent.top_task);4. Go to a Catalog Task
5. Right-click > Personalize > Related Lists. Add Project Attachments
6. Results
