From 0745839a9590a1efb74f4f4d1940bdb67c90cfc8 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 16 May 2008 06:35:13 +0100 Subject: localize help dialogs --- help/1.php | 19 ++++++++----------- 1 file changed, 8 insertions(+), 11 deletions(-) (limited to 'help/1.php') diff --git a/help/1.php b/help/1.php index 8c7756330..a2b4566f1 100644 --- a/help/1.php +++ b/help/1.php @@ -1,26 +1,23 @@ -

Labels and SQL Expressions

+

-

Labels are generated by using SQL expressions. The «SQL expression» is added to WHERE clause of view feed query. You can match on ttrss_entries table fields and even use subselect to query additional information. This functionality is considered to be advanced and requires some understanding of SQL.

+

-

Examples

+

-

Match all unread articles:

+

unread = true -

Matches all articles which mention Linux in the title:

+

ttrss_entries.title like '%Linux%' -

Matches all articles for the last week (PostgreSQL):

+

updated > NOW() - INTERVAL '7 days' -

Matches all articles with scores between 100 and 500:

+

score > 100 and score < 500 -

See the database schema here or included in the distribution package for gruesome details. The relevant tables are ttrss_entries and ttrss_user_entries.

- -

Feel free to post more clever examples of labels on Tiny -Tiny RSS forums.

+

-- cgit v1.2.3