15 replies

JsonB sorting within Resource.actions

I have a Resource with a jsonb column called

metadata

metadata

How do I default sort by `metadata ->> 'CreatedDate'?

actions do
    read :read do
      prepare build(sort: [expr(fragment("metadata->>'CreatedTime' DESC"))])   # <-- How do I do this?!
      filter expr(isproject == true)
    end
  end

actions do
    read :read do
      prepare build(sort: [expr(fragment("metadata->>'CreatedTime' DESC"))])   # <-- How do I do this?!
      filter expr(isproject == true)
    end
  end

JsonB sorting within Resource.actions

Similar Threads

JsonB sorting within Resource.actions

Similar Threads

Similar Threads

Similar Threads