[BUG] Unable to Select Value and Label fields for String Dropdown-Query Input Type

[jeremy-farrance]

Bug Affects...

[x] edit experience / UI
[x] admin experience UI

Current Behavior / Expected Behavior

We have a Content Type named Dropdowns with a field named DropType to specify the options for the (select) filters (in the View) as well as getting used in the Edit UI via dropdown-query input type to provide the correct options. Example types are for number of bathrooms, type of building, etc.

Everything works fine in the Edit UI, here you see the Building Type showing just the 4 (of 60+) options from Dropdown with DropType == BuildingType. Value stored is "multi", Label field is what you see.

The problem is in the Fields UI (of each of the Fields. The dropdowns for Value Field and Label Field return nothing and the interface shows and error:

The workaround is to click the manual entry (Tt button) and type in the correct entries.

Details on the Visual Query and what it returns are below.

Your environment

• 2sxc version(s): 21.07 and 21.06 (does not happen in 19.3.5)
• Browser: all / Chrome 146
• DNN 9.13.10 and 10.02.03
• Hosting platform: IIS on Win Server 2019
• Ui Languages: any/all, English

Additional context

The Visual Query

Sample of the data it returns: