Skip to main content
Version: 2023 R3

Add attachment

The action is used to add attachments to a workflow instance. Attachments can come from another specified workflow instances or can be selected with an SQL query.

Add attachment

1. Files choice mode​

Add an attachment to the current workflow instance from another instance Based on instance ID or Based on SQL query.

2. Source files choice based on instance ID​

Define the ID of the workflow instance from which attachments will be loaded.

3. Category​

Attachments to be processed will be selected based on their category.
Define it by selecting one of the following options:

  • All – attachments belonging to all categories will be selected,
  • Dynamic – create the category dynamically (using Variables editor) or enter it manually. The category can be provided in BPS format (i.e. ID#Name) or as ID.

Additionally, specify which attachments from the chosen category should be selected: All attachments, only The oldest attachment or only The newest attachment.

4. Regular expression​

Attachments to be processed will be selected based on a regular expression.
Use the Regex Creator as an aid in constructing the expression.

5. Based on SQL query​

Attachment selection via SQL query can work in two ways:

  • When selecting from the pool of attachments that exist in the BPS system, the query should return list of attachment IDs from the "WFDataAttachmets" table.

    Example
    SELECT [ATT_ID] FROM [WFDataAttachmets] WHERE [ATT_Name] IN ('file.docx', 'file2.docx');

    When it is required to change the attachments' name or description, the query should additionally return FileName and/or Description columns.

  • When attachments are to be created when executing the action, the query must return columns FileName and Content, containing the attachment’s name and byte content. The query may also return a Description column if required.

    Example
    SELECT convert(image,'0x') AS Content, 'file1.txt' AS FileName

6. Source files settings​

Defines what will happen with source files once they have been added to the target workflow instance.

  • Copy attachments – attachments will be added to the current workflow instance, they will also remain on the source instance.

  • Move attachments to the current instance – attachments will be added to the current workflow instance. After being added, they are removed from the source instance.

  • Verify user’s permissions to source files – if the current user does not have privileges to access the source files, they will not be added to the workflow instance.

7. Destination files settings​

Defines the behavior of attachment files after they are added to the workflow instance.

  • Category – defines to which category the files will be assigned after being added to the workflow instance:
    • Dynamic – enter the name of the category to which the attachment will be assigned,
    • None – after being added, the attachment will not belong to any category.
  • Overwrite if attachment with this name already exists – the existing attachment will be overwritten if the workflow instance already has an attachment with an identical name.

8. Variables editor​

Dynamically generated tree containing all variables that may be used in the current location of Designer Studio. Information on how to use variables in WEBCON BPS, as well as a list of variables can be found here.

info

For more information, see the article The "Add attachment action" on our technical bog.