Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Status
colourRed
title1.9 Beta Feature

...

  • category operator "value" : checks the the category of the item (REQ, SPEC, ...)
  • title operator "value" : checks the the title of the item 
  • outdated = 0|1 : checks that the item is outdated (it's parent has been modified after)
  • updated < | > Nx : checks that the last modification date of an item is lower or higher than a duration. Duration is expressed as integer followed by a letter:
    • y for year
    • m for month
    • w for week
    • d for day
    • H for hour
    • M for minute 
  • uplink | downlink operator category : checks that the item has at least one uplink (or downlink) to category. Also != , ~ and !~
  • label = "value": selects items that have (or don't have if  != is used) this label. The label part must be the internal one as defined in the admin console. 
  • all other variables are matches for a field name. If the field name contains a space the variable must be double-quoted

Examples:

  • mrql:domain ~ "xyz" and category = "TC"
    • matches all item of the category "TC" who has a field "domain" which includes "xyz"
  • mrql:outdated = 1 and category != "XTC"
    • matches all outdated items which are not "XTC" items
  • mrql:"test run result"="af|error|failed"
    • matches all failed tests: Since this field "test run result" is a dropdown, the actual value of the field "af|error|failed" differs from the displayed text "automatic - was 'failed' when last saved"
  • mrql:updated < 3H
    • matches all items modified during the last 3 hours
  • mrql:uplink ~ "REQ" 
    • matchs all items with an uplink in a category containing REQ (MREQ, FREQ, REQ, ...)
  • "mrql:updated<1w and category="REQ"

    • requirements updated in last 7 days

...