4 Replies Latest reply: Feb 22, 2013 5:55 PM by VANJ RSS

    Super LOV plugin - Default search column

    VANJ
      Dan - Quick question about the Super LOV plugin for APEX 4.2.1

      From the help for the Settings/Searchable Columns
      Use this setting to specify which columns should be displayed in the select list of columns that allows users to filter the LOV result set. The value should be a comma separated list of numbers where the numbers refer to columns in the LOV query. If no value is supplied then all columns > will be searchable. If a value is supplied then only those columns will be searchable. The display column (defined via Item Display & Return Columns) will always be searchable and will be the default search column
      Is there a way to make the Return column the default search column instead of the Display column?

      Thanks
        • 1. Re: Super LOV plugin - Default search column
          dmcghan
          Vanj,

          Not without modifying the source code unfortunately. I can consider this in the next release but I think I did that for enterable. Do you have enterable enabled?

          Regards,
          Dan

          blog: http://DanielMcghan.us/
          work: http://SkillBuilders.com/APEX/
          • 2. Re: Super LOV plugin - Default search column
            VANJ
            No, I don't. Are you saying that by enabling Enterable, I can specify the default Search column in the popup? How?
            • 3. Re: Super LOV plugin - Default search column
              dmcghan
              Vanj,

              No, I'm saying that if enterable was enabled, it wouldn't make sense to have the default search column different than the display column - it would just confuse people.

              In a future release, I could allow you to "somehow" specify the default search column when enterable is not being used. I keep this in mind...

              Regards,
              Dan

              blog: http://DanielMcghan.us/
              work: http://SkillBuilders.com/APEX/
              • 4. Re: Super LOV plugin - Default search column
                VANJ
                it would just confuse people
                Not necessarily. It depends on how you want to use it. Say my query returns columns 1,2,3,4,5 with 1,2 being return and display respectively. But I always search on column 4. Entering the search keyword in the field and popping up the LOV to execute the search on column 4 is way faster than popping it open, selecting Column 4 from the Search dropdown, typing in the search keyword and clicking Search. But I can see how might want to search by the display column too. So maybe this should be a user-configurable setting.

                Speaking of Search, it would be great if we could search across all columns at once. Yet Another Setting!
                specify the default search column
                Well, this could be another setting or just use the first column specified in the Searchable Columns setting.

                FYI since I want to search by the return value and not the display value, I worked around this by just changing the LOV query to construct the display value as return + display i.e. *30 MARKETING* instead of simply MARKETING

                Thanks again for writing this plugin. It is one of the most well-designed pieces of software I have seen.