As everybody know Hybris has great tool to write scripts. It helps a lot during transform or migration data. Some times this scripts became too big for understanding. From this my question: Is there a way to debug BeanShell and Groovy scripts in Hybr...
Hi folks,
It is possible to join included query? I wrote simplified example, I think idea is clear. Any advice would be appreciate. Thanks.
SELECT x.code, y.code
FROM ({{ SELECT {p.code} FROM Product AS p}}) AS x
LEFT JOIN ({{SELECT {p1.code} FRO...
I am trying to create a report, for this I need to write query with sub-query in from clause like it supports native SQL for example:
SELECT
p.ProductID,
p.Name AS ProductName,
p.ProductSubcategoryID AS SubcategoryID,
ps.Name AS Su...
