Edgewall Software

Changes between Version 2 and Version 3 of 0.12/TracQuery


Ignore:
Timestamp:
Oct 28, 2009, 1:06:05 PM (15 years ago)
Author:
Remy Blank
Comment:

Added info about escaping & and |.

Legend:

Unmodified
Added
Removed
Modified
  • 0.12/TracQuery

    v2 v3  
    8888=== Query Language ===
    8989
    90 `query:` TracLinks and the `[[TicketQuery]]` macro both use a mini “query language” for specifying query filters. Basically, the filters are separated by ampersands (`&`). Each filter then consists of the ticket field name, an operator, and one or more values. More than one value are separated by a pipe (`|`), meaning that the filter matches any of the values.
     90`query:` TracLinks and the `[[TicketQuery]]` macro both use a mini “query language” for specifying query filters. Basically, the filters are separated by ampersands (`&`). Each filter then consists of the ticket field name, an operator, and one or more values. More than one value are separated by a pipe (`|`), meaning that the filter matches any of the values. To include a litteral `&` or `|` in a value, escape the character with a backslash (`\`).
    9191
    9292The available operators are:
     
    102102|| '''`!$=`''' || the field content does not end with any of the values ||
    103103
    104 Since 0.12, the date fields `created` and `modified` can be constrained by using the `=` operator and specifying a value containing two dates separated by a semicolon (`;`). Either end of the date range can be left empty, meaning that the corresponding end of the range is open. The date parser understands a few natural date specifications like "3 weeks ago", "last month" and "now", as well as Bugzilla-style date specifications like "1d", "2w", "3m" or "4y" for 1 day, 2 weeks, 3 months and 4 years, respectively. Spaces in date specifications can be left out to avoid having to quote the query string.
     104The date fields `created` and `modified` can be constrained by using the `=` operator and specifying a value containing two dates separated by a semicolon (`;`). Either end of the date range can be left empty, meaning that the corresponding end of the range is open. The date parser understands a few natural date specifications like "3 weeks ago", "last month" and "now", as well as Bugzilla-style date specifications like "1d", "2w", "3m" or "4y" for 1 day, 2 weeks, 3 months and 4 years, respectively. Spaces in date specifications can be left out to avoid having to quote the query string.
    105105|| '''`created=2007-01-01;2008-01-01`''' || query tickets created in 2007 ||
    106106|| '''`created=lastmonth;thismonth`''' || query tickets created during the previous month ||