Does anyone else have any experience with the "First/Last" criteria in E10?
Thanks for the help.
B-
Hello,
We are running 10.1 and are trying to create a BAQ that has 7 tables in it and one of the tables had the 'first' criteria set on it. We can't figure out how to get this to work in 10.1? When we try using the subquery options, it looks like it is applying it to the whole BAQ and not to the specific one table. Anyone have an idea how to do this?
Thanks
On Wed, Aug 10, 2016 at 2:10 PM, detroitrdwings91@... [vantage] <vantage@yahoogroups.com> wrote:Â<div> <p></p><p><span>Hello,</span></p><p><span><br></span></p><p>We are running 10.1 and are trying to create a BAQ that has 7 tables in it and one of the tables had the 'first' criteria set on it. We can't figure out how to get this to work in 10.1? When we try using the subquery options, it looks like it is applying it to the whole BAQ and not to the specific one table. Anyone have an idea how to do this?</p><p><br></p><p>Thanks</p><p><br></p><p></p> </div> <div style="color:#fff;min-height:0;"></div>
On Wed, Aug 10, 2016 at 3:16 PM, detroitrdwings91@... [vantage] <vantage@yahoogroups.com> wrote:Â<div> <p>Jose,</p><div><br></div><div>I tried that but my BAQ will only return one row of data. If I remove the subquery, then it shows all of the records. How does it know which table to find the FIRST or LAST record on? </div><div><br></div><div>thanks</div><p></p> </div><span class="ygrps-yiv-668397781"> <div style="color:#fff;min-height:0;"></div>