NDI-61 Update SQL query to obtain recdatecreated in API response so that I can filter on that in R package

sedv8808 · sedv8808 · commit 0b2a66095051 · 2025-10-23T08:21:41.000-07:00
diff --git a/function/doi/01_datasetinfo.sql b/function/doi/01_datasetinfo.sql
@@ -36,6 +36,7 @@ SELECT DISTINCT dts.datasetid,
                                                     'datasetnotes', dts.notes,
 							                            'database', cstdb.databasename,
 							                                 'doi', doi.dois,
+                                                             'recdatecreated', dts.recdatecreated,
 													   'datasetpi', dsau.authors,
 														'agerange', agerange.ages)) AS site
 FROM
diff --git a/function/doi/datasetinfo.sql b/function/doi/datasetinfo.sql
@@ -23,6 +23,7 @@ SELECT dts.datasetid,
 							                                   'datasetnotes', dts.notes,
 							                                       'database', cstdb.databasename,
 							                                            'doi', doi.dois,
+                                                                 'recdatecreated', dts.recdatecreated,
 																                    'datasetpi', dsau.authors,
 																                     'agerange', agerange.ages))))
 FROM
