www

commit 441696767a3d6a191b2000f8653e997d27369d2a
parent c093e7b62b9bbc6e2cb9809850d3e127f8b0d47d
Author: Dan Stillman <dstillman@zotero.org>
Date:   Thu, 27 Jul 2006 15:55:03 +0000

Don't return non-independent file items in Scholar.getItems()  (thanks David)


Diffstat:
M
chrome/chromeFiles/content/scholar/xpcom/data_access.js
 | 
5
+++--

1 file changed, 3 insertions(+), 2 deletions(-)
diff --git a/chrome/chromeFiles/content/scholar/xpcom/data_access.js b/chrome/chromeFiles/content/scholar/xpcom/data_access.js
@@ -3273,8 +3273,9 @@ Scholar.getItems = function(parent){
 	var toReturn = new Array();
 	
 	if (!parent){
-		var sql = "SELECT itemID FROM items LEFT JOIN itemNotes USING (itemID) "
-			+ "WHERE sourceItemID IS NULL";
+		var sql = "SELECT A.itemID FROM items A LEFT JOIN itemNotes B USING (itemID) "
+			+ "LEFT JOIN itemFiles C ON (C.itemID=A.itemID) WHERE B.sourceItemID IS NULL"
+			+ " AND C.sourceItemID IS NULL";
 	}
 	else {
 		var sql = 'SELECT itemID FROM collectionItems '