help/1.php

   1 <h1><?php echo __("Labels and SQL Expressions") ?></h1>
   2
   3 <p><?php echo __("Label content is generated using SQL expressions. The &laquo;SQL expression&raquo; 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>
   4
   5 <h2><?php echo __("Examples") ?></h2>
   6
   7 <p><?php echo __("Match all unread articles:") ?></p>
   8
   9 <code>unread = true</code>
  10
  11 <p><?php echo __("Matches all articles which mention Linux in the title:") ?></p>
  12
  13 <code>ttrss_entries.title like '%Linux%'</code>
  14
  15 <p><?php echo __("Matches all articles for the last week (PostgreSQL):") ?></p>
  16
  17 <code>updated &gt; NOW() - INTERVAL '7 days'</code>
  18
  19 <p><?php echo __("Matches all articles with scores between 100 and 500:") ?></p>
  20
  21 <code>score &gt; 100 and score &lt; 500</code>
  22
  23 <p>