Positioning when opening a list

Atreiu

Hello everybody,
can you suggest me a way to automatic choose (by code) a position in a list when I open it?

For example when opening customer invoice list it always put in the middle of the list... and I need a lot of scrolling to reach the last invoice.
Does anyone know how to automatic say that when I open this page the system automatically will go to the end of the list and/or in a specific position (for example the ones beginning by '11-')?

thanks in advance

mohana_cse06

You can reach last record by pressing Ctrl+End

fitol

Atreiu wrote:

can you suggest me a way to automatic choose (by code) a position in a list when I open it?

Try this code in OnOpenPage in the list page:

SETFILTER("No.", '%1..', '11-');
IF FINDFIRST THEN ;
SETRANGE("No.");

Atreiu

thanks for this tip.

But I want this to be automatic when opening the page.

fitol

Atreiu wrote:

But I want this to be automatic when opening the page.

What?
You asked how to do it by code.
And when putting the code in the page it will be done automatically.
](*,)

Atreiu

fitol wrote:

Atreiu wrote:

can you suggest me a way to automatic choose (by code) a position in a list when I open it?

Try this code in OnOpenPage in the list page:

SETFILTER("No.", '%1..', '11-');
IF FINDFIRST THEN ;
SETRANGE("No.");

thank you!
i'll try it now

Atreiu

I tried to use your solution to achieve this: go to the last record.
So i write only:

IF FINDLAST THEN
SETRANGE("No.");

and it works!

my (stupid) question is: does not SETRANGE work as an actual filter on the page? It does not exclude records and show some... Why?


however... thank you!

Savatage

on the form there is also a property "SourceTablePlacement"

A specific record -->Record
The first record in the table --> First
The last record in the table --> Last
The record being shown the last time the user displayed the form --> Saved (default)

no coding needed