Unfortunately the request id can be our of sequence in a server group situation On Jan 7, 2015 5:06 PM, "Carl Wilson" <carlbwil...@gmail.com> wrote:
> ** > > Hi, > > You could also use the request ID as it will be sequenced, there are > existing joins available for Incident / Work Info that can be utilised. > > > ------------------------------ > > > > Kind Regards, > > > > *Carl Wilson* > > > > http://www.missingpiecessoftware.com/ > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *LJ LongWing > *Sent:* 07 January 2015 21:38 > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Determining first workinfo entry > > > > ** > > do a MIN on the create_date for the work log entry...this'll ensure you > only get the first entry. > > > > On Wed, Jan 7, 2015 at 2:33 PM, Scott Hallenger <vadr...@yahoo.com> wrote: > > Hi I am creating a report via sql, that would show several incident fields > and 2 fields fromn the HPD:Worklog forms. Naturally this would be a join, > but I am trying to figure out which is the best way to single out the > first/earliest workin info entry and exclude the rest. As you know the > worklog can have more than one entry related to the single incident. Any > Ideas would be helpful. > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "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"