To create this BAQ (in 9.05):
- Add tables LaborHed and LaborDtl and change the table
relation between them to an outer join.
- Add other table criteria, probably LaborHed.ActiveTrans =
true.
- Change the LaborDtl table to a summary table only.
- Add a display calculated column with a formula of Count(
LaborDtl.EmployeeNum ).
- This query shows who's clocked in, and how many
jobs/activities they are clocked into.
- Add a display "filter results" of that calculated column = 0.
- Now this shows only people with zero active jobs.
Brian.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mike.numbers
Sent: Wednesday, February 29, 2012 10:35 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ showing Parent Records without Child Records
I am trying to create a BAQ using LaborHed and LaborDtl that shows who
has clocked in but has not identified a job or Indirect. Looking at the
data, I have a LaborHed record but no corresponding LaborDtl record. How
can I write a BAQ that will show me all LaborHed records that do not
have a LaborDtl record?
[Non-text portions of this message have been removed]
- Add tables LaborHed and LaborDtl and change the table
relation between them to an outer join.
- Add other table criteria, probably LaborHed.ActiveTrans =
true.
- Change the LaborDtl table to a summary table only.
- Add a display calculated column with a formula of Count(
LaborDtl.EmployeeNum ).
- This query shows who's clocked in, and how many
jobs/activities they are clocked into.
- Add a display "filter results" of that calculated column = 0.
- Now this shows only people with zero active jobs.
Brian.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mike.numbers
Sent: Wednesday, February 29, 2012 10:35 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ showing Parent Records without Child Records
I am trying to create a BAQ using LaborHed and LaborDtl that shows who
has clocked in but has not identified a job or Indirect. Looking at the
data, I have a LaborHed record but no corresponding LaborDtl record. How
can I write a BAQ that will show me all LaborHed records that do not
have a LaborDtl record?
[Non-text portions of this message have been removed]