Bug Report T294274
Visible to All Users

InvalidOperationException is thrown when the conditional operator is used to return a key value of different object types

created 9 years ago

Hello,

I have a problem with XPO (again :) ). If query that is created has more than one table in join, you switch to server side calculation, instead of SQL, and this breaks the data. I have created a demo, and inside there are examples of queries that don't work.

The problem is manifested if you try to filter grid on something, entering a text into search area. Oids will remain in grid (surprisingly) but the data in second column is lost. Filtering is applied, because if you enter a text which is not there, you will get message that there are is not data to show.
Also if you group by Oid, data from second column is lost.

Why I say again, because it is a question of translating Linq to XPO, and then XPO to SQL, and I already had an issue with similar problem which was solved.

Previous issue:
https://www.devexpress.com/Support/Center/Question/Details/T288428

Thank you in advance

Show previous comments (4)

    No problem.
    Thank you for great support experience.
    I guess this fix is coming with next release? I'm not in a rush, just to say.

    Dennis Garavsky (DevExpress) 9 years ago

      >>I guess this fix is coming with next release?
      This information will be known a bit later. You will be automatically notified of this via email, as always.

        OK, great, thank you.

        Answers approved by DevExpress Support

        created 9 years ago

        We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.

        Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.

          Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

          Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.