This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I don't think outer joins are currently supported (for either native lightspeed queries or linq queries) and I believe that this topic has been brought up many times in the past. However, I think it would be great if you guys can include this feature in the next release of Lightspeed 3 (by the way, when is version 3 going to be released?). Sometimes you cannot get by the restrictions that Lightspeed imposes on you and you need to write complex queries which require outer joins. I bet that a lot of people would like to have this feature.
|
|
|
You are correct - they are not currently a part of LightSpeed in 2.x, however it is a capability we have added in for 3.0 for both the native API and LINQ queries :) In terms of timeframes, we are still working on 3.0, but we will certainly let you know once we are ready for beta testing if you are interested!
Jeremy |
|