Mailing-List: contact jdo-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: jdo-dev@db.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Fri, 14 Oct 2005 14:52:48 -0700
From: Craig L Russell <Craig.Russell@Sun.COM>
Subject: Re: Query question
In-reply-to: <ac85de250510140710j5f677eb7yb5cd17230be8fb61@mail.gmail.com>
Sender: Craig.Russell@Sun.COM
To: jdo-dev@db.apache.org
Message-id: <75262636-4286-41B5-9A87-703E8BA30334@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; delsp=yes; charset=US-ASCII
Content-transfer-encoding: 7BIT
References: <ac85de250510140710j5f677eb7yb5cd17230be8fb61@mail.gmail.com>

Hi Karan,

On Oct 14, 2005, at 7:10 AM, Karan Malhi wrote:

> Hi,
>  First of all, I am sorry, I could not contribute much in the past  
> two or
> three weeks. Hopefully, I should be able to start contributing some  
> things
> this weekend.
> I had a question regarding queries.
> I have two classes , Address and Customer. Customer has many Addresses
>
> class Address{
> private String city;
> }
>
> class Customer{
> Set address = new HashSet(); //contains collection of Address objects
> }
>
> I want to find those customers , which belong to cities which are  
> contained
> in a collection. For example, if i had a collection of String objects,
> containing city values like PA, CA , LA, and I wanted to find  
> customers
> belonging to one of those cities, then would the following work. if  
> this
> doesnt work, then what would be the solution for this query .
>
> Set allowed = new HashSet(); // allowed collection contains cities  
> (String)
> allowed.add('ny');
> allowed.add('pa');
> query.setFilter("address.contains(add) && allowedCities.contains 
> (add.city
> )");
> query.declareParameter(Set allowedCities);
> query.setImports("import java.util.*");
> query.setVariable(Address add);
> query.execute(allowed);

Yes, this is a proper JDOQL query.

Craig

>
>
> --
> Karan Malhi
>