diff options
| author | Andrew Dolgov <fox@madoka.volgo-balt.ru> | 2012-10-08 12:35:43 +0400 |
|---|---|---|
| committer | Andrew Dolgov <fox@madoka.volgo-balt.ru> | 2012-10-08 12:35:43 +0400 |
| commit | bc7a0a1c0d2d1f2490aa896338fa85ad9cefea72 (patch) | |
| tree | 5fc0847ca9c7ceb0979dcd7bde9970a147cb101f /src/org/fox/ttrss/offline/OfflineHeadlinesFragment.java | |
| parent | b7069370759e8358ce7cc1b68fd13f703267dd4e (diff) | |
add option to show oldest articles first in offline mode (closes #504)
Diffstat (limited to 'src/org/fox/ttrss/offline/OfflineHeadlinesFragment.java')
| -rw-r--r-- | src/org/fox/ttrss/offline/OfflineHeadlinesFragment.java | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/src/org/fox/ttrss/offline/OfflineHeadlinesFragment.java b/src/org/fox/ttrss/offline/OfflineHeadlinesFragment.java index 37e35718..f49e634d 100644 --- a/src/org/fox/ttrss/offline/OfflineHeadlinesFragment.java +++ b/src/org/fox/ttrss/offline/OfflineHeadlinesFragment.java @@ -303,15 +303,17 @@ public class OfflineHeadlinesFragment extends Fragment implements OnItemClickLis feedClause = "feed_id = ?";
}
+ String orderBy = (m_prefs.getBoolean("offline_oldest_first", false)) ? "updated" : "updated DESC";
+
if (m_searchQuery == null || m_searchQuery.equals("")) {
return m_activity.getReadableDb().query("articles LEFT JOIN feeds ON (feed_id = feeds."+BaseColumns._ID+")",
new String[] { "articles.*", "feeds.title AS feed_title" }, feedClause,
- new String[] { String.valueOf(m_feedId) }, null, null, "updated DESC");
+ new String[] { String.valueOf(m_feedId) }, null, null, orderBy);
} else {
return m_activity.getReadableDb().query("articles LEFT JOIN feeds ON (feed_id = feeds."+BaseColumns._ID+")",
new String[] { "articles.*", "feeds.title AS feed_title" },
feedClause + " AND (articles.title LIKE '%' || ? || '%' OR content LIKE '%' || ? || '%')",
- new String[] { String.valueOf(m_feedId), m_searchQuery, m_searchQuery }, null, null, "updated DESC");
+ new String[] { String.valueOf(m_feedId), m_searchQuery, m_searchQuery }, null, null, orderBy);
}
}
|