If you find that setting, please let me know where it is :) William Rentfrow [email protected] Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Carl Wilson Sent: Wednesday, January 07, 2015 6:41 PM To: [email protected] Subject: Re: Determining first workinfo entry ** Then I would adjust the SG so this does not happen ☺ ________________________________ Kind Regards, Carl Wilson From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: 08 January 2015 00:21 To: [email protected]<mailto:[email protected]> 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" <[email protected]<mailto:[email protected]>> 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:[email protected]<mailto:[email protected]>] On Behalf Of LJ LongWing Sent: 07 January 2015 21:38 To: [email protected]<mailto:[email protected]> 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 <[email protected]<mailto:[email protected]>> 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<http://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<http://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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
