Table sorting by number field

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Kolkata (GMT+05:30)

This topic contains 2 replies, has 2 voices.

Last updated by David 1 year, 8 months ago.

Assisted by: Minesh.

Author

Posts

March 14, 2023 at 3:27 pm #2572789

David

Hi there,

I have set up a table using the [wpv-heading] shortcode to enable sort ordering, i.e.
[wpv-heading name="uwcref"]UWCRef[/wpv-heading]

My field uwcref is a number field and I expected the ordering to be as a linear number. It works for the most part, but I have tens, hundreds, thousands and so the ordering is not quite numerical.

It is like: 1, 10, 100, 1000, 1001, 1002, 1003 etc,

But it should be 1, 2, 3, 4 . .... 10, 11, 12.... 100, 102 etc.

See:

hidden link

Can this be fixed somehow?

March 15, 2023 at 6:29 am #2573171

Minesh

Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hello. Thank you for contacting the Toolset support.

What if you add the heading with sortable column as given under:

[wpv-heading name="types-field-uwcref"]UWCRef[/wpv-heading]

Then save your view and check if you able to sort the column correctly.

Does that helps?

March 15, 2023 at 11:26 am #2573407

David

My issue is resolved now. Thank you!