Hi, There are several ways to achieve this. Some of them at Remedy native but complicated, and others are a bit outside ARS.
For instance: inside Remedy: Create a new option field with one possible value that means last. Create a filter at workout on submit with two actions: a Push that sets the created flag to null for all work logs of the same incident having it to "last". The second action is a set flag to "last". With this workflow you ensure that only the last. Omen has this flag activated. The you can add the condition flag="last" to the join condition. A bit outside Remedy: Create an SQL view that only show the last value. This can be met with subqueries. Then you can create a view form that maps this SQL view. Regards, Jose Huerta theremedyforit.com El 09/08/2012, a las 17:26, "Longwing, LJ CTR MDA/IC" <lj.longwing....@mda.mil> escribió: > Actually...I was talking about SQL 'joining'....I haven't used the new report > designer console either...I'm not sure if what I described is possible within > remedy. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Ray Palla > Sent: Thursday, August 09, 2012 8:57 AM > To: arslist@ARSLIST.ORG > Subject: Re: ITSM 7.6.04 Join form Query > > LJ; > > Sounds interesting and would work, but we don't have the newly supported BIRT > report writer fully in place just yet as described in the recent white paper. > We will be doing that, but need this report before it can be implemented. > I'm assuming you are speaking from the Report Designer console? > > R > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC > Sent: Thursday, August 09, 2012 9:46 AM > To: arslist@ARSLIST.ORG > Subject: Re: ITSM 7.6.04 Join form Query > > Ray, > Instead of doing a join on the work log, make the column for the work log > entry a separate query in the select portion, and to a select 'top 1' on the > sub-query, with the proper order statements. This will give you a single > work order entry in your column list, null if there aren't any at all. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Ray Palla > Sent: Thursday, August 09, 2012 8:32 AM > To: arslist@ARSLIST.ORG > Subject: ITSM 7.6.04 Join form Query > > ** > Listers Brain Test; > > We have an outer join form.... Primary = HPD:Help Desk and Secondary = > HPD:WorkLog. It works fine and produces a list of open tickets with each > Work Log entry for that ticket. The customer only wants to see the most > recent Work Log entry and not any older ones. I have the join form sorted to > put the most recent at the top, but haven't found a query that eliminates the > other records... It may not be possible? > > Does anyone know a way to get just the first entry? > > R > > Ray Palla > Sr. IT/Remedy Consultant > <http://www.linkedin.com/img/signature/bg_bluefade_195x42.jpg> > Mobile: 512-917-1739 > Time Zone: Central Email: ray.pa...@insona.com > <http://www.linkedin.com/img/signature/icon_in_blue_14x14.gif> > Professional Profile <http://www.linkedin.com/pub/1/544/598> > INSONA Corporation > <http://www.insona.com/> 1201 Berry Lane > <http://maps.google.com/maps?q=10650+SW+Plaza+CT%2CBox%3A+J68%2CHouston%2CTX > +77074%2CUSA&hl=en> Georgetown, TX > 78626-3832 USA > Infrastructure Solutions - Network Applications > > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > > ____________________________________________________________________________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
