Advertisement
Guest User

Untitled

a guest
May 31st, 2019
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. (defn get-request-last-status [request-id]
  2.   (-> (select :status.id
  3.               :status.name
  4.               :status.status_type_id
  5.               [:status_type.name :status_type_name]
  6.               :request_status.commentary
  7.               :request_status.timestamp)
  8.       (from :request_status)
  9.       (join :status [:= :request_status.status_id :status.id]
  10.             :status_type [:= :status_type.id :status.status_type_id])
  11.       (where [:= :request_status.request_id request-id])
  12.       (order-by [:request_status.id :desc])
  13.       (limit 1)
  14.       (sql/format)
  15.       (#(j/query db %))
  16.       (first)))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement