Database view containing TCM attachments

Owned by Knowledge Assistant
Feb 23, 2023
1 min read



Description of Issue

Client wants database view containing TCM attachments to build custom report



Context

  • SSRS reports

  • Crystal reports

  • SaaS, Tyler-hosted clients

  • OnPrem, Self-hosted clients

  • TCM attachment file name



Cause

View database columns does not show any TRS views information



Resolution

All file names will be found in the at_document columns within the sp_attach view.

To link this back to a particular record you will use a combination of at_program and at_key columns.



Additional Information