New answers tagged sql
0
Raw Pivot Query
SELECT ju.username,
ju.name,
MAX(IF(jfv.field_id = 2, jfv.value, NULL)) AS `door`,
MAX(IF(jfv.field_id = 3, jfv.value, NULL)) AS `staircase`,
MAX(IF(jfv.field_id = 4, jfv.value, NULL)) AS `floor`
FROM `#__users` AS ju
INNER JOIN `#__fields_values` AS jfv ON ju.id = jfv.item_id
GROUP BY ju.username ASC, ju.name
...
2
When creating/editing the field, set Multiple option to Yes. Or edit Fields - SQL plugin to enable multiple option globally for all SQL fields.
Top 50 recent answers are included
