Creating attachment queries

Forms that have been enabled for attachments can have URLs or comments attached to them. Use this procedure to retrieve attached URLs.

To create an attachment query

  1. Log in to Query Builder.
  2. Set the command type to GetAttachments.
  3. In the left pane of the Query Builder, locate the file that includes attachments.
  4. Expand the file and the indexes below it.
  5. To access the attachments, double-click the required index.
  6. Replace any occurrences of "*****" with values or variables for the indicated required fields.
  7. Optional. Include statistics in the query. This option retrieves statistics about the attachments, including ID of user who created the attachment; creation date; last modified date; and so on.
    1. Right-click in the Properties view of the query and select Command Properties.
    2. Expand the command properties, either for all attachment queries or for the active query.
    3. Right-click on Include Statistics and select Edit Property Value.
    4. Set the value to True and click OK to close the User Preferences window.
  8. Review the query in the lower right pane of the Query Builder.
  9. Click Execute to test the query.

    If the query has problems and the problems are not obvious, you can set Execution Logging to Server Calls to Log File. See Execution Logging for more information.

  10. When the query works correctly, save the query.
  11. To make the query available to your VB or other application, select the text of the query and then select Copy from the Edit menu to place your query on the Windows clipboard.