Which version of BO are you on? On XIR2, you can explore the query builder. Also, there are some very useful utilities available in BOB’s downloads. You could use that as a base of get the data you want.
https://bobj-board.org/t/89434
nithya_raj (BOB member since 2007-02-03)