Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 :
My complete data is :
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.