[contractdashboard.git] / exportOverview.csv.php
--- a/exportOverview.csv.php
+++ b/exportOverview.csv.php
@@ -11,10 +11,11 @@
     $unspsc[$row['UNSPSC']] = $row['Title'];
 }
 
+//(\'https://www.tenders.gov.au/?event=public.advancedsearch.keyword&keyword=CN\'::text || "CNID"::text) as url 
 $query = $conn->prepare('
-SELECT "CNID" as uid, description as text,
-(\'https://www.tenders.gov.au/?event=public.advancedsearch.keyword&keyword=CN\'::text || "CNID"::text) as url from "contractnotice"
-where "childCN" is null'
+SELECT "CNID" as id, description as text
+from "contractnotice"
+where "childCN" is null limit 10000'
         , array(PDO::ATTR_CURSOR => PDO::FETCH_ORI_NEXT));
 $query->execute();
 $errors = $conn->errorInfo();