Hi friend,
All_list = list(users.object.aggregate(age =
cast(extractyear(datetime.now()) - extractyear(dat_nais), output_field =
IntField())).filter(extractyear(dat_enc) - extractyear(annee)__gt = 3
& extractyear(datetime.now())
- extractyear(dat_nais)__IN=range(54,70) & cod_nad__contain =
'CN').order_by('num___annee',
'prn'))
Plz add more alias field as your sql command according to a sample above.
Ps: check your question first(sql), then pass to communities.
On Mon, Dec 2, 2019, 21:16 bill dexter <[email protected]> wrote:
> thank you, but if you can give me answer to this exacte probleme, as
> mentioned in question
>
> Le dim. 1 déc. 2019 à 18:55, Integr@te System <[email protected]>
> a écrit :
>
>> Hi,
>>
>> here u can try for complex queryset
>>
>>
>>
>> https://docs.djangoproject.com/en/2.2/topics/db/queries/#complex-lookups-with-q
>>
>> On Sun, Dec 1, 2019, 21:08 bill dexter <[email protected]> wrote:
>>
>>> ELECT a.matr
>>> ,[nom]
>>> ,[prn]
>>> ,cast([dat_nais] as date) as dat_nais
>>> , (YEAR(getdate()) - YEAR(dat_nais)) as age
>>> ,cast([dat_deces] as date) as dat_deces
>>> ,cast([dat_imm] as date) as dat_imm
>>> ,cast([dat_aj] as date) as dat_j
>>> ,[cod_position]
>>> ,YEAR(dat_imm) as anne_imm
>>> ,YEAR(dat_encais) as ann_regl
>>> ,[annee]
>>> ,[cod_nat]
>>> ,cast([dat_e
>>>
>>> Snc] as date) as dat_regl
>>> ,[mt_encais]
>>> FROM users a
>>> left join enca e on e.matr = a.matr
>>> left join encr c on (c.cod_encais = e.cod_encais)
>>> where (YEAR(c.dat_enc) - c.annee > 3 ) and ((YEAR(getdate()) -
>>> YEAR(a.dat_nais)) between 54 and 70) and c.cod_nat = 'CN'
>>> order by a.nom_, a.prn, c.annee asc;
>>>
>>> hello;
>>> my models are users, enca; encr;
>>> who can i performe this query using django ORM, note that i'm using
>>> MSSQL; thank very much
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Django users" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected].
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/django-users/85f7f91b-0f52-4a96-8700-bee588eb4a3d%40googlegroups.com
>>> <https://groups.google.com/d/msgid/django-users/85f7f91b-0f52-4a96-8700-bee588eb4a3d%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/django-users/CAP5HUWqap3ddCEmW-7yD_uRWhwxDNQdSNZ%2BQPPvHzcAwDf1e5Q%40mail.gmail.com
>> <https://groups.google.com/d/msgid/django-users/CAP5HUWqap3ddCEmW-7yD_uRWhwxDNQdSNZ%2BQPPvHzcAwDf1e5Q%40mail.gmail.com?utm_medium=email&utm_source=footer>
>> .
>>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/CAA7%3DR20i-DNEFTgdHQ7bjmvzQHrmML3LjzamrSiK07oJgbC_%2Bw%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CAA7%3DR20i-DNEFTgdHQ7bjmvzQHrmML3LjzamrSiK07oJgbC_%2Bw%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAP5HUWoRjYGOMbQf2Lz9npLi7%2BhsOfDoN-wYLAUAjbr9ites-Q%40mail.gmail.com.
