Hi,

How do I retrieve data from child table having IsActive column = "T"?
I have two tables Patients And Contact, Contact is the child table of patient. I am using the billow query to retrieve the data




This query returns all patient with IsActive = "T" and all there contacts even if IActive = "F". How do I retrieve only those contacts with IsActive = "T".

Thanks

Arvind

Searching for the solution i found billow code i used to retrive only active rows



but when i use this i get the following error could not resolve property: Patient of: MyProject.Patient.

I also tryed this



I get this error "The value \"System.Object[]\" is not of type \"MagnumCore.Patient\" and cannot be used in this generic collection.\r\nParameter name: value"}


Is there anything i have to do with this, or is there any other way to achive this?

Thanks

Arvind

Hi,

There was error in the criteria query after changing to billow query

ICriteria criteria = session.CreateCriteria(typeof(MagnumCore.Patient))
.Add(Expression.Eq("DocNum", patientId)).CreateCriteria("PatientContact")
.Add(Restrictions.Eq("IsActive", isActive));

My query worked and returned patient with contacts, instead of returning only those contacts whose IsActive= T, I get all the contacts for the patient , i.e. it is not applying any condition to the contact. Is there anything i have missed in this ?

Thanks

Arvind

Hi,

There was error in the criteria query after changing to billow query it worked.

ICriteria criteria = session.CreateCriteria(typeof(MagnumCore.Patient))
.Add(Expression.Eq("DocNum", patientId)).CreateCriteria("PatientContact")
.Add(Restrictions.Eq("IsActive", isActive));

My query worked and returned patient with contacts, instead of returning only those contacts whose IsActive= T, I get all the contacts for the patient , i.e. it is not applying any condition to the contact. Is there anything i have missed in this ?

Thanks

Arvind

have a look at the doc:

http://www.hibernate.org/hib_docs/nhibernate/1.2/reference/en/html/querycriteria.html#querycriteria-associations

You query basically queries Patients and retrieves all Patients who have at least on PatientContact that matches your criteria. But the Patients are "fully" loaded, meaning all PatientContacts, not only those that match the criteria. If you want them filtered you need to use a result transformer:

SetResultTransformer(CriteriaUtil.AliasToEntityMap)


I never used it so I can't help you with the usage. But hopefully the rest of the answers helps you understand why you get what you get.

You can use filter to filter out inactive items. This approach is a bit different than including it in the criteria/query:

http://www.hibernate.org/hib_docs/nhibernate/1.2/reference/en/html/filters.html