orm relation

[bill dexter]

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

[Integr@te System]

Hi,

here u can try for complex queryset

https://docs.djangoproject.com/en/2.2/topics/db/queries/#complex-lookups-with-q

--
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 django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/85f7f91b-0f52-4a96-8700-bee588eb4a3d%40googlegroups.com.

[bill dexter]

thank you, but if you can give me answer to this  exacte probleme, as mentioned in question 

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAP5HUWqap3ddCEmW-7yD_uRWhwxDNQdSNZ%2BQPPvHzcAwDf1e5Q%40mail.gmail.com.

[Integr@te System]

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.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAA7%3DR20i-DNEFTgdHQ7bjmvzQHrmML3LjzamrSiK07oJgbC_%2Bw%40mail.gmail.com.

[bill dexter]

hi friend;

i tryed your answer, but it says that error in syntax near  __gt  in ""extractyear(dat_enc) - extractyear(annee)__gt = 3""; don't work

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAP5HUWoRjYGOMbQf2Lz9npLi7%2BhsOfDoN-wYLAUAjbr9ites-Q%40mail.gmail.com.

[Integr@te System]

Hi issuer,

Plz refer to docs to customize statement base on your use case, my work for a sample with limited time. Plz try remove space around equal sign.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAA7%3DR22g%3DsVQJA1d4JdBC-biw%2BzcRCec9FPn_rbnBNo7%2B2%3DkTw%40mail.gmail.com.

[Dvs Khamele]

Hi We are worlds first affordable Python, Django Based Commpany,

And can help you in this and related tasks / projects immidiately mere at $7 per hour
Best Regards,
Divyesh Khamele,
Pythonmate

--