]>
Commit | Line | Data |
---|---|---|
0745839a | 1 | <h1><?php echo __("Labels and SQL Expressions") ?></h1> |
01c9c74a | 2 | |
0745839a | 3 | <p><?php echo __("Label content is generated 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.") ?></p> |
01c9c74a | 4 | |
0745839a | 5 | <h2><?php echo __("Examples") ?></h2> |
01c9c74a | 6 | |
0745839a | 7 | <p><?php echo __("Match all unread articles:") ?></p> |
01c9c74a | 8 | |
b44d8c51 | 9 | <code>unread = true</code> |
01c9c74a | 10 | |
0745839a | 11 | <p><?php echo __("Matches all articles which mention Linux in the title:") ?></p> |
01c9c74a | 12 | |
b44d8c51 | 13 | <code>ttrss_entries.title like '%Linux%'</code> |
01c9c74a | 14 | |
0745839a | 15 | <p><?php echo __("Matches all articles for the last week (PostgreSQL):") ?></p> |
01c9c74a | 16 | |
b44d8c51 | 17 | <code>updated > NOW() - INTERVAL '7 days'</code> |
747885fc | 18 | |
0745839a | 19 | <p><?php echo __("Matches all articles with scores between 100 and 500:") ?></p> |
a0044f24 AD |
20 | |
21 | <code>score > 100 and score < 500</code> | |
22 | ||
0745839a | 23 | <p> |