Hi everyone, What will be the equivalent jpql queries for the sample crosstab report provided in the documentation. I have to create a crosstab report for a project of mine and i am stuck . TIA
Hi, it should be like this
SELECT 11 AS header_id, ‘November’ as month_name
FROM (VALUES (1)) AS dual (dual)