nuBuilder Forum

kev1n wrote: ↑Tue Jun 10, 2025 7:42 am I think this is the last update you need to run:

Code: Select all

UPDATE `zzzzsys_php` SET `sph_php` = '$getDistinctGroupColumnQuery = function($column) {\n    return \"\n        SELECT \n          DISTINCT TRIM($column) AS trimmed_col\n        FROM \n          zzzzsys_php \n          LEFT JOIN zzzzsys_form ON zzzzsys_form_id = sph_zzzzsys_form_id \n        WHERE \n          IFNULL($column, \'\') <> \'\'\n          AND (\n            (\n              sph_system != \'1\' OR sph_system IS NULL\n            ) \n            OR (\n              \'#DEV_MODE#\' = \'1\' AND LEFT(RIGHT(sph_code, 3), 1) <> \'_\'\n            )\n          ) \n        ORDER BY \n          trimmed_col\n\n    \";\n};\n\n$sqlGroup = function() use ($getDistinctGroupColumnQuery) {\n    return $getDistinctGroupColumnQuery(\'sph_group\');\n};\n\n$group = nuEncodeQueryRowResults($sqlGroup(), [], [\'\']);\n\n$filterJS = \"\n    function getData(data) {\n        return JSON.parse(atob(data));\n    }\n    function getGroup() {\n        return getData(\'$group\');\n    }\n\";\n\nnuAddJavaScript($filterJS);' WHERE `zzzzsys_php`.`zzzzsys_php_id` = 'nuprocedure_BB';