Re: orm relation

2019-12-12 Thread 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 On Sun, 1 Dec 2019 at 19:39, bill dexter <55dexte...@gmail.com> wrote: > ELECT a.matr > ,[nom] >

Re: orm relation

2019-12-03 Thread 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. On Tue, Dec 3, 2019, 19:26 bill dexter <55dexte...@gmail.com> wrote: > hi friend; > i tryed your answer, but it says that error in syntax

Re: orm relation

2019-12-03 Thread 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 Le lun. 2 déc. 2019 à 20:31, Integr@te System a écrit : > Hi friend, > > All_list = list(users.object.aggregate(age = >

Re: orm relation

2019-12-02 Thread 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 =

Re: orm relation

2019-12-02 Thread bill dexter
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 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,

Re: orm relation

2019-12-01 Thread 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 On Sun, Dec 1, 2019, 21:08 bill dexter <55dexte...@gmail.com> wrote: > ELECT a.matr > ,[nom] > ,[prn] > ,cast([dat_nais] as date) as dat_nais > ,

orm relation

2019-12-01 Thread 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