[Resolved] Views using repeating fields can't be sorted correctly on front end

[Author]

Posts

[PaulS4783]

Using Types 3.4.16
Using Views 3.6.3

I am using Beaver Builder (NOT repeat NOT the Block Editor)

I am trying to sort a set of repeating fields in the same order in which they are displayed on the dashboard using Views.
However the sort order on the front end appears to be somewhat random.

Here is the Views configuration:
hidden link

Here is the Custom Post Dashboard:
hidden link

But here is the output:
hidden link

Your help would be greatly appreciated.

[Nigel]

Hi there

I just tested this on my local site where it works as expected, I'm not sure why it wouldn't be working in your case.

Can you go to Toolset > Settings > Front-end Content and enable the advanced debug mode.

Then visit the post where the View is displayed and check the debug pop-up.

In the screenshot from my site you can see that the query arguments specify that the ordering should be by the custom field toolset-post-sortorder, and the generated MySQL query does indeed order by that custom field.

Can you share the same from your site?

[PaulS4783]

I think it's the same as yours.

Can I give you Admin dashboard access to this site to take a look at it?

I've tried deactivating plugins but doesnt make any difference.

[Nigel]

That does look right, perhaps there is something wrong in how the toolset-post-sortorder field is stored.

Let me mark your next reply as private so that we can get log-in credentials from you—you may want to create a temporary admin user for us to use that you can later delete. And be sure to have a current backup of your site.

Can you also confirm which View we are looking at and where it is displayed?

[Waqar]

Hi,

Thank you for sharing the admin access details.

I tried to log in using the admin login page, but it keeps blocking me with the message:
'403 Forbidden - BBQ Firewall'

Can you please temporarily disable this 'BBQ Firewall' until this investigation concludes?

regards,
Waqar

[PaulS4783]

OK. Sorry about that. Try it again now.

[PaulS4783]

It seems like the firewall rejected because the attempted login url was malformed.

You can login at the standard /wp-login.php site address.

[Waqar]

The admin access details worked, thank you.

I'm currently performing some tests on my website with a similar setup and will share the findings, as soon as this testing completes.

Thank you for your patience.

[Waqar]

Thank you for waiting.

I was able to make the repeating field entries show in the order that you wanted by making the following changes, in the ordering section:

1. The 'toolset-post-sortorder' field stores the numerical values. So the comparison type needs to be 'As a number' instead of 'As a native custom field'.

2. The numbers in this field are stored in the ascending order. For showing the repeating field group entries in the same order as on the post-edit screen, the ordering direction needs to be 'Ascending'.
( screenshot: hidden link )

After making these changes, I cleared the 'SG cache', and repeating field items are showing in the correct order now.
( screenshot: hidden link )

[PaulS4783]

My issue is resolved now. Thank you!

Grateful to ToolSet support team for helping resolve this one.