Need help in OQL query

0
Hello All,   Below query we are able to construct and run successfully in Oracle .  select  b.TEST_ID , b.BEGINNER_COUNT, l.LEARNER_COUNT from ( select TEST_ID ,COUNT(*) as BEGINNER_COUNT from myModule.Table1 TTM where  APPROVAL_DATE is not null group by TEST_ID )  b  ,    (select TEST_ID ,COUNT(*) as LEARNER_COUNT from myModule.Table1 TTM where  APPROVAL_DATE is not null group by TEST_ID ) l where l.TEST_ID=b.TEST_ID   I wanted to know if it is possible to construct similar query in Mendix OQL .   Thanks in advance.
asked
1 answers
0

The query is quite peculiar because the two parts look the same, but I guess you left someting out.

 

You can use

 from ( select TEST_ID ,COUNT(*) as BEGINNER_COUNT from myModule.Table1 TTM where  APPROVAL_DATE is not null group by TEST_ID )   b 
 inner join
 (select TEST_ID ,COUNT(*) as  LEARNER_COUNT from  myModule.Table1 TTM  where   APPROVAL_DATE  is not null group by TEST_ID ) l
 on l.TEST_ID=b.TEST_ID

  select  b.TEST_ID TESTID, 
 b.BEGINNER_COUNT BCOUNT, 
 l.LEARNER_COUNT LCOUNT

 

answered