Hi Robert!

Unfortunately, displaying the various sections' attachments together in one attachment component is impossible. However, you can use a separate attachment component for each section.

To implement this, we recommend the following steps:

1.  Open the Page Designer.

2.  For each section that you would like to display the attachments from:

- add the dropdown field, specifying this section as “Lookup” in the field’s general settings (or make sure that such a dropdown field already exists);

- add the attachment component.

3. In each added attachment component, set “Record to attach files” (general settings) to a value from the previously added dropdown field and “File storage location” (advanced settings) to the corresponding table.

After you choose the exact records in the dropdown fields, they will be linked to the current record, and you will see their attachments in the corresponding components. It will help you to avoid duplicating documents.

Best regards,

Natalia

Hi Anupama,

From the client side the chain is as follows: upload method from the FileDetailV2 module then calls the upload method from the ConfigurationFileApi module. This ConfigurationFileApi module upload  method triggers the server side UploadFile method from the FileApiService class that uses the FileRepository class that uses the FileUploader class UploadFile method (that calls the UploadInternal method (with additional validations) and finally uses the Upload method to upload the file). So the upload on the server side is performed using the Upload method from the FileUploader class.

To locate the place where the file should be uploaded the FileUploader upload method uses the EntityFileLocator method that uses the fileUploadConfig (that is an object formed from the client-side when the ConfigurationFileApi module upload  method is called). For example if you are loading a file to the Contacts section the object to which the file will be saved is called ContactFile (and it can be also found in the database and configurations).

Best regards,

Oscar

Hi Bhoobalan,

The only possible way I see here is to create a database trigger that would be triggered upon each user session start that would delete all records related to the system user rights from the SysAccountFileRight table (record permissions for the AccountFile object should be enabled for this table to appear in the database) (only for records that were created in the past day so not to provoke high SQL-server CPU consumption). Also please note that theoretically you should also add denying access rights for the system user in the SysAccountFileRight table for all the attachments created in the past two or one day.

Best regards.

Oscar

Oscar Dylan,

Thanks for the response.



Here, I would like to perform the delete operation only on the attachment record that I select which should be in the same session of a user when the attachment was added (not all records).

Also, I couldn't find the table SysAccountFileRight.



Note: Validation should be performed only with the click of delete.







Regards,

Bhoobalan P

Bhoobalan Palanivelu,

Please double-check my previous reply: record permissions for the AccountFile object should be enabled for this table to appear in the database.

The database trigger will do the task you need, there is no need to develop some client logic (also it will be a very difficult task to check the user session, compare it to the file creation date and then pass this information to the validator using the client logic).

Best regards,

Oscar

Bhoobalan Palanivelu,

Regarding the link between attachments & user sessions - 



I do not think there is a track between the Attachment record and the session it was created in. The closest you can get to it is use the CreatedOn timestamp from the Attachment table and read SysUserSession table for any sessions in that range.



Another thing to be kept in mind is that -  A user can create multiple sessions at a time and logging out only closes that specific session leaving the remaining sessions active. Additionally, physical act of logging out is different from user session expiry. Later can happen automatically as well without any user action.



So some kind of approximation/change in the logic you have mentioned will need to be done Eg 'No active user session exists with session start time < Attachment's createdOn time stamp' is possible to check. But there is no guarantee that the exact session used to add the attachment was closed - given a multi session scenario. 

Hi Reid! 

We recently uploaded an application to the marketplace 

that allows you to download all the files of a section, example of an 

account, in a ZIP file. 

Check it here: https://marketplace.creatio.com/app/download-zip-button-creatio

Thank you

Regards

To achieve your target you need to create a link that is a sum of:

https://<instance>/0/rest/FileService/GetFile/

+

UID value from SysSchema table for the detail from which you try to get file from: OrderFile, InvoiceFile, AccountFile etc

+

ID value from the table which represents this detail.

For example I have a record in OrderFile table (order attachment) with an ID: 2AC7AA00-2E61-4AEC-8BD0-621269731DAA. To complete the link I execute:

SELECT UID FROM SysSchema WHERE Name = 'OrderFile'

and get a value of D75D815B-0B2E-4E33-973A-ED9A43601B44. So my link is:

https://<instance>/0/rest/FileService/GetFile/D75D815B-0B2E-4E33-973A-ED9A43601B44/2AC7AA00-2E61-4AEC-8BD0-621269731DAA

Please note that user that doesn't have active session in https://<instance> won't be able to download the file.

Oscar Dylan,

How do I set the system actions to that I have a process like this:

Janine White,

It is impossible to do using the process on the screenshot. You need to add an auto-generated page where you can specify file name and schema name, after that this process should read this file and schema parameters (there should be several conditional flows for different schema names). Also you need to create a lookup with all schema names so to be able to choose from lookup in this auto-generated page from the first step. Then there should be "Read data" element that reads "Schema" object so to get UID of the schema specified on the auto-generated page that we've added previously. After that the formula element should create a link for the string parameter (using the logic I've described previously) that will be used in the final auto-generated page element where this string parameter value will be placed. Feel free to use our official documentation on business process design to achieve your business task.

Oscar Dylan,

I can read the file name from the attachment record, which is available in a parameter, and I know the attachment section, "bpm'online Environments attachments".  Why would I need to select anything manually?  I know how to set up business processes in general and use Read data elements as I've done that hundreds of times. I just don't understand how to identify the Schema and UID from the attachment record from the instructions above.  When I use the following read data, the UID is returned as zeros, clearly missing. The link in the process ends up being, "https://dev-katerra.bpmonline.com/0/rest/FileService/GetFile/00000000-0…" where "abe00c37-67f4-413c-93a0-1fa4af899bdc" is the Id of the attachment.

Nevermind, I figured out that the UID is in the link for existing files, so, I don't need to look it up.  I'll just copy it from there.

Oscar Dylan,

 There is a way to preview the file in the browser if there is a image? What format is returning the method to the client?

this  works to show the attachment in the browser.

var endpoint = "https://"+window.location.hostname+"/0/rest/FileService/GetFile/7661a363-68f6-4c26-879c-0590c22b963a/" + responseCollection.collection.items[0].$Id;
 
 
 
fetch(endpoint)
  //                         vvvv
  .then(response => response.blob())
  .then(imageBlob => {
      // Then create a local URL for that image and print it 
      const imageObjectURL = URL.createObjectURL(imageBlob);
      console.log(imageObjectURL);
  });

Hi Mariia,

Did you figure out on how to change this?

I am looking for the solution as well.

Thank you in advance!

Kind regards,

Yosef

Hello Yosef,

Yes, we have found a solution. It was simple for our case.

Firstly, you need to add the necessary column to the [Section]File object, where [Section] is the name of your section in which the detail files are placed (In my example the column with type lookup names "Nature").

Then you create a "Replacing Client Module" where the parent schema is LinkPageV2 ( UIv2 ).

And then you create your column in the diff part:

define("LinkPageV2", ["terrasoft", "BusinessRuleModule", "ext-base", "sandbox", "ConfigurationConstants"],
function(Terrasoft, BusinessRuleModule, Ext, sandbox, ConfigurationConstants) {
	return {
		methods: {},
		diff: /**SCHEMA_DIFF*/[
			{
				"operation": "insert",
				"parentName": "LinkPageGeneralBlock",
				"propertyName": "items",
				"name": "Nature",
				"values": {
					"bindTo": "Nature",
					"layout": {
						"column": 12,
						"row": 0,
						"colSpan": 12
					}
				}
			},
		]/**SCHEMA_DIFF*/
	};
});

That's it)

Best regards,

Mariia

Dear Ezequiel,

The addition of the attachments detail is described in the article below:

https://academy.bpmonline.com/documents/technic-sdk/7-12/adding-attachments-detail

The Notes part is a rich text field, however, you can simply check how it is implemented on a page and replicate it.

Warm regards,

Matt