Hi all,
We are in IFS Cloud 22R2 SU17
It seems that it is not possible to use input parameters in the quick reports with SQL expressions when you need to indicate them in the Group By section.
For example:
SELECT
CASE WHEN ip.PART_NO LIKE concat(&Type1, '%') THEN 'Electrique'
WHEN ip.PART_NO LIKE concat(&Type2, '%') THEN 'Roulement'
ELSE 'Autres'
END type_article,
count(ip.PART_NO)
FROM INVENTORY_PART ip
WHERE SECOND_COMMODITY = '300'
GROUP BY CASE WHEN ip.PART_NO LIKE concat(&Type1, '%') THEN 'Electrique'
WHEN ip.PART_NO LIKE concat(&Type2, '%') THEN 'Roulement'
ELSE 'Autres'
END
The request is allowed by the system but when you execute it, you have an error message “NOT A GROUP BY EXPRESSION”
Are you aware about this problem ? Is it a bug ?
Thanks in advance
Regards