The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Tables that store the Emails?
Posted: 23 Apr 08 8:11 AM
|
Hi,
When you click on Send SLX button where is the contents stored besides the History table in the Notes column? Under SQL that field size is only 255 and that seems to be too little cause I can see larger emails within the SLX Notes section.
Is there another location where that info is stored?
I ran a SLX query and was able to export to Excel but limited to 1000 characters and that's not even the entire email if it actually exported the whole thing.
I'm using Enterprise manager to run my SQL queries.
Harvey |
|
|
| |
|
Re: Tables that store the Emails?
Posted: 23 Apr 08 9:31 AM
|
| I can see that the LongNotes contain it but I can't search it with Crystal, how would I go about pulling the data out of there. |
|
|
|
Re: Tables that store the Emails?
Posted: 23 Apr 08 12:40 PM
|
What is it you are trying to do? A text blob might not be easily handled/searched from Crystal.
Something you might want to look into instead of Crystal is SpeedSearch. SpeedSearch is designed to search through history, attachments, tickets, etc. which sounds like what you are trying to do |
|
|
|
Re: Tables that store the Emails?
Posted: 23 Apr 08 1:24 PM
|
I just needed the a date and the emails matching some keywords in the email contents exported out.
One of my associates is proficient with Crystal and I was able to guide him with what I needed and able to export it from there with the LongNotes.
Thanks for your help.
Harvey |
|
|
| |
|