The Perspectium DataSync Express requires, at a minimum, access to the attachment tables (sys_attachment, sys_attachment_doc, sys_attachment_doc_v2, etc) in order for the application to be able to access attachments to share out when you select the Include attachments option on a share or specify an attachment table to be shared out. Modifying the table access as described will allow attachments to be sent when sharing records.
Prerequisites
First, you will need to install the Perspectium DataSync Express application.
Procedure
To modify table access, follow these steps:
Navigate to the sys_attachment record
In the Global application scope, navigate to System Definitions > Tables. Filter the table by searching for the name sys_attachment and click the record.
Set up Application Access for sys_attachment table
Navigate to the Application Access tab. Please ensure this table is accessible from All application scopes. Then, click the Can read checkbox and Update the record.
Define cross-scope privilege records for sys_attachment
Next to change to the Perspectium DataSync Express application scope and define cross-scope privilege records to the sys_attachment table from the Perspectium DataSync Express application (System Applications > Application Cross-Scope Access) that have a Status of Allowed for Read. You will create a record as follows:
Repeat steps for sys_attachment_doc tables
Follow the steps above for Application Access and Cross-scope privilege for the sys_attachment_doc table and if they exists, any other sys_attachment_doc tables like sys_attachment_doc_v2, sys_attachment_doc_v3, etc.
For example, a sys_attachment_doc cross-scope privilege record would be as follows:
Clear the instance's cache
In order for the new privileges to take effect immediately, you will need to clear the instance's cache. To do this, change back to the Global application scope, go to System Definition > Scripts - Background and then run the following script with global as the scope:
gs.invalidateCache();
The script may take a few minutes to complete.
Once these steps are completed, you can now select the Include attachments option on a share or specify an attachment table to be shared out.