Hi,
I've got a SQL query which is good. It is :
SELECT `annee`,`modif_date`,`idTypeDepense`,`idContratBene`,
`montant_ae`
FROM `previsionnel_depense`
WHERE `modif_date`<= "MYPARAM"
group by `annee`, `idTypeDepense`,`idContratBene`
ORDER BY `modif_date` DESC
It returns this datas :
annee | modif_date | idTypeDepense | idContratBene | montant_ae | |
---|
2015 | 2015-09-01 00:00:00 | 1 | 2 | 15 | |
2014 | 2015-01-01 00:00:00 | 2 | 31 | 42 | |
2014 | 2014-09-01 00:00:00 | 1 | 2 | 10 | |
My complete data is :
annnee | modif_date | idTypeDepense | idContratBene | montant_ae |
---|
2015 | 2015-09-01 00:00:00 | 1 | 2 | 15 |
2014 | 2015-01-01 00:00:00 | 2 | 31 | 42 |
2014 | 2014-09-01 00:00:00 | 1 | 2 | 10 |
2014 | 2014-07-07 00:00:00 | 2 | 31 | 44 |
My question is : how can I make this selection in qlickview when "MYPARAM" is modified in a calendar object?
thanks a lot for your responses.