07-04-2013 03:06 AM
atachments are stored in SYSATTACHMENT table.
If you want to know if there's an attachement on your record, you need to
1. edit your formatctrl,
2. add a query to count attachments
3. add a validation to check this count is greater than zero
Do you know how to do that ?
07-11-2013 04:04 AM
You cannot add an attachment to a record before you save it. Service Manager can attach files only to an existing record in the database.
Since attachments panel is separate java penal and attachments are saved in SYSATTACHMENTS ,so you have to query the table in fc and then place a validation and you can not mandate it while selecting the particular subarea.
07-11-2013 04:31 AM
I guess you wanted to reply on my other post..
Also please note we are able to attach docment before saving the interaction with Delay in Assigning Interaction id ? to false in Environment Records for Service Desk profile.
The other post says that how we can auto populate the attachment based on the subarea.
07-11-2013 04:45 AM
Since attachments are saved after record save and attachment are control by separate java applet so not feel possible to link both these simultaneously.
Attachment pane does not controlled like other fields (by fc etc)
07-11-2013 05:20 AM
here's what you have to do :
In your master format control go to queries and display extended view, then add a query :
filename = SYSATTACHMENTS
query = whatever is suitable to get the correct number of attachment (in the screen shot, i count attachment for a request)
comment = count
display = true
in the calculation tab, add a line
calculation: $myCount = 1 $file.count
that is if you have only one query. If your query is the second, you take (2 in $file.count).
finally, in validation tab, add a line
add/update: subarea in $file="your special value"
message: "attachment is mandatory for this subarea !!"
Save your format control and there you are.
other post with same question : http://h30499.www3.hp.com/t5/HP-Service-Manager-Se