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've got this linq query such follows: IQueryable<CustomerToAccountLink> custLink = from c in uow.CustomerToAccountLinks where lp.AcctType == lm.AccountType && where (lm.InstNumber == c.InstNumber && where (c.LinkRelat == "01" ||
I keep getting the following error: Traversing relationships is not supported on the right hand side of a predicate
Any Thoughts on this? Josh |
|
|
I'm getting the same error...any progress on this? Thanks |
|
|
Hi Josh, Yes this is a limitation in the LightSpeed core where the RHS expression must be an entity property and not contain a traversal (as per the error description). We intend to resolve this in the future but for now you will need to work around this by adding a join against the Id assocation for the Rhs and then perform the comparison against the joined entity, e.g. join rhsId in uow.Ids where lm.IdId equals rhsId.Id ... where c.Id.LinkAccountNumber == rhsId.LinkAccountNumber
Jeremy |
|
|
Hi Jeremy - is there any tentative date for this issue to be resolved? Thx Clive |
|
|
Hi Clive, No, there isn't any tentative date to have this resolved but it is still on our backlog. We intend to look at this at the next appropriate point where we have to undertake a reasonable refactoring of the core querying logic (which would be as part of a major version) so until then the current behavior will remain as it stands now.
|
|