on-type suggestion filter and on-scroll pagination for filters like in ActiveAdmin Searchable Select

[zeuslocker]

I am migrating ActiveAdmin to AVO, we have a big tables and Avo filters are not really usable for it.
I can not create a static select filter because it tries to load 700k+ records into options at once
Dynamic filter is suggestions a static too, you can't load all of them, also when you click on it, it applies an empty values instead(avo 3.12.0)

So Right now filters are not usable for big table even in Pro version.

[Paul-Bob]

Hi @zeuslocker

Dynamic filters have this option: https://docs.avohq.io/3.0/dynamic-filters.html#fetch_values_from, which allows you to set an endpoint that returns data based on the search query. Let me know how it goes, I can send some snippets when I get back to my computer.

Are there any other challenges you are encountering during the migration?

[zeuslocker]

Please send some snippent, I a have an Account model which has_many Locations.

I was trying to use something like

      def filters
        dynamic_filter :locations, as: :tags, fetch_values_from: -> { '/avo-filters/resources/locations/tags' },
                                   filterable: true
      end

But it's not working

[Paul-Bob]

I've recorded a quick loom https://www.loom.com/share/550a24528de84397bf8e9d67e0d3b3bf?sid=25b740a5-2269-424c-baad-f081f26fc68f

[zeuslocker]

@Paul-Bob It's not working for some reason. Here is what I have:

if defined? Avo
  Avo::Engine.routes.draw do # rubocop:disable Metrics/BlockLength
    scope :resources do
      get 'locations/tags', to: 'locations#tags'
    end

      def filters
        dynamic_filter :locations, type: :tags, fetch_values_from: -> { '/avo/resources/locations/tags' }
      end

    def tags
      render json: Location.ransack(name_cont: params[:q], display_name_cont: params[:q], m: 'or')
                           .result(distinct: true).page(1).select(
                             :id, :name, :display_name
                           ).map do |location|
        {
          value: location.id,
          label: location.name
        }
      end.as_json
    end

it returns following json:
[{"value"=>"34adbfb2-abbf-577d-ad56-74d057de9ff7", "label"=>"DSDSD"}]

But when I type something in a field it shows loading spinner for a second and then does not show anything.
What I am doing wrong?

Also locations is a has many assosiation field for my account resource. Does tags filter work fine with that?

[zeuslocker]

[Paul-Bob]

I'm trying to use your code, but I'm getting a NoMethodError (undefined method 'page' for an instance of ActiveRecord::Relation) when calling .page(1).

But when I type something in a field, it shows a loading spinner for a second and then does not show anything.

That happens when the returned value is empty or when a error is raised inside your def tags method.

I would start by checking the request responses. You can open the Network tab in DevTools and inspect each request triggered by the filter. The response should not be [].

[zeuslocker]

I fixed tags endpoint but endup having this code:

  ```
    dynamic_filter :locations, type: :tags, fetch_values_from: lambda {
      '/avo/resources/locations/tags'
    }, conditions: {
      array_overlap: 'Overlap',
      array_contains: 'Contain'
    }.invert, query: lambda {
      case filter_param.condition.to_sym
      when :array_overlap
        query.ransack(
          locations_name_cont_any: params.dig('filters', 'locations', 'array_overlap', 0)&.split(',')
        ).result(distinct: true)
      when :array_contains
        query.ransack(
          locations_name_cont_all: params.dig('filters', 'locations', 'array_contains', 0)&.split(',')
        ).result(distinct: true)
      end
    }
    ```
    Because query_attributes seems not working in this case(I still normally use it in other places):
    this code:
    ```
            dynamic_filter :locations, type: :tags, fetch_values_from: lambda {
      '/avo/resources/locations/tags'
    }, query_attributes: %i[locations_name]
    
    ```
    generates this error:

[zeuslocker]

@Paul-Bob If you have a 10 mins tomorrow, let's call.
Feel free to send invite to volodymyr.lapan@onebeat.co

[Paul-Bob]

Sure, let's meet. Please use this link to schedule a call.