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]})) |