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"

Reply via email to