ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Is there a Notes Object in Clarity PPM > Studio > Objects?

book

Article ID: 145748

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

There is a Notes icon on the Task page and once we enter the text, we can't find where it is saved in Studio > Objects. How do we retrieve the data from Notes?

Environment

Clarity PPM Application

Resolution

- In Clarity PPM Studio > Objects we do not have a Notes object.
- In the database we do have a notes table called PRNOTE.
- In this table we store notes create on tasks, timesheets, etc.
- The data gets stored in the PRNOTE table- this table stores data on notes, for more information on the table check TABLE_PRNOTE in the Clarity PPM database schema index on CA Broadcom Techdocs.
- When querying this table you can use the PRTABLENAME field and enter the table name you need.
For example, select * from PRNOTE where PRTABLENAME = 'PRTimeSheet'