Opened 16 years ago
Closed 16 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 by , 16 years ago
Owner: | changed from | to
---|---|
Status: | new → assigned |
comment:2 by , 16 years ago
Resolution: | → fixed |
---|---|
Status: | assigned → closed |
Note:
See TracTickets
for help on using tickets.
(In [4600]) Fixes #1156: Add support for ALL and ANY constructs to the Query API