Changes between Version 5 and Version 6 of TracQuery


Ignore:
Timestamp:
Mar 19, 2010, 10:16:03 AM (12 years ago)
Author:
trac
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • TracQuery

    v5 v6  
    9898=== Query Language ===
    9999
    100 `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.
     100`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 (`\`).
    101101
    102102The available operators are:
     
    112112|| '''`!$=`''' || the field content does not end with any of the values ||
    113113
     114The 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.
     115|| '''`created=2007-01-01;2008-01-01`''' || query tickets created in 2007 ||
     116|| '''`created=lastmonth;thismonth`''' || query tickets created during the previous month ||
     117|| '''`modified=1weekago;`''' || query tickets that have been modified in the last week ||
     118|| '''`modified=;30daysago`''' || query tickets that have been inactive for the last 30 days ||
    114119
    115120----