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"