Switch to unified view

a b/inst/queries/fieldCodes.xq
1
; fieldCodes
2
(fn [dataset fields]
3
    (query
4
      {:select [:P.name [#sql/call [:group_concat :value :order :ordering :separator #sql/call [:chr 9]] :code]]
5
       :from [[{:select [:field.id :field.name]
6
                :from [:field]
7
                :join [{:table [[[:name :varchar fields]] :T]} [:= :T.name :field.name]]
8
                :where [:= :dataset_id {:select [:id]
9
                                 :from [:dataset]
10
                                 :where [:= :name dataset]}]} :P]]
11
       :left-join [:code [:= :P.id :field_id]]
12
       :group-by [:P.id]}))