Method: Valkyrie::Persistence::Postgres::QueryService#find_ordered_references_query

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

#find_ordered_references_query ⇒ Object 



228
229
230
231
232
233
234
235
 
# File 'lib/valkyrie/persistence/postgres/query_service.rb', line 228

def find_ordered_references_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 = ?
    ORDER BY b.member_pos
  SQL
end