Skip to main content
reenab9586
reenab9586
December 19, 2023
Question

Custom picker

  • December 19, 2023
  • 4 replies
  • 0 views

Hi Team, 

I need to populate the data in custom picker. But the data count is huge like 100000 rows available in the database. I have no other filter criteria to reduce the  count. My question is is it possible to populate the values after entering the first three characters of the data or is there is any alternative method available . 

    4 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    December 19, 2023

    Sure. Just query the data inside the suggest function, instead of trying to load everything and pass it along.

      mikes0011
      mikes0011
      Brainy
      December 19, 2023

      I assume the suggest function could even (with some extra coding hyjinks) be forced to return an empty set until it recognizes that the user input has reached at least 3 characters in length.  I haven't tried it myself but i assume nothing is preventing this sort of override from working.

      The Expression Guru
        amans0009
        amans0009
        December 20, 2023

        for reference [mention:5404af46754b4fb0bf1195fcdb866232:e9ed411860ed4f2ba0265705b8793d05] 

        if(
  len(
    /*Text we are putting in*/
    ri!filter
  ) >= a!defaultValue(
    /*Minimum character on which we want our search work on*/
    ri!minChar,
    3
  ),
  /*query*/,
  todatasubset({})
)


          marcop8892
          marcop8892
          December 27, 2023

          As per my understanding,

          After entering the first three characters, you can use an auto-complete or suggestion option to populate values. As the user types, dynamically filter and show matching values using JavaScript or a comparable scripting language.

          I hope this is helpful for you.

          Terms & ConditionsAccessibility statement