Re: Question about key path expression

2009-09-09 Thread Michael Gentry
Oh, sorry about that. I knew that, but just missed it. :-) Glad it works for you now! mrg On Tue, Sep 8, 2009 at 6:54 PM, Reinout van Schouwen wrote: > Hi Michael, > > Op dinsdag 08-09-2009 om 12:22 uur [tijdzone -0400], schreef Michael > Gentry: >> Then you should use that in your expression

Re: Question about key path expression

2009-09-08 Thread Reinout van Schouwen
Hi Michael, Op dinsdag 08-09-2009 om 12:22 uur [tijdzone -0400], schreef Michael Gentry: > Then you should use that in your expression: > > Expression.fromString("names.familyName like '$name'") Thanks, after I removed the unnecessary single quotes, this worked. :-) -- Reinout van Schouwen

Re: Question about key path expression

2009-09-08 Thread Michael Gentry
Then you should use that in your expression: Expression.fromString("names.familyName like '$name'") mrg On Tue, Sep 8, 2009 at 11:58 AM, Reinout van Schouwen wrote: > Hi Michael, > > 2009/9/8 Michael Gentry : >> Also, what is the name of your relationship from Person to PersName? > > It is 'nam

Re: Question about key path expression

2009-09-08 Thread Reinout van Schouwen
Hi Michael, 2009/9/8 Michael Gentry : > Also, what is the name of your relationship from Person to PersName? It is 'names'. -- Reinout van Schouwen

Re: Question about key path expression

2009-09-08 Thread Michael Gentry
Also, what is the name of your relationship from Person to PersName? On Tue, Sep 8, 2009 at 11:19 AM, Reinout van Schouwen wrote: > Hi, > > I have a table Person and a table PersName. I've created a relation > between PersName and Person so that each PersName links to a Person. In > other words,

Re: Question about key path expression

2009-09-08 Thread Michael Gentry
Try this instead: final Expression queryTemplate = Expression.fromString("persname.familyName like '$name'"); Map queryParams = Maps.newHashMapWithExpectedSize(1); queryParams.put("name", "A%"); // TODO "A" from parameter I believe the wildcard (%) has to go into the map and not the expression

Question about key path expression

2009-09-08 Thread Reinout van Schouwen
Hi, I have a table Person and a table PersName. I've created a relation between PersName and Person so that each PersName links to a Person. In other words, a Person may have multiple PersNames. Is it possible to do a query like this: // find all Persons whose family name starts with A final E

Question about key path expression

2009-09-08 Thread Reinout van Schouwen
Hi, Is it possible to do a query like this: