Mercurial > hg > LGDataverses

view scripts/database/facetlist.sql @ 11:08c950a22cee

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
new: add getAllDataverseAlias api for LGServices
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Wed, 09 Sep 2015 17:13:18 +0200
parents a50cf11e5178
children
line wrap: on
line source

-- default facets defined in https://redmine.hmdc.harvard.edu/issues/3490 
-- show selected facets by displayorder
SELECT title,name,datasetfield.id FROM dataversefacet, datasetfield WHERE dataversefacet.datasetfield_id = datasetfield.id ORDER BY dataversefacet.displayorder;
-- more detail
-- SELECT dataversefacet.id, title, name, datasetfield.id, dataversefacet.displayorder, dataverse_id FROM dataversefacet, datasetfield WHERE dataversefacet.datasetfield_id = datasetfield.id ORDER BY displayorder;