/
Database view containing case notes from Case Management program

Database view containing case notes from Case Management program

Description of Issue

Client needs TRS view that contains case notes field in Case Management program

Context
  • Enterprise ERP version 2020.1

  • SSRS Reports

  • Tyler Reporting Services Views

Cause

Need TRS view for building a custom report

Resolution

The case notes is under the column cy_notes in the view pm_case_history.

Additional Information

 

Related content

Database view and column containing purchase order notes
Database view and column containing purchase order notes
More like this
Database table or view for Notes and General Notes in Project Master
Database table or view for Notes and General Notes in Project Master
More like this
What took the place of the TRAQS database table for SSRS use
What took the place of the TRAQS database table for SSRS use
More like this
Database view containing comments for a work order
Database view containing comments for a work order
More like this
Database view for comment field in application plan review
Database view for comment field in application plan review
More like this
Database view containing inventory item description
Database view containing inventory item description
More like this