Resorting a portal

Classic Servoy
1

Hi,

If I make a change to records in a portal that the sort is based off of, how do I make that portal update to reflect the new sort order? Right now I need to go into layout mode and then reenter browse mode.

2

You can, make onRecordChange method, that does the sorting again, when you change te record.

3

right… but method function do I run to execute the sorting and have the screen refresh?

4

look at your relation:

out of my head:

relation_to_relation.sort(‘companyname asc’)

for example.

5

I run that, but it doesn’t seem to update anything unless I go into layout mode and back to designer mode.

6

Can you give me the complete sort-code?

there must be some typo.

7

The sort field is called sortnumber. The relationship that the portal is based off is called itemtypes_to_itemtypeattributes_col1

here is the code:

itemtypes_to_itemtypeattributes_col1.sort(‘itemtypes_to_itemtypeattributes_col1.sortnumber asc’);

8

try this:

itemtypes_to_itemtypeattributes_col1.sort('sortnumber asc');
9

works!

Thanks!