...
The SQL+JQL Driver checks whether the user has permissions to read the issue and Subversion commits (View Development Tools permission) if enabled on Subversion ALM. before return any result to the user.
ITEMSWITHISSUES
ITEMSWITHISSUES | |||||
|---|---|---|---|---|---|
Column | REPOSITORYID | REVISION | ACTION | ITEM | MAXITEMS |
Type | BIGINT | BIGINT | VARCHAR | TIMESTAMP | BIGINT |
Indexed | x | x | |||
- It returns items (file and directory paths) having some Jira issue related
...
- REPOSITORYID: The ID of the registered repository (required in most cases)
- REVISION: The revision number
- ACTION: A capitalized character for the action on the item in the revision: A(dded), M(odified), D(eleted) or R(replaced)
- ITEM: The file or directory path in the Subversion repository
- MAXITEMS: The max records (items) to return. It's a sort of SQL LIMIT clause useful to avoid OutputMemoryException when for large commits with a thousand of items versioned.
SQL+JQL example for Subversion
...