Changing the order in which standard baan displays the records.

At times in baan we get struck up in showing records in a display session or maintain in a special way of sorting.(Simplest case is to display records in descending order).

The answer to this is out here.

Every maintain or display session has four sets of queries to fetch the records from the database.

1) Query the first set.

2) Query the next set.

3) Query the previous set.

4) Query the last set.

These queries can be seen by pressing the key combination <Ctrl> <Shift> <8>.

Now how to modify it to make use of it.

All the above set of four queries have fixed sql ids linked to them (Like in case of dynamic Sql), we just need to assign   the new query to them.

The fixed Sql ids are:-

1) g.sql.first.id  for the first set.

2) g.sql.next.id  for the next set.

3) g.sql.prev.id  for the prev set.

4) g.sql.last.id  for the last set.

:) Just Modify these and enjoy!!!!!!!