LoanPro Database - Retrieve Sent Email Information
Note: This article is only applicable to customers who have direct access to a read-only copy of their LoanPro database.
Sometimes it's useful to pull information from the database about email communications that have been sent to your customers. This information can be found in the system_note_entity table.
system_note_entity table structure:
The id of the entity
Type of the associated entity
ID of the associated entity
operation sub type
ID of the user that created the entity
creating user name
Timestamp of when the entity was created
Timestamp of when the entity was last updated
IP address of the client machine
Whether or not the entity was deleted
1 - yes, 0 - no
This table holds all the system notes, not just those for email communications. As such, if you want to pull email communications from this table, you will want records with the following properties:
entity_type = Entity.Customer
operation_type = service_call
operation_Sub_Type = systemNote.operationSubtype.email
The database can be queried using SQL. Your query may look something like this:
SELECT * FROM system_note_entity WHERE entity_type="Entity.Customer" AND operation_type="service_call" AND operation_Sub_Type="systemNote.operationSubtype.email";
The table above will shows the fields that this will return.