Versions Compared

Key

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

...

borderStylesolid

Smart-QL won't give you an access to data you cannot see in JIRA. Jira permissions, roles, groups are supported by Smart-QL. Smart-QL

...

queries will behave just like JQL queries and simple Jira searches - they will return only data user can access to see.

This means that if your Jira contains hundreds of issues but on of your users - John - can access only to five of them then following query will return only five issues:

Code Block
languagesql
titleJohn will see only five rows of data.
SELECT * FROM issues

When John can access only to three of fifteen projects in your JIRA, then following query will return only three projects:

Code Block
languagesql
titleJohn will see only three rows in a result
SELECT * FROM projects

The same is for all views available in Smart-QL for querying:

Code Block
languagesql
titleJohn will see changes only from five issues
SELECT * FROM changes


Code Block
languagesql
titleJohn will see comments only from five issues
SELECT * FROM comments

The same goes to filters and other Jira objects:

Code Block
languagesql
titleJohn will see filters only his own and shared with him
SELECT * FROM filters