Sorting variable field by ascending order in list page.

Business Central/NAV Developers Forum
1

Hello,

i want to sort a variable field in ascending order in a list page.

2

Hello Seema,

As per my experience , We cannot sort a logical data field in list page. If you want to sort it then firstly you have to add it in table permanently then only you can sort it.

Thanks & Best Regards,

3

I assume that you don’t mean that you want to sort the page on a variable that you created, but on a variable key in the table?

Have you tried to use SETCURRENTKEY and ASCENDING(TRUE)?
Which version is it? In some of the early page versions it was not possible

4

Thank You, But its not a variable key in the table.

5

You can only do that with a “real key”, just as Tanu wrote. So if you solved your issue by adding a key, then please click “This Helped Me” below his post. [:)] If not, please elaborate.