]>
Commit | Line | Data |
---|---|---|
0d32b41e | 1 | <h1>Labels and SQL Expressions</h1> |
01c9c74a | 2 | |
0d32b41e | 3 | <p>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.</p> |
01c9c74a AD |
4 | |
5 | <h2>Examples</h2> | |
6 | ||
7 | <p>Match all unread articles:</p> | |
8 | ||
de1ca888 | 9 | <pre>unread = true</pre> |
01c9c74a AD |
10 | |
11 | <p>Matches all articles which mention Linux in the title:</p> | |
12 | ||
de1ca888 | 13 | <pre>ttrss_entries.title like '%Linux%'</pre> |
01c9c74a AD |
14 | |
15 | <p>See the database schema included in the distribution package for gruesome | |
16 | details.</p> | |
17 |