Changeset 712a157 in osmose-frontend


Ignore:
Timestamp:
Nov 22, 2012 8:32:59 PM (5 years ago)
Author:
Jocelyn Jaubert <jocelyn.jaubert@…>
Branches:
master
Children:
fec9253
Parents:
01a9204
git-author:
Jocelyn Jaubert <jocelyn.jaubert@…> (29/10/2012 22:38:03)
git-committer:
Jocelyn Jaubert <jocelyn.jaubert@…> (22/11/2012 20:32:59)
Message:

Fix SQL request to get number of errors per item/level

File:
1 edited

Legend:

Unmodified
Added
Removed
  • tools/cron.sh

    r0c93a99 r712a157  
    1818 
    1919psql -d $DATABASE -c "UPDATE dynpoi_item SET number = (SELECT array_agg(n) 
    20               FROM (SELECT count(*) AS n FROM dynpoi_class 
     20              FROM (SELECT count(*) AS n FROM marker 
     21                    JOIN dynpoi_class ON dynpoi_class.source = marker.source AND 
     22                                         dynpoi_class.class = marker.class 
    2123                    WHERE dynpoi_class.item = dynpoi_item.item 
    2224                    GROUP BY level 
Note: See TracChangeset for help on using the changeset viewer.