Hi,
Doing it with Meta-Update is a good choice for a one time thing.
The technology is not inherently bad for using as a permanent solution, but I
would suggest that you use a Push-Fields (Filter, Escalation, Active-Link) to
add to the diary-field instead. Or maybe an API-program (could be
Meta-Update), WebService etc that performs an update of the record in quetion.
In other word I think it is a bad idea to do low-level meddling with the
diary-data content when there is a built in way to add to a diary-field (which
includes the API if that is your choice).
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.
> Our free Diary Editor will allow you to do this one record at a time in a
> Notepad like interface.
>
> For mass changes, Meta-Update will do this and not through SQL.
>
>
>
> It is of-course possible to do this through SQL but you need to understand the
> separators and encoding making up a Diary field value.
>
>
>
>
>
>
> Cheers,
>
> Ben Chernys
> Senior Software Architect
>
>
> Canada / Deutschland
> Mobile: +49 171 380 2329 GMT + 1 + [ DST ]
> Email: <mailto:[email protected]> [email protected]
> Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com
>
> We are a BMC Technology Alliance Partner
>
>
>
>
>
> Check out Software Tool House's free Diary Editor and our Freebies Section
> for ITSM Forms and Fields spreadsheet.
>
> Meta-Update, our premium ARS Data tool, lets you automate your imports,
> migrations, in no time at all, without programming, without staging forms,
> without merge workflow.
>
>
>
> Meta-Archive does ITSM Archiving your way: with your forms and your
> multi-tenant rules, treating each root request as the tree of data and forms
> that it is it is.
>
>
>
> Pre ITSM 7.6.04? Clarify? Roll your own? No problem!
>
> You can keep your valuable data!
>
>
> <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/
>
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[email protected]] On Behalf Of Su Kaur
> Sent: June-13-16 12:24 AM
> To: [email protected]
> Subject: Update worklog (diary ) field from sql - v9
>
>
>
> Hello,
>
>
>
> I am trying to append some data to existing worklog field using a sql
> statement. Nothing is working out. Could someone please help?
>
>
>
> Thanks!
>
> Kaur
>
>
>
> _______________________________________________________________________________
>
> UNSUBSCRIBE or access ARSlist Archives at <http://www.arslist.org>
> 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
