New answers tagged

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