Skip to main content
stevene0005
stevene0005
Participating Frequently
Apr 19, 2023 10:20 PM UTC
Solved

Auto-refresh issue on scrolling in dropdown of 100+ choices with 1+ null choice label, on a monitor

This is an issue that was initially reported on a Site and I could not replicate it when testing in any browser, until I thought to test on a separate monitor (not my laptop screen). When testing on the monitor was able to replicate in Chrome & Edge through the Site, through the top-level parent interface, and through the interface that contained the dropdown (although for the customers instead of a refresh, it was causing the entire page to turn grey). Can only replicate the issue on my laptop screen through the interface, not through the Site. I have reached a resolution for the issue (updating/deleting rows in the database or logic on local!choices to replace nulls with "Unknown") but sharing since I was not able to find anything when I had searched online. Believe the issue was caused by a user deleting some of the data for a couple rows before using the "Delete" icon/button that had been set up.

The case was the query pulling in the data did not have any filters & there were couple similar fields in the database: code, desc, name. The queried data was sorting on the code (always not null) & using the desc (couple nulls) as the Choice Labels (IDs as the Choice Values, all unique integers). Below is some code that can be copy-pasted into a test rule if anyone would like to see what the issue looks like, just need to do the testing on a separate monitor (not your laptop screen).

a!localVariables(
  local!values: enumerate(105),
  local!choices: touniformstring({enumerate(15), "", enumerate(89)}),
  local!selection: null,
  a!sectionLayout(
    contents: a!dropdownField(
      label: "Dropdown",
      placeholder: "-- Select a Value --",
      choiceLabels: local!choices,
      choiceValues: local!values,
      value: local!selection,
      saveInto: local!selection
    )
  )
)

stefanhelzle0001
stefanhelzle0001Answer
Brainy
Apr 20, 2023 6:11 AM UTC

[mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05] this seems to be a bug. I attached a video showing the behaviour.

[View:/cfs-file/__key/communityserver-discussions-components-files/13/Bildschirmaufnahme-2023_2D00_04_2D00_20-um-08.09.07.mp4:320:240]

View in thread

11 replies

gopalk2865
gopalk2865
Participating Frequently
Apr 20, 2023 5:49 AM UTC

when you are configuring choice labels and choice values for a dropdown , make sure you have null check for these choices and values. you will not face this error.

stefanhelzle0001
stefanhelzle0001Answer
Brainy
Apr 20, 2023 6:11 AM UTC

[mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05] this seems to be a bug. I attached a video showing the behaviour.

[View:/cfs-file/__key/communityserver-discussions-components-files/13/Bildschirmaufnahme-2023_2D00_04_2D00_20-um-08.09.07.mp4:320:240]

    harshitb6843
    harshitb6843
    Brainy
    Apr 20, 2023 10:43 AM UTC

    [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] Not sure if it is only for me - 

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    Apr 20, 2023 10:55 AM UTC

    I changed the format to mp4. Does that work for you?

    shuaibs6722
    Participating Frequently
    Apr 20, 2023 7:04 AM UTC

    What I understood is that the choice values are the Ids that are not null but the choice labels are non id fields that are nullable, here you need to put a filter on the query to return only that data which will not have nulls in the field used in the choice labels. 

    stevene0005
    stevene0005Author
    Participating Frequently
    Apr 20, 2023 3:09 PM UTC

    This was just a test interface to show/explain a bug. The actual interface had ID fields from a database as the Value & Description fields from a database as the Choices. A description had not been added to 3 of the 100+ rows. Having a dropdown with 100+ choices but 1 or more of them being blank causes this issue (Stefan replicated it & added a video).

    I had forgotten to mention in the post originally, but for the users, this issue was causing the entire page to turn into a gray screen (needing to manually refresh the web-page to fix). But for me it was looking like a page refresh, although selected values on the page were being retained for me.

    jayaprakashr0001
    jayaprakashr0001
    Participating Frequently
    Apr 20, 2023 7:18 AM UTC

    Hi,

    Slight correction in your code hope it will help you for the null values

    a!localVariables(
  local!choices: reject(fn!isnull,touniformstring({enumerate(15), "", enumerate(89)})),
  local!values: enumerate(count(local!choices)),
  local!selection: null,
  a!sectionLayout(
    contents: a!dropdownField(
      label: "Dropdown",
      placeholder: "-- Select a Value --",
      choiceLabels: local!choices,
      choiceValues: local!values,
      value: local!selection,
      saveInto: local!selection
    )
  )
)

    Terms & ConditionsAccessibility statement