Question
ING
NL
Last activity: 12 Feb 2025 7:44 EST
Display Closed Email Interactions
Team,
We have a requirement to display email interaction which are closed/resolved from worklist/work basket
Along with the Email Body of the task
I think these will be stored in some DB, Could you please from where we can able to display (Source)
ING
NL
Good Day
We have a requirement to create a landing page to display all the email interactions open, closed and pending status with Email body and Email Subject.., Is there any OOTB tables available to create a RD to fetch these details in Pega CS
We are using Pega 24.2 version
Updated: 12 Feb 2025 6:41 EST
Pegasystems Inc.
GB
@surir the user has a question about CS Email Bot, asking whether Pega has OOTB RD or tables to display all the cases created, closed and opened status with Email Body and Email Header
--> can someone from the CS team please answer this question?
@umamaheswar.bk please can I ask why you have posted this question again? This seems to be a duplicate of Email interaction , wrap-up not working for Work queue posted 20th January ( and Email Interactions with historic data, posted 11 February which I have closed).
---------------------
⚠ Below is a GenAI-powered answer . All generated answers require validation against the provided references.
The primary table you can use for this purpose is the pc_work_triage table, which is specifically designed to store comprehensive email interaction information. This table is part of the Work-Channel-Triage class and contains all the data elements you need for your landing page:
@surir the user has a question about CS Email Bot, asking whether Pega has OOTB RD or tables to display all the cases created, closed and opened status with Email Body and Email Header
--> can someone from the CS team please answer this question?
@umamaheswar.bk please can I ask why you have posted this question again? This seems to be a duplicate of Email interaction , wrap-up not working for Work queue posted 20th January ( and Email Interactions with historic data, posted 11 February which I have closed).
---------------------
⚠ Below is a GenAI-powered answer . All generated answers require validation against the provided references.
The primary table you can use for this purpose is the pc_work_triage table, which is specifically designed to store comprehensive email interaction information. This table is part of the Work-Channel-Triage class and contains all the data elements you need for your landing page:
- Email interaction status (open/closed/pending)
- Email body content
- Email subject information
You can create a Report Definition (RD) that queries this table to fetch the required information for your landing page. The table has been a stable part of the platform since Pega 8.5 and is fully supported in your version (24.2).
Technical Implementation Note:
- Base Class: Work-Channel-Triage
- Table Name: pc_work_triage
- Purpose: Stores complete information about email triage cases
- Capabilities: Supports custom reporting and data transforms for extended functionality
If you need to extend the columns or create custom reports, you can do so by running data transforms on this table. This gives you the flexibility to customize the display according to your specific requirements.
For detailed technical specifications, you can refer to the database schema documentation at: Database schema for email bot tables
--------------------------
In Email interaction post you did not Accept Solution but you changed the question to a translation issue, which will lead to confusion. For the Ack Email Dutch translation issue you have logged INC-C5045 .
Pegasystems Inc.
IN
@umamaheswar.bk displaying email body is a performance intensive task and I won't recommend doing it ever on the dashboard. A short description yes, but not the entire body. Have you tried using the existing associations on interaction work and email triage to achieve this via Insights table?