patrickw777
Programmer
Dear Gurus,
I'm trying to filter out rows from a table using a max(seq_num) grouped by an ID. Is there a way to do this in BusinessObjects (Universe and or report) without building an aggregate table in the database?
Here's the query I need to emulate with BO:
--------------------------
select ah.case_id, ah.eventname, ah.seq_num from action_hist ah,
(select max(seq_num) as max_seq, case_id from action_hist group by case_id) maxresults
where ah.case_id = maxresults.case_id
AND
ah.seq_num = max_seq order by ah.case_id;
---------------------------------------
Thanks,
Patrick
I'm trying to filter out rows from a table using a max(seq_num) grouped by an ID. Is there a way to do this in BusinessObjects (Universe and or report) without building an aggregate table in the database?
Here's the query I need to emulate with BO:
--------------------------
select ah.case_id, ah.eventname, ah.seq_num from action_hist ah,
(select max(seq_num) as max_seq, case_id from action_hist group by case_id) maxresults
where ah.case_id = maxresults.case_id
AND
ah.seq_num = max_seq order by ah.case_id;
---------------------------------------
Thanks,
Patrick