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


(warning) 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 > TablesFilter 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.