The old Biotics4 Query Builder allowed you to preview N-number of results before running the query. Currently, Biotics5 doesn't have this functionality, but you can add the following syntax into your "Where" clause to get the same results. If you choose the query output as HTML, it is essentially a preview.


"....Your query here

WHERE your query criteria here AND

 rownum <= Rows_to_return ". 


For example, the query below would show you the first ten records where your EO_ID is > 1000:


select * from eo 

where eo_id > 1000 and

rownum <= 10


If you didn't want the criteria for eo_id > 1000 you could just say:


select * from eo 

where rownum <= 10


and it would show you the first 10 records of the EO table.