Method: Valkyrie::Persistence::Postgres::QueryService#find_references_with_type_query

Defined in:
lib/valkyrie/persistence/postgres/query_service.rb

#find_references_with_type_query ⇒ Object 



220
221
222
223
224
225
226
 
# File 'lib/valkyrie/persistence/postgres/query_service.rb', line 220

def find_references_with_type_query
  <<-SQL
    SELECT DISTINCT member.* FROM orm_resources a,
    jsonb_array_elements(a.metadata->?) AS b(member)
    JOIN orm_resources member ON (b.member->>'id')::#{id_type} = member.id WHERE a.id = ? AND member.internal_resource = ?
  SQL
end