Can't order a page by one of the fields

fini · 2019-11-08

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 · 2019-11-08

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 · 2019-11-08

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 · 2019-11-08

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.

Can't order a page by one of the fields

Best Answer

Answers

Categories