1 <h1
>Labels
and SQL Expressions
</h1
>
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
>
7 <p
>Match all unread articles
:</p
>
9 <pre
>unread
= true</pre
>
11 <p
>Matches all articles which mention Linux in the title
:</p
>
13 <pre
>ttrss_entries
.title like
'%Linux%'</pre
>
15 <p
>See the database schema included in the distribution package
for gruesome