projets
/
auf_coda_additions.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
1c38b4f
)
Rapport de consommation: ajouter les immo au réel
master
author
Eric Mc Sween
<eric.mcsween@auf.org>
Wed, 25 Mar 2015 15:23:34 +0000
(11:23 -0400)
committer
Eric Mc Sween
<eric.mcsween@auf.org>
Wed, 25 Mar 2015 15:23:34 +0000
(11:23 -0400)
rapports/consommation.sql
patch
|
blob
|
blame
|
history
diff --git
a/rapports/consommation.sql
b/rapports/consommation.sql
index
45649ec
..
075f36a
100644
(file)
--- a/
rapports/consommation.sql
+++ b/
rapports/consommation.sql
@@
-292,7
+292,7
@@
WHERE
AND balcode = 'REEL'
AND repbasis = 5
AND curcode = 'EUR'
- AND el1 LIKE '6%'
+ AND el1 LIKE '[26]%'
GROUP BY el3, yr;
-- Provisions par el3 {{{1