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
|
Hi, I'm trying to code a groupby with 2 columns with the below:
This causes a NullException (Object reference not set to an instance of an object.) Is there anything that I missed? For single column grouping, it works flawlessly. Using LightSpeed ver 4.0.973.18978 Thanks. |
|
|
Im unable to repro this on the current build here, are you able to try this on a recent nightly build? If that is still problematic could you please send through a basic repro or just the table in the model you are using which exhibits this behavior and we can have a look into whats going on with this.
|
|
|
The previous issue was solved, however a new problem encountered. This is when I try to group by with joined tables.
Error as below:
Is the above query supported or something wrong with the syntax? |
|
|
Thanks for reporting this, it should be supported but it has found an edge case in our handling of anonymous type based grouping keys. I am working on getting this updated for you so hopefully I should have a fix for this ready for the nightly builds soon.
|
|
|
Just wondering whether this has been included in the nightly builds? Thanks. |
|
|
Not yet, but we are still actively working on this :) Unfortunately it has turned out to be a bit more involved than I first thought so there is still a bit more work to do to get this resolved but I will definitely be posting an update on the thread when I have an update ready for the nightly builds.
|
|
|
Just to say I'm having this issue as well - group by and joins don't work together. |
|