Hi,
I am trying to design a BAQ(I want to later use it as a dashboard) and I am having trouble on getting the last ClockIn Time from a ResourceID on a specific day.
I tried using subqueries and sorting descending on ResourceID, PayrollDate, ClockInTime and used a select top clause=1.
In this case it only returns last clock in time, not per resourceID.
Any suggestions?
Thanks,
John
If just getting direct labor ResourceGroup (Left Outer, First) to LaborDtl then (LeftOuter) to LaborHed
Labor Head will have Payroll Date, Labor Dtl the Time.
Patrick Winter
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, September 02, 2016 01:41
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ - get last ClockIn per ResourceID on same Payroll Date
Hi,
I am trying to design a BAQ(I want to later use it as a dashboard) and I am having trouble on getting the last ClockIn Time from a ResourceID on a specific day.
I tried using subqueries and sorting descending on ResourceID, PayrollDate, ClockInTime and used a select top clause=1.
In this case it only returns last clock in time, not per resourceID.
Any suggestions?
Thanks,
John
This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.
I’m in 9, BAQs we can select find the FIRST, LAST or EACH record. Find first just grabs from the end or beginning of the primary or whatever index is selected by the joins.
Patrick Winter
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, September 02, 2016 02:03
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ - get last ClockIn per ResourceID on same Payroll Date
What do you mean by first? I am using Epicor 10....
This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.
---In vantage@yahoogroups.com, <don.n.doan@...> wrote :