Sub OQL Query Error

0
Hi All, Can we use sub oql query in mendix 6. Below is example of query where i am getting error select subOqlQuery.c1,sum(subOqlQuery.c2) from (select min(column1) over (partition by (column2) as c1, coulmn3 as c2 from module.table) as subOqlQuery group by subOqlQuery.c1 Please suggest its urgent?
asked
1 answers
0

Sub selects work like

FROM 
Program.Program AS PROGRAM
INNER JOIN PROGRAM/Program.Program_Supplier/Organization.Supplier AS SUPPLIER 
WHERE 
    SUPPLIER/ID = $SUPPLIERID
GROUP BY 
    PROGRAM/Name
SELECT 
    PROGRAM/Name AS ProgramName,
        (SELECT COUNT(*) AS C FROM Program.Action AS ACT WHERE 
          (ACT/ActionStatus='SomeStatus' AND
          ACT/Program.Action_Program = PROGRAM/ID AND
          ACT/Program.Action_Program/Program.Program/Program.Program_Supplier/Organization.Supplier = $SUPPLIERID) AS ACTIONCOUNT
answered