Vue Tableau

{up table-fixe | col-left=1} {up table-sort |pagination=20 | col-init=1 | col-type=a-a-a-a-a-a-a-a | css-head=#id th[text-align:center;vertical-align:middle] #id tr:hover [background: lightblue;] .pag .btn-light[background:#01457f] .sortArrow[border-bottom-color: white!important;border-top-color: white!important;] }

{up csv2table | col=C10-15-10-15-15-15-10-15 | header=Site;Donneur d'ordre;Spécification;Procédé;Process;Capacité; Limitations; Date de validité |model=blue|style=font-size:11px}

{up sql=#__fields_values AS va | select=REPLACE(REPLACE(group_concat(va.value SEPARATOR ';'),'\r',''),'\n',' ') AS val | innerjoin=#__fields AS f ON va.field_id = f.id |where=f.group_id=4 AND f.state=1| group=va.item_id |order=va.item_id| template=##val## |presentation=0}

{/up csv2table} {/up table-sort} {/up table-fixe}

{up note=--------------------------------------------------------------------------------------------------------------} {up note = AU CAS OU, J'ai mis la requête seule. Ce n'est pas affiché grâce à UP NOTE}

bizarrerie

{up sql=#__fields_values AS va | select=REPLACE(REPLACE(group_concat(va.value SEPARATOR ';'),'\r',''),'\n',' ') AS val | innerjoin=#__fields AS f ON va.field_id = f.id |where=f.group_id=4 AND f.state=1| group=va.item_id |order=va.item_id| template=##val## |presentation=0} {/up note}