Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

All other Modules

Discuss all other Modules here.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

DB Plumber complex query


Reply

5 Posts   960 Views

Avatar
swaiba

16 September 2010 at 2:56am Forum Moderator, 1796 Posts

Hi,

I have a complex query that I place into the SQL section and I get the result "no error", but no results... can DB Plumber take SQL like the following:

SELECT bi.ID,bi.Quantity,bi.Cost, BookingItemGroupID,abi.ActivityID,a.Name,abi.ScheduleID,s.StartDate,s.StartTime
FROM BookingItem bi, CourseBookingItem abi ,Activity a,Schedule s
WHERE bi.ClassName = 'CourseBookingItem' AND bi.ID = abi.ID AND a.ID = abi.ActivityID AND s.ID = abi.ScheduleID
AND bi.BookingItemGroupID IN (
SELECT big.ID FROM BookingItemGroup big
WHERE big.BookingID = (
SELECT ID FROM Booking WHERE OrderRefNumber = 'EGS200006'
)
)
ORDER BY bi.BookingItemGroupID ASC;

And if not, what would the limits be?

Avatar
apiening

16 September 2010 at 12:31pm Community Member, 60 Posts

hi swaiba,

actually you can feed it any query you like cause it just passes it to the underlying db using your silverstripe db connection.

"no error" is a db plumber msg saying that your query is ok, it just didn't return any results apparently.

if you send me a test dump of your data as a pm or post simplified test data here i can have a look. (schema + data)

Avatar
swaiba

16 September 2010 at 9:05pm (Last edited: 16 September 2010 9:05pm), Forum Moderator, 1796 Posts

Oops - this was indeed no data - I'm sorry - may I suggest changing the message to 'no data' or similar to indicate this for people like me :)

Avatar
apiening

20 September 2010 at 11:43am (Last edited: 20 September 2010 11:44am), Community Member, 60 Posts

you'r right, done. (r110932)

Avatar
swaiba

21 September 2010 at 8:23pm Forum Moderator, 1796 Posts

Many thanks apiening