Ha ha! I have also seen situations where the request IDs have been out of sequence when merging systems or combining records from multiple forms into one. Not often but it happens.
Jason On Wed, Jan 7, 2015 at 8:12 PM, William Rentfrow <wrentf...@stratacominc.com > wrote: > ** > > If you find that setting, please let me know where it is :) > > > > William Rentfrow > > wrentf...@stratacominc.com > > Office: 715-204-3061 or 701-232-5697x25 > > Cell: 715-498-5056 > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Carl Wilson > *Sent:* Wednesday, January 07, 2015 6:41 PM > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Determining first workinfo entry > > > > ** > > Then I would adjust the SG so this does not happen J > > > ------------------------------ > > > > Kind Regards, > > > > *Carl Wilson* > > > > > > *From:* Action Request System discussion list(ARSList) [ > mailto:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *LJ > LongWing > *Sent:* 08 January 2015 00:21 > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Determining first workinfo entry > > > > ** > > 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_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > ------------------------------ > > No virus found in this message. > Checked by AVG - www.avg.com > Version: 2014.0.4794 / Virus Database: 4253/8799 - Release Date: 12/24/14 > Internal Virus Database is out of date. > > _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"
