I'm using the Criteria API for my search. I can not make a simple concat to work.

A user must be able to search for an item name. The item name is made up of the brand name and a item name.

I want to concat the brand.name property with item.name property.

ex


can this be done?

Hi Mathias,

If you add an extra property (it can be protected, and it doesn't actually need to do anything - although it's nicer if it's genuine) to your class:


Then add to your mapping of the class:


Alternatively, when you are saving your item objects, persist a genuine BrandItemName protected property so that you can search on it later. (I would tend towards this option personally)

Then you can use the criteria:


Does that help solve your problem?

Regards,
Richard

I get error when trying to execute

this is a simple example just returning the name. What I would like to is Item.Brand.Name + ' ' + Name

Hi Mathias,

It might help if we knew the error you were getting.

If you want a formula to cross tables, you need to use SQL names (not object properties) notation, so the formula might be something like:


I would still recommend creating a column and map a protected field to it to avoid the formula altogether.

Regards,
Richard

Can you please tell me what you mean here? Create another column in the table and have a setter and a getter? Can this be done without a setter?

I would like to just have

Yes, exactly - with an extra column in the database.

I think you need a setter to keep NHibernate happy, so if you want the property to be public, something like:



The only problem you might have to watch for is if Brand names change a lot, then the changes have to be cascaded to the Items.

Ok!

I have made the FullName. How ever. If a brand changed I need to go thru all items that has this brand and update the translation. This was not what I was planning but since this is the best alternative I'll have to go with this.

Thanks!