[solved] Copying Attachments from Itemlists to Individual Instances in Subworkflow

0

I'm working on that at the moment
to sort new instance by category of Attachments from 1 tech item list with all attachments from flow.
I will try to use Daniels solution (I use in less complex flows)

Please, read it, because with out this in webcon 2022 you will no go forward ...

https://daniels-notes.de/posts/2023/copy-attachment-to-other-workflow

Hi,
I think that in this case it is best to:
1. when starting a new workflow remember the row ID
2. in the started element, on the start path add the action copy attachments from another workflow and using SQL, select only those attachments connected to a given row.

Thank you - unfortunately, that's not really what I need

Hi, I tried it like this (see picture)

the 2 id's that are displayed here are from different rows, so it has attached both documents in both instances again - have I forgotten something?

Hi,
you don't have to do a join on the WFDataAttachments tables.

Instead, return the column from the list of items in which you have the attachment (Befahigungsanchweis)

Do you expect more than one attachment in one row?

Hi,
Ok, I did it this way but like this there were no attachements passed to the new instance.

Yes, sometimes there can be more than 1 attachement.

Hi,
sorry, I was not precise ;)
In the query you need to map your Befahigungsanchweis column to ATT_ID

if you can have multiple attachments you will probably need to use the splittotable function (but firstly I suggest checking on one attachment per row)

Ah, now it's working - Thank you!
How can the splittotable-function be implemented?