                                                                                                                                                                                                                                                                
Received-SPF: pass (google.com: domain of mohitsa...@gmail.com designates 74.125.83.45 as permitted sender) client-ip=74.125.83.45;
MIME-Version: 1.0
In-Reply-To: <CAO_URE0+VtquVe1rmh8YPAQzN7=aEx_TMSg4rvrAOZaBSQt...@mail.gmail.com>
References: <66020cdc-b2d2-4bee-afab-98a9038ddfdd@googlegroups.com>
	<20120928083804.GB10...@tetsuo.ced.homedns.org>
	<CAO_URE0+VtquVe1rmh8YPAQzN7=aEx_TMSg4rvrAOZaBSQt...@mail.gmail.com>
Date: Fri, 28 Sep 2012 17:03:26 +0530
Message-ID: <CAO_URE2hBatfdo+VX67nh7=-=PzH4Adr2fNR-b67CLTgBuE...@mail.gmail.com>
Subject: Re: [tryton] Creating this search doman
From: mohit sarla <mohitsa...@gmail.com>
To: tryton@googlegroups.com
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

    dom =3D [
              ['OR',
                  [('lastname', '=3D', name)],
                  [('firstname', '=3D', name)]
             ],

this is write for  all the records of a model for which one or both of
two fields have
 the same value
On Fri, Sep 28, 2012 at 4:37 PM, mohit sarla <mohitsa...@gmail.com> wrote:
> Domain takes "AND" by default.
>
> On Fri, Sep 28, 2012 at 2:08 PM, C=E9dric Krier <cedric.kr...@b2ck.com> w=
rote:
>> On 27/09/12 15:12 -0700, Tristian Paul wrote:
>>> Hi I've been struggling to create the following domain
>>>
>>> I want all the records of a model for which one or both of two fields h=
ave
>>> > the same value
>>>
>>> and where created on a list of given days, each day starts at 0:0:0 and
>>> > ends at 23:59:59
>>>
>>>
>>> For example in a person database containing the following model
>>>
>>>     class Person(ModelSQL):
>>>         # implicit create date
>>>         firstname =3D Char('Firstname')
>>>         lastname =3D Char('Lastname')
>>>
>>> Here's the current domain that I have:
>>> given that
>>>
>>>       dates =3D [date(2012, 9, 10, date(2012, 9, 2), date(2012,9,3) ]
>>>      name =3D 'Smith'
>>>     dom =3D [
>>>               ['OR',
>>>                   [('lastname', '=3D', name)],
>>>                   [('firstname', '=3D', name)]
>>>              ],
>>>              ['OR',
>>>                   [ [
>>
>> Here it becomes a 'AND' because list without 'AND' or 'OR' are by
>> default 'AND' so you must append your list comprehension to the list
>> with ['OR'].
>>
>>>                       (CD, '>=3D', dt(date(d.year, d.month, d.day), tim=
e(0,
>>> 0, 0))),
>>>                       (CD, '<', dt(date(d.year, d.month, d.day), time(2=
3,
>>> 59, 59))),
>>>                   ] for d in dates ]
>>>               ]
>>>       ]
>>
>>
>>
>> --
>> C=E9dric Krier
>>
>> B2CK SPRL
>> Rue de Rotterdam, 4
>> 4000 Li=E8ge
>> Belgium
>> Tel: +32 472 54 46 59
>> Email/Jabber: cedric.kr...@b2ck.com
>> Website: http://www.b2ck.com/
>
>
>
> --
> Mohit Sarla



--=20
Mohit Sarla