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
|
Is it something with Projection in query when using Through Associations in where etc? Cannot see any GROUP BY anywhere Isn't Projections the same as GroupBy ? |
|
|
No, projections are about selecting a subset of the data rather than the entire entity -- e.g. doing a SELECT Person.FirstName ... instead of SELECT Person.Id, Person.FirstName, Person.LastName ... GROUP BY is not supported in LightSpeed 2.x. We are adding it for 3.0. |
|
|
Ah, off course. Stupid me, little sleep last night or something |
|