Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Note
titlePostgreSQL preferred

Criteria such as "jira", "properties"

 

Excerpt
hiddentrue
nameSearch syntax

Learn the search syntax, to use everywhere on the plug-in. Find requirement keys, properties, and even Jira issue links.

Info

Looking for the Cloud version?

See the Search Syntax for the Cloud.

This page describes the search syntax to find requirements in Confluence. Requirement Yogi provides a search screen in every space.

...

Image Added

By default, only active requirements of the current space are displayed. Use the URL to display deleted requirements or to search across spaces.

If you are more a video documentation type of person, check out our tutorial on the search syntax here:

https://youtu.be/cuekdOY1BtM

...

Examples

Note: All those examples require Requirement Yogi 1.3.

Search on...

Query

Result

Key

key = 'IG-1'

The requirement with the exact key.

key ~ 'IG-%'

All requirements starting with 'IG-'.

Contents

text ~ '% something'

All requirements whose text ends with 'something'.

Pages

page =

...

467382

...

All requirements defined on the page with ID 467382 (Does not include dependencies)

(Before RY 3.

...

1, it would retrieve all current-or-baseline requirements on all versions of this page).

(Before RY 2.5, quotes around the page ID were necessary)

page ~

...

467382

Same as `links ~ `, except it is not intuitive.

(Before RY 3.1, it would retrieve all current-or-baselined requirements on all versions of that page).

pageHistory ~ 123

All requirements on all versions of that page (Since RY 3.1)

links = ...

All requirements defined or linked on the page.

...

Issues

jira = 'JRA-21'

All requirements linked from the issue JRA-21.

...

jira@implements = 'JRA-21'

All requirements linked from the issue JRA-21 with the relationship "Implements" (since version 1.5)

NOT (

...

jira ~ '%')

Requirements which are not linked to any JIRA issue.

...

Properties

@Category = 'Functional'

All requirements where the property 'Category' = 'Functional'.

@Main\ Category = 'Functional'

All requirements where the property 'Main Category' = 'Functional'. Use the backslash symbol before a space or special symbol to escape it.


ext@Category = 'Functional'

All requirements where the external property 'Category' = 'Functional'.

Dependencies

TO = 'REQ-001'

Requirements which reference REQ-001.

FROM = 'REQ-001'

Requirements which are referenced by REQ-001.

FROM ~ 'REQ-%'

Requirements which are referenced by any requirement starting with "REQ-".

FROM@refines = 'REQ-001'

Requirements which are "refined" by REQ-001.

Special

isModified('7')

Requirements which have been modified since the baseline '7' of the current space. It works both with the baseline number and with the baseline name.

Baselines

baseline = 3

baseline was 3

baseline = 4 and baseline was 3

baseline = 'My Baseline'

Requirements in their version 3.

Requirements in their current version, which were also in the baseline 3 (since 3.2.0).

Requirements in their version 4, which also where in baseline 3 (since 3.2.0).

Assuming 'My Baseline' exists in this space and has the number 3, it is equivalent to the previous query.

Tests

hasLastTest('%Success%')

Checks the last test is equal to the provided value, using '%' as a wildcard.

...

Syntax: hasTest( [relationship,] expectedResult [,page])

Syntax: hasLastTest( [relationship,] expectedResult [,page])

Excel

excel = '48496653'

All requirements imported from the Excel attachment with ID 48496653 (since version 2.0)

excel ~ '%'

All requirements imported from an Excel file.

Keywords

Keyword

Function

AND, OR, NOT, ()

Boolean operators. Example: key ~ ‘FN%’ AND NOT (@Property = ‘Functional’ AND @Component = ‘Core’).

= '...'

== '...'

Strict equality.

~ '...%...'

Soft equality. Use % in the string as a wildcard.

@...

...

Reference to a property of the requirement

...

(if you've defined requirements in columns).

IS NULL

Can be used for any attribute. Example: JIRA IS NULL.

IS NOT NULL

Can be used for the field 'baseline'.

Fields

Field

Definition

key = ...

The key of the requirement. Keys are unique per space.

spaceKey = ...

The space key of the requirement (case sensitive).

baseline = ...

The baseline name or number. All statuses are implicitly included.

Quotes were required before version 2.4: baseline = '1'

Starting from 2.6.3, it also supports a variable: $currentBaseline. The traceability matrix will display a field where you can input the number, and the saved matrix can be used in the blueprints of the baselines.

baseline was ...

The baseline name or number of a previous version of this requirement (since 3.2.0).

status = ...

The status of the requirement (ACTIVE, DELETED, MOVED). Default: ACTIVE. There is generally no reason to use it, since those statuses are internal details about requirements. You would rather define your own property named "Status", and search them using @status = 'Approved' for example. Do not confuse "status" (our internal implementation detail) and "@status" (any user-defined property).

text = ...

The contents of the requirement (Does not include the properties).

page = ...

The ID of a page or a version where a requirement is defined.

pageHistory = ...

The ID of a

...

current page, where a requirement is defined."~" is undefined.

links = ...

The ID of a page where a requirement is linked (or defined). "~" is undefined.

jira = ...

A JIRA issue linked to the requirement.

jira@relationship = ...

A JIRA issue linked with a specific relationship.

@aproperty = ...

A property with name "aproperty".

ext@aproperty = ...

An external property with name "aproperty".

to@arelationship = ...

from@arelationship = ...

A dependency with the relationship "arelationship".

excel = ...

The ID of the attachment were those requirements are defined.

Changes in 3.2

Added 'baseline was'.

Changes in 3.1

The "page ~ " and "page =" was restricted to requirements exactly on this page, instead of requirements on any version of this page.

"pageHistory" and "links" were added.

Formatting, lists of properties, etc.

Since Release 2.4 - Improvements to the search, we support emoticons such as (tick) (error) (lightbulb) etc. ! We also support lists! How does it work?

  • We save the rendered format in HTML,

  • We save the searchable format separately.

Thanks to this, you can search with:

  • @property = '(/)' → Searches for the (tick) emoticon

  • @property = 'item1' → Searches for a property which has the item "item1" in the list. Note that the list may also have "item2", "item3", etc.

...

  • @property = user('admin') → Searches for the mention of the user 'admin' or the user key 'admin' (the second one will be stable over time, even if the username changes).

What about JQL in Jira?

See JQL Syntax.