Highlighted
Frequent Contributor.. Frequent Contributor..
Frequent Contributor..
451 views

How to show attachment file in incident management record true or false in probsummary field

Hi,

I want to show attachment file which is true or false in incident record view.For instance,IM32434 record has attachment file,and then a field which is in probsummary table it should show true.

How can I provide it?

Tags (1)
0 Likes
2 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: How to show attachment file in incident management record true or false in probsummary field

@ehamderi,

First of all, in latest release, you can get the information in the ticket:

2017-02-14_15-49-10.jpg

And in old releases, you can find the number by running following query on SYSATTACHMENTS table, following sample is for get the attachment number count for IM10002

var file = new SCFile("SYSATTACHMENTS");

var query = "application=\"probsummary\" and topic=\"" + "IM10002" + "\" and segment=0";

var count=file.doCount( query ) ;

print(count);Let me know if it helps,

Let me know if it helps,

Ling-Yan

0 Likes
Highlighted
Frequent Contributor.. Frequent Contributor..
Frequent Contributor..

Re: How to show attachment file in incident management record true or false in probsummary field

In fact,I want to show view a column of hp service manager which incident record has attachment or not.For instance,I created a field as attachment_x.If IM24556 record has an attachment,this field should be YES.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.