For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
Please see our announcement here.
DROP VIEW IF EXISTS hughtest; CREATE VIEW hughtest AS SELECT id, DATE_FORMAT( date_time, '%Y-%m-%d' ) AS datetime, encoder AS user_id, AVG( purchased_amount ) AS average, SUM( purchased_amount ) AS sum, COUNT( purchased_amount ) AS no_of_entries, SUM(CASE WHEN product_clas = 0 then 1 Else 0 end) AS aircon, SUM(CASE WHEN product_clas = 1 then 1 Else 0 end) AS refrigerator,SUM(CASE WHEN product_clas = 2 then 1 Else 0 end) AS washing_machine,
SUM(CASE WHEN product_clas = 3 then 1 Else 0 end) LED_TV
FROM empenc_warranty GROUP BY datetime, user_id
return (float)'{hughtest___salesquota}' - (float)'{hughtest___sum}';
print (int) '{full___element_name}'; or echo (int) '{full___element_name}';