Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Note
titlePostgreSQL preferredDatabase vendors

Criteria such as "jira", "page" or "properties" are only available for users of PostgreSQL. We're very sorry for the inconvenience, we're limited by the platform in this situationreadily supported in PostgreSQL and MySQL. If you use other vendors (Oracle, MS SQL...) and those criteria fail, please contact us and we'll fix them for you.

 

Requirement Yogi provides a search screen in every space.

...

QueryResult
key = 'IG-1'The requirement with the exact key.
key ~ 'IG-%'All requirements starting with 'IG-'.
text ~ '% something'All requirements whose text ends with 'something'.
page = '467382'All requirements defined on the page with ID 467382. (PostgreSQL only)
page ~ '467382'All requirements defined or linked on the page. (PostgreSQL only)
jira = 'JRA-21'All requirements linked from the issue JRA-21. (PostgreSQL only)
NOT (JIRA ~ '%')Requirements which are not linked to any JIRA issue. (PostgreSQL only)
@Category = 'Functional'All requirements where the property 'Category' = 'Functional'. (PostgreSQL only)

Keywords

KeywordFunction
AND, OR, NOTBoolean operators
= '...'Strict equality.
~ '...%...'Soft equality. Use % in the string as a wildcard.
@...Reference to a property of the requirement. (PostgreSQL only)

Fields

FieldDefinition
keyThe key of the requirement. Keys are unique per space.
spaceKeyThe space key of the requirement (case sensitive).
statusThe status of the requirement (ACTIVE, DELETED, MOVED).
textThe contents of the requirement (Does not include the properties).
pageThe ID of a page linked to the requirement. (PostgreSQL only)
jiraA JIRA issue linked to the requirement. (PostgreSQL only)