Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/conf/queries.properties @ 844:74608c12b4fe
Added Query for the CacheCleaner that it use to determin which Tables has been updated.
gnv-artifacts/trunk@960 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 20 Apr 2010 12:53:00 +0000 |
| parents | 8065295ae255 |
| children | 3fbabd4803d7 |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Tue Apr 20 10:11:28 2010 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Tue Apr 20 12:53:00 2010 +0000 @@ -1401,4 +1401,8 @@ from sde.geometry_columns \ where f_table_schema = '?' and \ f_table_name = '?' and \ - f_geometry_column='SHAPE' \ No newline at end of file + f_geometry_column='SHAPE' + +updated_tables = SELECT FULLTABLENAME \ + FROM MEDIAN.LASTUPDATED \ + WHERE LASTUPDATE >= to_date('?', 'YYYY.MM.DD HH24:MI:SS') \ No newline at end of file