Creating this search doman

[Tristian Paul]

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 have 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 = Char('Firstname')

        lastname = Char('Lastname')

Here's the current domain that I have:

given that 

     

      dates = [date(2012, 9, 10, date(2012, 9, 2), date(2012,9,3) ]

     name = 'Smith'

    dom = [

              ['OR',

                  [('lastname', '=', name)],

                  [('firstname', '=', name)]

             ],

             ['OR',

                  [ [

                      (CD, '>=', dt(date(d.year, d.month, d.day), time(0, 0, 0))),

                      (CD, '<', dt(date(d.year, d.month, d.day), time(23, 59, 59))),

                  ] for d in dates ]

              ]

      ]

       

Any help is really appreciated.

[Jean Cavallo]

Here's the current domain that I have:

What is the problem with this domain ? (error, does not work as intended...)

Jean 

[Cédric Krier]

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 have
> > 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 = Char('Firstname')
> lastname = Char('Lastname')
>
> Here's the current domain that I have:
> given that
>
> dates = [date(2012, 9, 10, date(2012, 9, 2), date(2012,9,3) ]
> name = 'Smith'
> dom = [
> ['OR',
> [('lastname', '=', name)],
> [('firstname', '=', 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, '>=', dt(date(d.year, d.month, d.day), time(0,
> 0, 0))),
> (CD, '<', dt(date(d.year, d.month, d.day), time(23,
> 59, 59))),
> ] for d in dates ]
> ]
> ]

--
Cédric Krier

B2CK SPRL
Rue de Rotterdam, 4
4000 Liège
Belgium
Tel: +32 472 54 46 59
Email/Jabber: cedric...@b2ck.com
Website: http://www.b2ck.com/

[mohit sarla]

Domain takes "AND" by default.

--
Mohit Sarla

[mohit sarla]

dom = [
['OR',
[('lastname', '=', name)],
[('firstname', '=', name)]
],

this is write for all the records of a model for which one or both of

two fields have
the same value

--
Mohit Sarla