Opened 13 years ago

Closed 13 years ago

#1156 closed enhancement (fixed)

Add support for ALL and ANY constructs to the Query API

Reported by: Nicklas Nordborg Owned by: Nicklas Nordborg
Priority: major Milestone: BASE 2.9
Component: core Version:
Keywords: Cc:

Description

This is needed for solving #1129.

It would allow create queries like the one below which finds all members of groups have a name starating with 'A'.

SELECT usr 
FROM UserData usr 
WHERE usr = ANY( 
   SELECT member 
   FROM GroupData grp 
   JOIN grp.members member 
   WHERE grp.name LIKE 'A%'
)

The same result is possible to archive with a pure join query, but that generates duplicate rows if a user is a member of two or more groups that match the critera.

Change History (2)

comment:1 Changed 13 years ago by Nicklas Nordborg

Owner: changed from everyone to Nicklas Nordborg
Status: newassigned

comment:2 Changed 13 years ago by Nicklas Nordborg

Resolution: fixed
Status: assignedclosed

(In [4600]) Fixes #1156: Add support for ALL and ANY constructs to the Query API

Note: See TracTickets for help on using tickets.