I was able to display data from a table using a where condition which displays 40 records out of a total of 69. But when I paginate (click next or click the page number, the where condition seems to be lost and reverts to displaying all records. It only shows correct number of records on first page of a multi-page result set.
Where condition used t_season_yr = '2012' AND t_div = 'B'
Same thing also happens for other set properties such as colors in headers and rows. Loses color properties on change in page.