Can't order a page by one of the fields

fini

I have a page, it works fine but I can't order it by one of the fields. I can arrange the list by the other fields only the "Customer Name" field not working. What should I do to solve this?
I click on the title but nothing happens...


Thanks.

ShaiHulud

You cannot sort and/or filter by calculated fields. If you want to filter/sort, you're going to need to create a FlowField on the Customer Ledger Entry table and use that on the page. Then you'll be able to sort/filter.

fini

In the dataset a function creates the value (getcustname)
LOCAL getcustname() : Text[50]
IF cust.GET("Customer No.") THEN EXIT (cust.Name)
ELSE EXIT('');

So maybe this cause it, but how to resolve this?

ShaiHulud

You cannot sort and/or filter by calculated fields. If you want to filter/sort, you're going to need to create a FlowField on the Customer Ledger Entry table and use that on the page. Then you'll be able to sort/filter.