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:ben.cher...@gmail.com> ben.cher...@gmail.com > 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:arslist@ARSLIST.ORG] On Behalf Of Su Kaur > Sent: June-13-16 12:24 AM > To: arslist@ARSLIST.ORG > 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"