Hi!

I've been testing this query:

select item from Item item
where item.translatedDescription.translationValues[:language].value LIKE %:text%
or
item.translatedName.translationValues[:language].value LIKE %:text%

It's strange but it just retrieve results for the second expression. I mean, it never find an object in item.translateDescription.translationValues[:language].value

However, when I try whith a query that just have the first expression, like this:
select item from Item item
where item.translatedDescription.translationValues[:language].value LIKE %:text%

it retrieves results. Any idea?

Thanks in advance!

More strange. If i add a close bracket at the end of the first expression, the query returns results for matchings found for the first expression, but 0 results for the second expression:

select item from Item item
where item.translatedDescription.translationValues[:language].value LIKE %:text% )
or
item.translatedName.translationValues[:language].value LIKE %:text%

It seems like a parser problem...does anybody use maps -more than once- in HQL queries?

Thanks a lot

More exact, these are my classes:


@Entity
@Indexed
public class Ficha {

@Id
@DocumentId
private Integer id;

@IndexedEmbeded
private Translation translatedName;

@IndexedEmbeded
private Translation translatedDescription;
....

...
@Entity
@Indexed
public class Translation {

@Id
@DocumentId
private Integer id;

@IndexedEmbeded
Map <Language, TranslationValue> translationValues;
....
...
@Entity
@Indexed
public class TranslationValue {

@Id
@DocumentId
private Integer id;

@Field(index=Index.TOKENIZED, store=Store.NO)
String value;
....

@Entity
@Indexed
public class Language {

@Id
@DocumentId
private Integer isoName
....

and the query:

select ficha from Ficha ficha

where ficha.translatedDescription.translationValues[:language].value LIKE %:text% )
or
item.translatedName.translationValues[:language].value LIKE %:text%

It never returns matchings for the first expression. However, if add a close bracket at the end of the first expression, it returns results. Could be a parser bug?

Thanks a lot.

I ment that the query is:

select ficha from Ficha ficha

where ficha.translatedDescription.translationValues[:language].value LIKE %:text%
or
ficha.translatedName.translationValues[:language].value LIKE %:text%

Could anybody test that query please?? It's very important.

Thanks.