Revision 6744
Added by ben leinfelder over 12 years ago
Sitemap.java | ||
---|---|---|
105 | 105 |
// TODO: make the doctype configurable in the query |
106 | 106 |
String sql = |
107 | 107 |
"SELECT xml_documents.docid, xml_documents.rev " + |
108 |
"FROM xml_documents, xml_access " + |
|
108 |
"FROM xml_documents, xml_access, identifier " +
|
|
109 | 109 |
"WHERE xml_documents.doctype LIKE 'eml:%' " + |
110 |
"AND xml_documents.docid = xml_access.docid " + |
|
110 |
"AND xml_documents.docid = identifier.docid " + |
|
111 |
"AND xml_documents.rev = identifier.rev " + |
|
112 |
"AND identifier.guid = xml_access.guid " + |
|
111 | 113 |
"AND xml_access.principal_name = 'public' " + |
112 | 114 |
"AND xml_access.perm_type = 'allow' " + |
113 | 115 |
"order by docid, rev"; |
Also available in: Unified diff
refactor Metacat access handling to be on a per-revision basis so that it more closely aligns with the DataONE approach
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5560