Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (defn get-request-last-status [request-id]
- (-> (select :status.id
- :status.name
- :status.status_type_id
- [:status_type.name :status_type_name]
- :request_status.commentary
- :request_status.timestamp)
- (from :request_status)
- (join :status [:= :request_status.status_id :status.id]
- :status_type [:= :status_type.id :status.status_type_id])
- (where [:= :request_status.request_id request-id])
- (order-by [:request_status.id :desc])
- (limit 1)
- (sql/format)
- (#(j/query db %))
- (first)))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement