Hi, A very long time ago I made a competent but a little ugly tool to convert diary-data to a single record per entry.
https://rrr.se/cgi/index?pg=diaryx You might want to change your solution and store all the diary data as individual records instead of the big text-data used in diary-fields. You will then show your diary data in one (or three) table-fields instead. When you select a row, the details can be shown in a display-only field. You can use filters to push data there for new tickets, and then use RRR|DiaryX(tractor) to convert your current data to the new format. The diary-field is just not suitable to report on... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > I have several diary fields. one in the incident ticket, one in the > schedule ticket, several in the sub-tasks of the same schedule tickets. > > management would like to have a single report to list them , by datetime, > & content of dairy fields, in time orders. > > I am still in Remedy ARS 6.3 , and CR report tool XI. > > any tips from you are welcome. In ARS v3.x I remember there is some > programs to expend the dairy in the SQL level. However, I hope by now, > should have some easy way. > > Thank you in advance for youe help. > > Regards, > > Omega LiPO > email: [email protected] > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

