OBEROn - Bug Trace - Oberon Platform
Viewing Issue Advanced Details
79 OOQL language feature have not tried 2012-09-14 20:32 2012-09-21 14:04
g_prajeesh  
administrator  
normal  
resolved 2.6 - DB build 0065  
fixed  
none    
none 3.0 - DB build 0067  
0000079: Need to have a feature to get count() type functionalilty of DB in query OOQL
Many times we need to find the total number of Objects of specific class or number of links from an Object of specific link type.

Is it possible to get the count type of functionality in query.

Also is it possible to have a order by functionality

Issue History
2012-09-14 20:32 g_prajeesh New Issue
2012-09-21 14:02 administrator Assigned To => administrator
2012-09-21 14:02 administrator Status new => assigned
2012-09-21 14:03 administrator Target Version => 2.7 build 0067
2012-09-21 14:04 administrator Note Added: 0000151
2012-09-21 14:04 administrator Status assigned => resolved
2012-09-21 14:04 administrator Fixed in Version => 2.7 build 0067
2012-09-21 14:04 administrator Resolution open => fixed

Notes
(0000151)
administrator   
2012-09-21 14:04   
Added count feature for queries:

query count <QueryName>;

query count immediate {Query_Options};

Query_Options = "object" ObjectNamePattern
                | "objdescr" AdminNamePattern
                | "holder" HolderPatternList
                | "lifecycle" LifecyclePatternList
                | "stage" StagePatternList
                | "objectspace" ObjectSpacePatternList
                | "filter" FilterExpression