Repeating Group Sorting Logic Only works in Debug Mode

Need help
1

Howdy everyone,

It may very well be possible that I’ve been staring at the screen for so long I’m missing something obvious. But on the other hand… I’m tired of banging my head against the wall.

Quick Summary of Issue:
Sorting by Dynamic Field Name only works in debug mode

So I have a Repeating Group with filters setup as follows:
image

My Sorting Logic lives inside the filter:
image

Or, it can live outside the filter:

image
image703×307 16.9 KB

(There may be a difference but that’s beyond my knowledge). Just to be sure, I tried both…

The Dropdown is configured as follows:
image

Those fields are the exact names of the DB values. No trailing spaces, no extra line breaks.

There are two scenerios here:

  1. Debug mode ON
  2. Debug mode OFF

In both cases, the RG populates on page load since the Dropdown default value is null.

Debug ON: (identical url + “?debug_mode=true”)
Toggling between Price and Dealer rating changes the order of the items in the RG as expected.

Debug OFF:
Toggling between Price and Dealer clears the results the the RG is empty.

What I’ve tried to fix this:

  • Selecting non-dynamic field values for both Price and Dealer Rating. Both worked under both scenarios.
  • Deleted the dropdown and created a new one.
  • Enabled Step-by-Step Debugger, but it doesn’t seem to work with filtering logic
  • Set the Dynamic field name sorting order to Descending yes/no
  • Setting the Dropdown default value to price (In Debug OFF this resulted in my spinner going endlessly, Debug ON resulted in RG loading successfully)
  • Closed all browser tabs and restarted browser

If anyone has any insight on this issue or… maybe I’m missing something glaring, I’d really appreciate some help.

Thanks!

2

It seems as if having null DB values is the root cause here.

It seems as if numeric fields must have a value or else the sorting does not work.

3

This topic was automatically closed after 70 days. New replies are no longer allowed.