Where to find Attachments for an Activity.

See table "ActivityFile"

ActivityFile is not on the list, but "File and Link of Activity" is.  Are these the same objects?  

Yes If you work with sql or Entity shema query use object name ActivityFile and if you work with read, modify or insert data component in busness process select "File and Link of Activity" 

Found the information, however, now I am getting an error when trying to attach the file to the case.  I read the data from the Activity and when I try to write it to a new "Attachment and Notes detail in Cases", I get an Item with path "191764f7-1dc7-47d5-b16d-5002b799f1e0.32cd6fe8-2cb2-4284-8cda-b17b842e76d7.73c5b07b-3c1a-44fc-953e-f2ce6cbb7420" for process Id "5bd26364-ceda-4ef2-9b22-eb389d6bfba7" not found. error.  

When reading, I am presented with two IDs, a Task ID and a Result of Activity ID.  Neither ID seems to work in this context.  

I checked that the file is being attached to the activity, I just am missing something in trying to find the file.  

Describe in more detail what you want to do.

Grigoriy,

I am creating a business process that is functioning as a RMA.  I first create a case for the return and then create an activity for our order management team to create an order for the replacement part in our accounting system.  After the order is created, the PDF is attached to the Activity.  What I am trying to do is automatically take the order that is attached to the Activity and automatically link (or copy) it to the case.  

Standard approach to get a list of all the files associated with this activity and add them to the list of files associated with the case. If you know the activityID and the caseID, you can transfer all the files associated with it  (ActivityFile) to CaseFile

I would do everything in a script like something like:

insertSelect = new InsertSelect(UserConnection)
	.Into("CaseFile")
	.Set("CaseId")
	.Set("Name")	
	.Set("Notes")
	.Set("Data")
	.Set("TypeId")
	.Set("Version")
	.Set("Size")
	.FromSelect(
		new Select(CurrentConnection)
		.Column.Const(CaseId)  //maybe need Column.Parameter(CaseId)
		.Column("Name")
		.Column("Notes")
		.Column("Data")
		.Column("TypeId")
		.Column("Version")
		.Column("Size")
		.From("ActivityFile")
		.Where("ActivityId").IsEqual(Column.Parameter(ActivityId)) as Select);
insertSelect.Execute();

Thanks.  Worked like a charm.

Сorrected example

can you tell me any function which can convert image into text

Bhumika Bisht,

Please find the answer to your question in the article by the link below:

https://community.creatio.com/questions/ocr-mechanism

Best regards,

Norton