[nhibernate-issues] [JIRA] Updated: (NH-503) Unable to use HQL expression with subtype

[NHibernate J. <mik...@us...>]

     [ http://jira.nhibernate.org/browse/NH-503?page=all ]

Sergey Koshcheyev updated NH-503:
---------------------------------

    Fix Version: LATER

> Unable to use HQL expression with subtype
> -----------------------------------------
>
>          Key: NH-503
>          URL: http://jira.nhibernate.org/browse/NH-503
>      Project: NHibernate
>         Type: Improvement
>   Components: Core
>     Versions: 1.0.1
>     Reporter: Jerry Haltom
>      Fix For: LATER

>
> query = session.CreateQuery(
>     "select     person\n" +
>     "from       ISIS.Data.Core.PaymentInstruction   payment\n" +
>     "inner join payment.Participant                 participant\n" +
>     "inner join participant.Program                 program\n" +
>     "inner join program.Contract                    contract\n" +
>     "inner join participant.Person                  person\n" +
>     "where      payment.LastDate is null null\n" +
>     "   and     payment.Account.class = ISIS.Data.Core.BankAccount\n" +
>     "   and     payment.Account.Number like '%' + :accountNumber + '%'\n" +
>     "   and     contract.Client = :client\n"
> );
> The error I am receiving is that the property Account cannot be found in type ISIS.Data.Core.Account. BankAccount is a subclass of Account. I am trying to apply an expression only against BankAccounts in the database. It looks like it doesn't know this. If there was some way to case payment.Account in HQL, that would fix it. What is the solution?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira