Size column in Mail db

Copy to Archive

Move to Archive

Document Library
Main Topic

Kurt Tomicich
2005/02/15

Procedure
Reference

Subject:	Size column in Mail db
Category:	Tips\ Notes

Version:
Revision Date:	2005/02/15 Modified: 2006/01/07


		Reviewers
Originator	Previous	Current	Future
Kurt Tomicich	Kurt Tomicich/KRT	None	None

To implement this technique, make one simple change to the ($Inbox) folder design. Change the Size column formula to this:

size :=@DocLength;
mb:=1048576;
kb:=1024;

REM "change second argument of @Round function to .01 for 2";
REM "decimals, .1 for 1 decimal or 1 for no decimals.";

sizek :=@Text(@Round(size/kb; 1)) +" K";
sizemb :=@Text(@Round(size/mb; .01))+" MB";
sizeb :=@Text(size) +" b";
@If(size>mb; sizemb; size>kb; sizek; sizeb)

Show details for R7 Code is a little different.

R7 Code is a little different.

Hide details for R7 Code is a little different.

R7 Code is a little different.
Incorporating the "existing version" testing code with the above results in this:

vDocLength:= @If(

@IsDocTruncated;

@If(@TextToNumber(@Version) < 172; @DocLength;

@DocOmittedLength + @DocLength);

@DocLength);

size :=vDocLength;

mb:=1048576;

kb:=1024;

REM "change second argument of @Round function to .01 for 2";

REM "decimals, .1 for 1 decimal or 1 for no decimals.";

sizek :=@Text(@Round(size/kb; 1)) +" K";

sizemb :=@Text(@Round(size/mb; .01))+" MB";

sizeb :=@Text(size) +" b";

@If(size>mb; sizemb; size>kb; sizek; sizeb)

Submitted for review on 2/15/2005
Review completed by Kurt Tomicich on 2/28/2005

All Documents By Author By Category By Alternate Name Review Status Help