The app is a straightforward relational representation of the BigBrassBand REST API.
Therefore, the same BBB Git users' Jira permissions are applied to the corresponding SQL table.
TABLES
REPOSITORIES
All the registered repositories
REPOSITORIES | |||||
---|---|---|---|---|---|
Name | REPOSITORYID | REPOSITORYNAME | ORIGIN | ROOT | MAINBRANCH |
Type | BIGINT | VARCHAR | VARCHAR | VARCHAR | VARCHAR |
Indexed | |||||
Name | DISABLED | ENABLEFETCHES | SENDCOMMITEMAILS | MAXMINCOMMITSTOEMAIL | GLOBAL |
Type | BOOLEAN | BOOLEAN | BOOLEAN | INT | BOOLEAN |
Indexed | |||||
Name | HOSTED | INITDATE | REVISIONINDEXING | REVSIONCACHESIZE | GITVIEWERENABLED |
Type | BOOLEAN | TIMESTAMP | BOOLEAN | INT | BOOLEAN |
Indexed | |||||
Name | DISABLESSLVERIFICATION | SMARTCOMMITSENABLED | COMMITSVALIDATIONREQUIRED | TAGSFILTER | SHOWALLTACGS |
Type | BOOLEAN | BOOLEAN | BOOLEAN | VARCHAR | BOOLEAN |
Indexed | |||||
Name | SUPPORTEXTERNALAPI | SOURCESDIFFVIEWENABLED | LIMITGITDATA | ||
Type | BOOLEAN | BOOLEAN | BOOLEAN | ||
Indexed |
PROJECTREPOSITORIES
Repositories mapped to a given project.
PROJECTREPOSITORIES | |||||
---|---|---|---|---|---|
Name | PROJECTID | PROJECTKEY | PROJECTNAME | REPOSITORYID | REPOSITORYNAME |
Type | VARCHAR | VARCHAR | VARCHAR | BIGINT | VARCHAR |
Indexed | x | x | |||
Name | ORIGIN | ROOT | MAINBRANCH | DISABLED | ENABLEFETCHES |
Type | VARCHAR | VARCHAR | VARCHAR | BOOLEAN | BOOLEAN |
Indexed | |||||
Name | SENDCOMMITEMAILS | MAXMINCOMMITSTOEMAIL | GLOBAL | HOSTED | INITDATE |
Type | BOOLEAN | INT | BOOLEAN | BOOLEAN | TIMESTAMP |
Indexed | |||||
Name | REVISIONINDEXING | REVSIONCACHESIZE | GITVIEWERENABLED | DISABLESSLVERIFICATION | SMARTCOMMITSENABLED |
Type | BOOLEAN | INT | BOOLEAN | BOOLEAN | BOOLEAN |
Indexed | |||||
Name | COMMITSVALIDATIONREQUIRED | TAGSFILTER | SHOWALLTACGS | SUPPORTEXTERNALAPI | SOURCESDIFFVIEWENABLED |
Type | BOOLEAN | VARCHAR | BOOLEAN | BOOLEAN | BOOLEAN |
Indexed | |||||
Name | LIMITGITDATA | ||||
Type | BOOLEAN | ||||
Indexed |
COMMITISSUES
Returns the list of issues associated with the commit from the specified repository.
COMMITISSUES | ||||
---|---|---|---|---|
Name | REPOSITORYID | COMMITID | ISSUEID | ISSUEKEY |
Type | BIGINT | VARCHAR | BIGINT | VARCHAR |
Indexed | x | x |
ISSUECOMMITS
Obtain commits associated with an issue
ISSUECOMMITS | ||||
---|---|---|---|---|
Name | ISSUEID | ISSUEKEY | COMMITID | AUTHOR |
Type | BIGINT | VARCHAR | VARCHAR | VARCHAR |
Indexed | x | x | ||
Name | CREATED | MESSAGE | REPOSITORYID | REPOSITORYNAME |
Type | TIMESTAMP | VARCHAR | BIGINT | BOOLEAN |
Indexed |
ISSUECOMMITFILES
Obtain commits associated with an issue and their committed file changes.
ISSUECOMMITFILES | |||||
---|---|---|---|---|---|
Name | ISSUEID | ISSUEKEY | COMMITID | AUTHOR | CREATED |
Type | BIGINT | VARCHAR | VARCHAR | VARCHAR | TIMESTAMP |
Indexed | x | ||||
Name | MESSAGE | REPOSITORYID | REPOSITORYNAME | PATH | LINESADDED |
Type | VARCHAR | BIGINT | VARCHAR | VARCHAR | INT |
Indexed | |||||
Name | LINESMODIFIED | LINESDELETED | ACTION | ||
Type | INT | INT | CHAR | ||
Indexed |
ISSUEBRANCHES
List of branches associated with a Jira issue.
ISSUEBRANCHES | |||
---|---|---|---|
Name | ISSUEID | ISSUEKEY | BRANCH |
Type | BIGINT | VARCHAR | VARCHAR |
Indexed | x | x |
ISSUETAGS
It retrieves TAGSPERREPOSITORY amount of the latest tags for the issue.
Tags are sorted in chronological order from newest to oldest.
ISSUETAGS | |||||
---|---|---|---|---|---|
Name | ISSUEID | ISSUEKEY | NAME | CREATED | MESSAGE |
Type | BIGINT | VARCHAR | VARCHAR | TIMESTAMP | VARCHAR |
Indexed | x | x | |||
Name | COMMITERNAME | COMMITEREMAIL | COMMITID | REPOSITORYID | REPOSITORYNAME |
Type | VARCHAR | VARCHAR | VARCHAR | BIGINT | VARCHAR |
Indexed | |||||
Name | ISTAGFEATUREENABLED | HASMORE | TAGSPERREPOSITORY | ||
Type | BOOLEAN | BOOLEAN | INT | ||
Indexed | x |
FUNCTIONS
COMMITLINK
BBBGIT.COMMITLINK(REPOSITORYID BIGINT, COMMITID VARCHAR, TARGET VARCHAR)
A convenient way to build links to open Git commits on Jira.
Target is any valid value supported by the HTML anchor element: _blank, _top, _self, etc..