Changeset 3733:ee69b09370ec for inc

Timestamp:

03/15/18 11:48:54 (8 years ago)

Author:

franck <carnet.franck.paul@…>

Branch:

default

Message:

Add latest (associated entry date) and oldest (associated entry date) info when request list of metadata: it will provide a way to sort these metadata.

Plugin Tags updated in order to use this new feature (widget and templates)

File:

• inc/core/class.dc.meta.php (modified) (1 diff)

inc/core/class.dc.meta.php

@@ -325 +325 @@
             $strReq = 'SELECT count(distinct M.meta_id) ';
         } else {
-            $strReq = 'SELECT M.meta_id, M.meta_type, COUNT(M.post_id) as count ';
+            $strReq = 'SELECT M.meta_id, M.meta_type, COUNT(M.post_id) as count, MAX(P.post_dt) as latest, MIN(P.post_dt) as oldest ';
         }