blob: 309783f436ec4115068941171ae9682c5b9eeaf2 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
<h1>Help for SQL expressions</h1>
<h2>Description</h2>
<p>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 basic
understanding of SQL.</p>
<h2>Examples</h2>
<p>Match all unread articles:</p>
<pre>unread = true</pre>
<p>Matches all articles which mention Linux in the title:</p>
<pre>ttrss_entries.title like '%Linux%'</pre>
<p>See the database schema included in the distribution package for gruesome
details.</p>
|