Method: Valkyrie::Persistence::Postgres::QueryService#find_ordered_references_with_type_query

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

#find_ordered_references_with_type_query ⇒ Object 



237
238
239
240
241
242
243
244
 
# File 'lib/valkyrie/persistence/postgres/query_service.rb', line 237

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