See if the BAQ engine supports the MAXIMUM keyword. You can then set up criteria to only include Rev's with Effective Dates less than or equal to today and have a calculated field MAXIMUM(EffectiveDate).
I'm not sure if, by itself that would return only one Rev per part (or job) with the latest effective date. If it does, you're golden, if it doesn't - you can likely do further processing in your dashboard or report to only display the Rev that has an effective date equal to the Max effective date in your calc column.
Or you could just return all revs sorted descending by effective date and simply 'know' that the 1st one displayed is the most current.
I'm not sure if, by itself that would return only one Rev per part (or job) with the latest effective date. If it does, you're golden, if it doesn't - you can likely do further processing in your dashboard or report to only display the Rev that has an effective date equal to the Max effective date in your calc column.
Or you could just return all revs sorted descending by effective date and simply 'know' that the 1st one displayed is the most current.
--- On Tue, 9/2/08, empedole <empedole@...> wrote:
From: empedole <empedole@...>
Subject: [Vantage] Re: BAQ-Joins between tables
To: vantage@yahoogroups.com
Date: Tuesday, September 2, 2008, 12:57 PM
I have a custom report where we get latest information of revisions
assigned to Engineering groups. We also needed to retrieve Job Number
on to that report. We can select it manually by adding a new filter on
report screen called "Job". All we needed to do was to display Job
Number on the report. We figured it out.
But I have another issue. I want to pull latest revision regardless
what we choose on report interface. Is this something that I need to
do on the report or it is BAQ issue? How come I will be able to
accomplish?
Thank you
--- In vantage@yahoogroups .com, Robert Brown <robertb_versa@ ...> wrote:
>
> What are you trying to do? Those two tables don't really have any
'natural' relationship - so your intent determines how you might join
them.
>
> --- On Tue, 9/2/08, empedole <empedole@.. .> wrote:
>
> From: empedole <empedole@.. .>
> Subject: [Vantage] BAQ-Joins between tables
> To: vantage@yahoogroups .com
> Date: Tuesday, September 2, 2008, 11:13 AM
>
>
>
>
>
>
> What is the proper way to get JobHead, ECORev joined? I have a BAQ and
> i need to pull Job Number and make it displayed on the report.
>
> TIA
>