[Date Prev] [Date Next] [Prev in Thread] [Next in Thread] [Date Index] [Thread Index]

Re: Is it a good idea to eliminate the use of Diary Fields?


And the unlimited Display Only field method will not work as it will be subject to the same cell character limit as a Diary field.




From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Wednesday, March 15, 2017 3:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: Is it a good idea to eliminate the use of Diary Fields?




BMC themselves went away from Diary fields for the most part (certainly in the work log process) many years ago....the down side, as you pointed out is storing the diary in individual records causes issues with reporting....this is easily worked around in a sufficiently advanced reporting tool allowing you to create sub-reports reporting all of the diary entries from a second table....the fact that they can't be pulled in the same entry is the only down side that I know of...with plenty of up sides.


On Wed, Mar 15, 2017 at 3:06 PM, Reiser, John J  wrote:


Hello Listers,


Is there a downside to replacing diary fields with a different method of capturing work activity?

Since diary fields don’t show up in Mid Tier Web reporting I was looking into a way to replace the diary field for reporting.


We actually have reports that get created in csv format for Excel that use the Diary.

Occasionally we have a diary so large it breaks the cell character limit in Excel.


I was contemplating using a table field to display records from a work activity form and then using either a join or some other temporary means to gather the activity into a report.


Can I use an unlimited Display Only field to dump the diary during the report process?

Is there a better mouse trap for collecting large amounts of data and reporting it?


As always, thanks in advance.


Thank you,

John J. Reiser
Building 760-J202
Remedy AR System Developer

Senior Software Development Analyst
Lockheed Martin - RMS Moorestown Region
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me




_ARSlist: "Where the Answers Are" and have been for 20 years_