question Re: Service Portal Approver can see attachments in Developer forum

Service Portal Approver can see attachments

brianlan25 — Wed, 23 Aug 2017 13:40:54 GMT

We have several requests where users must attach an excel or word document before submitting the item. I tied to add the ticket attachment widget to the Approval form but it does not show any attachments. I'm guessing this had to do with the approval form being on the sys_approval table and the attachment is on the sc_req_item table. What code would need to be updated to if I were to clone the attachment widget to pull the attachment associated with the approval for from the sys_approval table?

Re: Service Portal Approver can see attachments

manikorada — Wed, 23 Aug 2017 13:50:31 GMT

Brian,

You can check this : http://wiki.servicenow.com/index.php?title=Copy_Attachments_from_Record_to_Record#gsc.tab=0

Re: Service Portal Approver can see attachments

brianlan25 — Wed, 23 Aug 2017 14:02:29 GMT

So you want me to copy the attachment from the sc_req_item table to the sys_approval table for the specific request?

Re: Service Portal Approver can see attachments

johansec — Wed, 23 Aug 2017 14:22:22 GMT

I am doing the same thing for all sc_tasks to inherit from their parent RITM. I am sure you can create a clone of the attachment and assign it to the Approval record but if possible it seems like the best option would to add these to a defined related list.

https://www.servicenowguru.com/system-definition/relationships/defined-related-lists/

Re: Service Portal Approver can see attachments

brianlan25 — Wed, 23 Aug 2017 14:32:01 GMT

would this even work in the service portal. it does not have related lists.

Re: Service Portal Approver can see attachments

johansec — Wed, 23 Aug 2017 14:34:05 GMT

Nope sorry.

Re: Service Portal Approver can see attachments

johansec — Wed, 23 Aug 2017 14:36:28 GMT

Can you send me a screenshot of the widget you are wanting to edit?

Re: Service Portal Approver can see attachments

brianlan25 — Wed, 23 Aug 2017 14:42:17 GMT

It does not have any options so I think it is pulling parameters from the URL. This is the same widget that is on the ticket form page that comes OOB and if there is an attachment on the RITM or Incident it is displayed here. However since I am on the approval form there is not attachment there because it is not looking at the sys_id of the correct table.

Re: Service Portal Approver can see attachments

brianlan25 — Tue, 19 Sep 2017 14:41:27 GMT

Hello Mani,

So I created a business rule to copy the attachment to the approval record. Do you know if there is a way in the Service Portal to make it so they cannot delete or edit the attachment?

Re: Service Portal Approver can see attachments

jamesmcwhinney — Thu, 01 Feb 2018 18:27:55 GMT

This doesn't seem like the best solution.

Is there no way to just show the RITM attachments on the approval page?

Re: Service Portal Approver can see attachments

jamesmcwhinney — Thu, 01 Feb 2018 23:13:58 GMT

For what its worth, its possible to update the approval record widget to display the attachments.

Widget HTML Template:

<div ng-if="!data.isValid">

${Record not found}

</div>

<div ng-if="data.isValid">

<div class="panel panel-{{::options.color}} b">

   <div class="panel-heading">

       <h4 class="panel-title">${Approval request for {{::task.table}} {{::task.number.display_value}}}</h4>

   </div>



   <div class="panel-body">

       <div ng-if="task.attachments.length > 0">

           <label>${Attachments}:</label>

           <ul>

           <div ng-repeat="attachment in task.attachments">

               <a target="_blank" href="/sys_attachment.do?view=true&sys_id={{attachment.sys_id}}">

                   <img ng-if="attachment.thumbnail_path" alt="" ng-src="/{{attachment.path}}?t=medium" class="img-responsive"/>

               </a>

               <div>

                   <li><a href="/sys_attachment.do?sys_id={{attachment.sys_id}}" target="_blank"><strong>{{attachment.file_name}}</strong></a> {{attachment.size}}</li>

               </div>

           </div>

           </ul>

       </div>

       

       



       <div ng-if="data.items.length > 0">

           <h3><u>${Items in this Request}</u></h3>

           <div ng-repeat="item in data.items">

               <h4><a ng-href="?id=ticket&table=sc_req_item&sys_id={{::item.sys_id}}&view=sp">

                   {{::item.short_description}}

                   </a>

               </h4>

               <div ng-if="item.attachments.length > 0">

                   <label>${Attachments}:</label>

                   <ul>

                   <div ng-repeat="attachment in item.attachments">

                       <a target="_blank" href="/sys_attachment.do?view=true&sys_id={{attachment.sys_id}}">

                           <img ng-if="attachment.thumbnail_path" alt="" ng-src="/{{attachment.path}}?t=medium" class="img-responsive"/>

                       </a>

                       <div>

                           <li><a href="/sys_attachment.do?sys_id={{attachment.sys_id}}" target="_blank"><strong>{{attachment.file_name}}</strong></a> {{attachment.size}}</li>

                       </div>

                   </div>

                   </ul>

               </div>               



           </div>

       </div>

     

   </div>

</div>

   <sp-widget widget="data.ticketConversation" />

</div>

Server Script:

// g_approval_form_request is for approval summarizer ACLs

// that let user read a record they need to approve. This global

// variable is then deleted at the bottom of the script

g_approval_form_request = true;

var gr = $sp.getRecord();

if (gr == null || !gr.isValid()) {

data.isValid = false;

//return;

}

if (gr.getValue("approver") != gs.getUserID())

data.approver = gr.approver.getDisplayValue();

data.isValid = true;

var task = getRecordBeingApproved(gr);

var t = {};

t = $sp.getFieldsObject(task, 'number,short_description,opened_by,requested_by,start_date,end_date,price,recurring_price,recurring_frequency,requested_for,sys_class_name,request,quantity,cat_item,special_instructions,sys_id,request');

t.table = task.getLabel();



........



//Get attachments for current record being approved

t.attachments = getAttachments(t.sys_class_name.value, t.sys_id.value);





var items = [];

var idx = 0;

var itemsGR = new GlideRecord("sc_req_item");

itemsGR.addQuery("request", task.sys_id);

itemsGR.query();

while (itemsGR.next()) {

   var item = {};

   //Get attachments for requested items within parent request

   item.attachments = getAttachments("sc_req_item", itemsGR.getValue("sys_id"));



..............









function getAttachments(tablename, sysid) {

var attachments = [];

var stream = $sp.getStream(tablename, sysid);

for(var i = 0; i < stream.entries.length; i++){

var curEntry = stream.entries[i];

if(curEntry.element == 'attachment'){

attachments.push(curEntry.attachment);

}

}

return attachments;

}



..........

Re: Service Portal Approver can see attachments

kevinray — Thu, 01 Mar 2018 21:24:48 GMT

This is great and exactly what i was looking for, however it is very difficult to know where in the Server Script you are inserting or overwriting.

The ....... is a bit vague.

Any way to clearify?

Re: Service Portal Approver can see attachments

Community Alums — Thu, 08 Jul 2021 16:59:48 GMT

Hi @manikorada ,

Could you please update the link? I have the same question and the link is no longer valid.

Re: Service Portal Approver can see attachments

brianlan25 — Fri, 09 Jul 2021 16:56:02 GMT

Its been awhile and I no longer work for the company I set this up at but I believe the wiki article was for GlideSysAttachment.