| email messagein mailbox table | |
Posted: Fri Jul 24, 2015 8:38 am |
Points: 0 |
|
joebit |
GoldMine Journeyman |
|
|
Joined: 21 Jun 2009 |
Posts: 32 |
|
|
|
|
|
|
|
|
Can somebody tell me where the email body is stored in the goldmine mailbox table. I'm wanting to delete just the emailbody of certail email blasts that have increased the size of my mailbox table. Is it the field labeled RFC822 or is this a image field??
regards
Joe |
|
|
|
|
Posted: Fri Jul 24, 2015 9:52 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
Yes:
-RFC822 is the field that holds the email bodies.
-It is an image type field. |
|
|
|
|
Posted: Fri Jul 24, 2015 3:28 pm |
Points: 0 |
|
joebit |
GoldMine Journeyman |
|
|
Joined: 21 Jun 2009 |
Posts: 32 |
|
|
|
|
|
|
|
|
I'm trying to delete just the content of that field without loosing the rest of the links in the email record.
If i run a select query e.g.
SELECT RFC822 FROM SQLGOLDMINE.DBO.MAILBOX MB WHERE ((MB.CREATEON >= '2014-07-24' AND MB.CREATEON <= '2015-07-24') OR (MB.MAILDATE >= '2014-07-24' AND MB.MAILDATE <= '2015-07-24')) AND (MB.MAILREF LIKE '%auction notification & invitation%')
I get all the content of the rfc822 field for the blast relating to "auction notification and invitation"
What would the delete query look like to delete these results. |
|
|
|
|
| | |
Posted: Fri Jul 24, 2015 3:40 pm |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
Easy:
Code: |
delete from mailbox where... |
The problem is, however, mailbox records also have CAN or CONTHIST records associated with them. You'd probably want to delete those first.
So I'd
Code: |
delete from conthist where recid in (select linkrecid from mailbox where ...) |
and
Code: |
delete from cal where recid in (select linkrecid from mailbox where ...) |
before
Code: |
delete from mailbox where ... |
Obviously, this is a somewhat dangerous thing to undertake without a full understanding of the database and data involved. I'd make a full backup of the database (or just the involved tables) before issuing any delete commands. |
|
|
|
|
| | |
Posted: Fri Jul 24, 2015 4:12 pm |
Points: 0 |
|
joebit |
GoldMine Journeyman |
|
|
Joined: 21 Jun 2009 |
Posts: 32 |
|
|
|
|
|
|
|
|
I'm testing these statements on a test server so my production database is not affected.
I was hoping to keep references of the email blast in the history of each person that received it just want to get rid of the bulk building up in the mailbox table and thus my database. I thought that if i kept the rest of the mailbox table in place after deleting the contents of RFC822 i would achieve that.
Moving forward i will not save the template text history when i send out future email blasts.
regards |
|
|
|
|
Posted: Fri Jul 24, 2015 4:26 pm |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
well then, sure, just delete the mailbox records and leave it at that. Should be fine. |
|
|
|
|
ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|