Question

Where to find Attachments for an Activity.

19:07 Oct 04, 2018

I have a business process where I have the user attach an order to an activity. I would like to then move that attachment to the case that is part of that activity. When I attempt to read data following the task, I do not see the table where attachments are assigned to the activity.

I see the attachments for other objects (Cases, Configuration Items, etc.) but not Activities.

11 comments

Grigoriy

20:25 Oct 04, 2018

See table "ActivityFile"

Bob Walters

20:30 Oct 04, 2018

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

Grigoriy

20:38 Oct 04, 2018

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"

Bob Walters

21:20 Oct 04, 2018

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.

Grigoriy

23:01 Oct 04, 2018

Describe in more detail what you want to do.

Bob Walters

23:45 Oct 04, 2018

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.

Grigoriy

02:39 Oct 05, 2018

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();