Communication Object – SQL
The Communications Object allows a user to send an html-based email to all users on a project, in a security group, or to individual users directly from Clarity. An email can be sent by creating a new entry on the Communication List page, upon saving a new entry the email process with trigger and send the email.
Auto Start Solution: An email can be sent by creating a new entry on the Communication List page, upon saving a new entry the email process with trigger.
On Demand Solution: All emails could be sent together as a broadcast communication by running the process manually from the Organizer. This process could also be scheduled to run on a specific time using Jobs
The table below describes the available columns on the object.
Column Label | Description |
From | Who the email is coming from |
Sent To | Individual users the message should send to |
Send to Group | Security groups the message should send to (users within the security groups) |
Message Project Team | Should this message be sent to a project team |
Associated Investment | If Message Project Team is checked, which project should the team list be pulled from |
Message Subject | Subject line of the email |
Message Content | Body of the email (html) |
Message date | Internal code used by the query |
Either of the on-demand process or auto start process should be active at a time.
The package provides two Processes:
1. Send Notification (ID:rego_send_notification)
This is an auto start process. The notification is sent immediately when a new entry is created on the Communication object. Only one email notification will be sent for one entry. Any updates to the same entry will not trigger any new notifications.
2. Email Communication (ID:rego_email_comm)
This is an on-demand process that could be run from the Organizer. This send notification to all the entries on the Communication objects for which a communication was not already sent. This process does not have a Primary object.
The processes are designed to work both in Oracle and Postgres environment. If the DB vendor information from Properties.xml is Postgres the SQL query for Postgres will be called. If not, the default SQL is Oracle.
Important Note: Either of the processes should be active for an Implementation. If both the processes are active the on-demand process has no effect and will never send any communication.
All object entries have a sent flag which will be marked whenever a notification is sent. Both the processes set the same flag on the object instance. Only with admin DB rights this flag could be overwritten.
Object Name:Communication
Object ID: rego_communication
Flag Attribute Name: Sent (Id: rego_sent)
Download Details
RegoXchange Content ID: EX2081
Submission Date:
Submitter:
Content Type: Clarity Studio
Related Modules: Applications
Company: Rego Consulting
Version Support
Versions Supported: 15.9+
Special Instructions
Special Instructions: The content is delivered in .jar file format. Use Clarity PPM Studio Content Package migration utility tool for the installation. The Communication architecture consists of a Communication Object and a Process. Please install & set permissions as appropriate on the Communication Object first, then install, set permissions as appropriate, validate & activate the Rego Communications Process.