JOB: 9-month contract i Sweden
Hi, If anyone would be intrested in working in Stockholm for 9 months, please let me know. This customer work only with homegrown applications. The job will include both analasys, design, documentation and development in a small team of ARS-developers. The main work will be of adding smaller enhancements to an existing application. The consultant should preferrably have been certified as a RAC or RSP. You must be fluent in either Swedish or English. The contract start date is as soon as possible. Best Regards - Misi, RRR AB, http://www.rrr.se ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Oracle 9-10
Hi, suppose uppgrading from 6.3 to 7.01, advantages to upgrade Oracle to ver 10, or ok to keep 9i? (9.2.0 2.0)? TIA, L ars L ars Pettersson Vattenfall Business Services Nordic AB Action Request System Engineer (Tabasco) S-461 88 Trollhättan Sweden Phone +46 520 888 35 Mobil +46 70 608 99 95 e-mail: [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Diary Field last entry
Hi List, I need to know the last entry in a Diary field and was taking a look at old exchanged messages. I´ve found a solution below but couldn´t do the Set Field: Most Recent Action 'TR.Work Diary' I also tried '$TR.Work diary$', but it doesn´t work. Any other idea to save just the last entry (diary field)in a character field? (I don´t need odbc drivers or crystal as Carina does) Thanks in advance! Sueli On Tue, 15 Jun 2004 14:26:16 -0400, Tilton, Claire E. Ms. NGB-ARNG [EMAIL PROTECTED] wrote: Make a field called Most Recent Action (Field Size = 0 or whatever you feel is appropriate to catch the last diary entry). Create a filter that fires on 'TR.Work Diary' != $NULL$. Do a set fields Most Recent Action := 'TR.Work Diary'. Then you can report on that field instead of the work diary. Thanks, Claire -Original Message- From: Carina Burns [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 15, 2004 1:32 PM To: ARSLIST@ARSLIST.ORG Subject: Diary Field Question Listers, With the user preference form, you can set the diary field to display the most recent entry first. While this works through the forms (whether web or client,) it doesn't work when using the odbc drivers and crystal reports -despite using an id with the diary preference set. The first entry is displayed rather than the last entry. Has anyone out there found a way to retrieve only the last entry or to specify the display order of the diary entries within a crystal report? Much Appreciated, Carina Burns Database Admin Richardson ISD [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Diary Field last entry
Try to perform a set fields, CURRENT TRANSACTION, set a tmp field to $Diary$, works for me .../L ars -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Sueli Kanegae Sent: Monday, September 04, 2006 9:57 PM To: arslist@ARSLIST.ORG Subject: Re: Diary Field last entry Hi List, I need to know the last entry in a Diary field and was taking a look at old exchanged messages. I´ve found a solution below but couldn´t do the Set Field: Most Recent Action 'TR.Work Diary' I also tried '$TR.Work diary$', but it doesn´t work. Any other idea to save just the last entry (diary field)in a character field? (I don´t need odbc drivers or crystal as Carina does) Thanks in advance! Sueli On Tue, 15 Jun 2004 14:26:16 -0400, Tilton, Claire E. Ms. NGB-ARNG [EMAIL PROTECTED] wrote: Make a field called Most Recent Action (Field Size = 0 or whatever you feel is appropriate to catch the last diary entry). Create a filter that fires on 'TR.Work Diary' != $NULL$. Do a set fields Most Recent Action := 'TR.Work Diary'. Then you can report on that field instead of the work diary. Thanks, Claire -Original Message- From: Carina Burns [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 15, 2004 1:32 PM To: ARSLIST@ARSLIST.ORG Subject: Diary Field Question Listers, With the user preference form, you can set the diary field to display the most recent entry first. While this works through the forms (whether web or client,) it doesn't work when using the odbc drivers and crystal reports -despite using an id with the diary preference set. The first entry is displayed rather than the last entry. Has anyone out there found a way to retrieve only the last entry or to specify the display order of the diary entries within a crystal report? Much Appreciated, Carina Burns Database Admin Richardson ISD [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Oracle 9-10
Ok to keep 9, Remedy does not use any features of 9i or 10g, so it is really a decision on what is easier to manage for your dba. You do have to upgrade the oracle client on the arserver host to 10g though. Axton Grams [EMAIL PROTECTED] wrote: Hi, suppose uppgrading from 6.3 to 7.01, advantages to upgrade Oracle to ver 10, or ok to keep 9i? (9.2.0 2.0)? TIA, L ars L ars Pettersson Vattenfall Business Services Nordic AB Action Request System Engineer (Tabasco) S-461 88 Trollhättan Sweden Phone +46 520 888 35 Mobil +46 70 608 99 95 e-mail: [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Diary Field last entry
TR will give you the current diary entry (which is null if no changes to the diary field). If you want the last entry, you have to store it somewhere else (character field as you mentioned) or parse the diary field (which is tricky). I would make the char field 4k characters so it does not add a clob to the table (text for sql, not sure the cutoff in chars), then use the LEFTC function to only grab the first 4k chars of the diary entry. Axton Grams Sueli Kanegae wrote: Hi List, I need to know the last entry in a Diary field and was taking a look at old exchanged messages. I´ve found a solution below but couldn´t do the Set Field: Most Recent Action 'TR.Work Diary' I also tried '$TR.Work diary$', but it doesn´t work. Any other idea to save just the last entry (diary field)in a character field? (I don´t need odbc drivers or crystal as Carina does) Thanks in advance! Sueli On Tue, 15 Jun 2004 14:26:16 -0400, Tilton, Claire E. Ms. NGB-ARNG [EMAIL PROTECTED] wrote: Make a field called Most Recent Action (Field Size = 0 or whatever you feel is appropriate to catch the last diary entry). Create a filter that fires on 'TR.Work Diary' != $NULL$. Do a set fields Most Recent Action := 'TR.Work Diary'. Then you can report on that field instead of the work diary. Thanks, Claire -Original Message- From: Carina Burns [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 15, 2004 1:32 PM To: ARSLIST@ARSLIST.ORG Subject: Diary Field Question Listers, With the user preference form, you can set the diary field to display the most recent entry first. While this works through the forms (whether web or client,) it doesn't work when using the odbc drivers and crystal reports -despite using an id with the diary preference set. The first entry is displayed rather than the last entry. Has anyone out there found a way to retrieve only the last entry or to specify the display order of the diary entries within a crystal report? Much Appreciated, Carina Burns Database Admin Richardson ISD [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARSLIST AWARDS - For Dan
** That would make some sense - late October puts it in the 30-day period between the end of 100+ degree temperatures and the beginning of theice storms. Christopher Strauss, Ph.D.Remedy Database AdministratorUniversity of North Texas Computing Centerhttp://remedy.unt.edu/helpdesk/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Warren BaltimoreSent: Saturday, September 02, 2006 8:45 PMTo: arslist@ARSLIST.ORGSubject: Re: ARSLIST AWARDS - For Dan ** There is quite a bit of rumors about next year. I'm thinking Texas. __20060125___This posting was submitted with HTML in it___
Re: ARSLIST AWARDS - For Dan
** No plans for something like Sorrento? It's a very long/boring flight from Sweden to W US. Any statistics how many arssites outside US compared with US-sites? L ars -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of straussSent: Monday, September 04, 2006 10:32 PMTo: arslist@ARSLIST.ORGSubject: Re: ARSLIST AWARDS - For Dan ** That would make some sense - late October puts it in the 30-day period between the end of 100+ degree temperatures and the beginning of theice storms. Christopher Strauss, Ph.D.Remedy Database AdministratorUniversity of North Texas Computing Centerhttp://remedy.unt.edu/helpdesk/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Warren BaltimoreSent: Saturday, September 02, 2006 8:45 PMTo: arslist@ARSLIST.ORGSubject: Re: ARSLIST AWARDS - For Dan ** There is quite a bit of rumors about next year. I'm thinking Texas.__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Diary Field last entry
Good ..There is always a solution to everything, sometimes hidden behind deep clouds, sometimes just around the corner ...but never say, not impossible ...// L ars -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Sueli Kanegae Sent: Monday, September 04, 2006 10:43 PM To: arslist@ARSLIST.ORG Subject: Re: Diary Field last entry It worked, thank you! On Mon, 4 Sep 2006 22:07:13 +0200, [EMAIL PROTECTED] wrote: Try to perform a set fields, CURRENT TRANSACTION, set a tmp field to $Diary$, works for me .../L ars -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Sueli Kanegae Sent: Monday, September 04, 2006 9:57 PM To: arslist@ARSLIST.ORG Subject: Re: Diary Field last entry Hi List, I need to know the last entry in a Diary field and was taking a look at old exchanged messages. I´ve found a solution below but couldn´t do the Set Field: Most Recent Action 'TR.Work Diary' I also tried '$TR.Work diary$', but it doesn´t work. Any other idea to save just the last entry (diary field)in a character field? (I don´t need odbc drivers or crystal as Carina does) Thanks in advance! Sueli On Tue, 15 Jun 2004 14:26:16 -0400, Tilton, Claire E. Ms. NGB-ARNG [EMAIL PROTECTED] wrote: Make a field called Most Recent Action (Field Size = 0 or whatever you feel is appropriate to catch the last diary entry). Create a filter that fires on 'TR.Work Diary' != $NULL$. Do a set fields Most Recent Action := 'TR.Work Diary'. Then you can report on that field instead of the work diary. Thanks, Claire -Original Message- From: Carina Burns [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 15, 2004 1:32 PM To: ARSLIST@ARSLIST.ORG Subject: Diary Field Question Listers, With the user preference form, you can set the diary field to display the most recent entry first. While this works through the forms (whether web or client,) it doesn't work when using the odbc drivers and crystal reports -despite using an id with the diary preference set. The first entry is displayed rather than the last entry. Has anyone out there found a way to retrieve only the last entry or to specify the display order of the diary entries within a crystal report? Much Appreciated, Carina Burns Database Admin Richardson ISD [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Adding field to a report
hi When I print a Help Desk case, I can see several fields, how can I add other fields? I mean I wanna add fields like for example Related Items Task for that case for instance (the usual field Case ID, Requester's Name, ...) and add these ones. Related item (Asset ID): Monitor001 Task: TSK0026 thanks alot bye ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Job:Remedy Developer in Sydney Australia
** Hi, My company is expanding fast and has committed to enhancing our custom Remedy application to help drive our growth. We are developing an exciting new Remedy V7 application with several leading edge integrations that will include document management, CRM, business process management and accounting. We have an urgent need for people with one or more of the following skills. The position is a full time contract at the moment and we are based in the heart of the Sydney, just a short walk to buses, ferries and trains. There will be a need for some onsite consultation but we may be flexible on location. Remedy Action Request System development Remedy Mid-tier/cascading style sheets CRM development Accounting system development Outlook integration Fax integration (Hylafax) Web Services/XML/Java SQL Server 2000 VOIP/Telephony integration Crystal Reports Windows Server 2003/Exchange 2003/Linux Please send CVs and questions offlist to me at [EMAIL PROTECTED] Regards, Rod Harris IT Manager CMS Asset Solutions __20060125___This posting was submitted with HTML in it___
Re: ARSLIST AWARDS - For Dan
maybe dallas... If it is houston... party at my house From: Action Request System discussion list(ARSList) on behalf of Rick cook Sent: Sat 9/2/2006 9:06 PM To: arslist@ARSLIST.ORG Subject: Re: ARSLIST AWARDS - For Dan ** About the only clues they gave was Fairly easy to get to and the date (late Oct). Hmmm...that tells me that it is not a major city, and that holding it there in the fall is done for a reason - like to escape major heat? You could be right, Warren. Houston, Vegas, Orlando, (in that order) some southern city like that. No others make sense. Maybe D.C.? Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Warren Baltimore Sent: Saturday, September 02, 2006 6:45 PM To: arslist@ARSLIST.ORG Subject: Re: ARSLIST AWARDS - For Dan ** There is quite a bit of rumors about next year. I'm thinking Texas. On 9/1/06, Rick cook [EMAIL PROTECTED] wrote: ** A double Amen from me! Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Julie Rockwood Sent: Friday, September 01, 2006 12:21 PM To: arslist@ARSLIST.ORG Subject: Re: ARSLIST AWARDS - For Dan ** I'll second that! He even keeps us in line to keep the list from becoming free-for-all - a thankless job. THANKS DAN!! At 01:07 PM 9/1/2006, you wrote: ** Let us not forget to thank Dan for the endless hours and time he dedicates all year long to keeping the ARSLIST up and running And for all his efforts year after year for pulling together the stat, the gifts and the entertainment to make the ARSList Awards a hit!! Thank You Dan for all your hard work year after year!! Herb Partlow President/CEO IB Technical Consulting, Inc. (O) 408-253-0344 (F) 408-253-0344 (C) 408-309-5316 [EMAIL PROTECTED] http://www.ibtechnicalconsulting.com http://www.ibtechnicalconsulting.com/ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org