000035934 - Filtering records using attachment fields in RSA Archer

Document created by RSA Customer Support Employee on Jan 19, 2018Last modified by RSA Customer Support Employee on Jul 2, 2019
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000035934
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.x, 6.x
 
IssueThis article explains how to create a report with records that contain attachments in an application.
Resolution
  1. Create a calculated text field.
  2. Use the following formula:


If(COUNT([Attachment Field]) > 0, "Yes","No")


Even though attachment fields do not appear in the field selection in the formula builder, we still can reference the field in a calculation.


  1. Save the field. 
You can now use this calculated text field in your report to pull just the records with/without attachments.

 

Attachments

    Outcomes