summaryrefslogtreecommitdiff
path: root/app/models/concerns/taggable_queries.rb
blob: 2897e5e642040b6d1088e0063b8ef0b2fffbda48 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
# frozen_string_literal: true

module TaggableQueries
  extend ActiveSupport::Concern

  class_methods do
    # context is a name `acts_as_taggable context`
    def arel_tag_names_array(context = :tags)
      ActsAsTaggableOn::Tagging
        .joins(:tag)
        .where("taggings.taggable_id=#{quoted_table_name}.id") # rubocop:disable GitlabSecurity/SqlInjection
        .where(taggings: { context: context, taggable_type: polymorphic_name })
        .select('COALESCE(array_agg(tags.name ORDER BY name), ARRAY[]::text[])')
    end
  end
end