SpagoWorld JIRA

  • Dashboards
  • Projects
  • Issues
  • Give feedback to Atlassian
  • Help
    • JIRA Core help
    • Keyboard Shortcuts
    • About JIRA
    • JIRA Credits
  • Log In
  • Export
  • Tools

  1. Bug SPAGOBI-2359
    Query editor cannot be opened
  2. Bug SPAGOBI-2344
    Error while executing query with calculated fied defined on SpagoBI Meta
  3. Improvement SPAGOBI-2338
    Definición de funcionalidades de documentos sin necesidad de subir templates
  4. Bug SPAGOBI-2322
    free inquiry smart filtre
  5. Bug SPAGOBI-2295
    SpagoBI studio mapping dimension table
  6. Bug SPAGOBI-2178
    Calculated fields QBE/ERROR
  7. Bug SPAGOBI-2175
    In business models calculations are not working correctly
  8. New Feature SPAGOBI-2166
    As a SpagoBI admin I Want to be able to lock/unlock a model in the Business Model Catalogue
  9. Bug SPAGOBI-2001
    Error in the generation of the OLAP template
  10. Improvement SPAGOBI-1932
    As a SpagoBI Meta User I Want to generate a datamart specific for the Registry component
  11. Bug SPAGOBI-1927
    Problem creating a model: error occurs when I create a query
  12. Bug SPAGOBI-1925
    Can’t create a OLAP schema (if I select the key in a table the generated template is empty)
  13. Bug SPAGOBI-1886
    Catalog with null name throw exception that also prevent schema combo population
  14. Bug SPAGOBI-1790
    Cannot generate Olap Schema if the primary key of a dimension isn't corresponding to a physical primary key
  15. Bug SPAGOBI-1780
    Cannot set hierarchy name for Olap Model
  16. Bug SPAGOBI-1773
    In the calculated fields the operator / doesn't work
  17. Improvement SPAGOBI-1772
    Add the sbimodel into the datamart.jar
  18. Bug SPAGOBI-1536
    SpagoBI Meta: error in generating query from model
  19. Improvement SPAGOBI-1377
    SpagoBIStudio should retrieve the description of the entities from the database, if available
  20. Bug SPAGOBI-1329
    Cannot save metamodel when a Business Class set as Dimension (in relation with a cube) is changed to Business View
  21. Bug SPAGOBI-1262
    If in the business model there are tables without relationships the relationships.json file could be generated in a wrong way
  22. Bug SPAGOBI-1197
    The model is not refereshed in the engine
  23. Improvement SPAGOBI-1139
    Add entire libs/jdbc to plugin.xml of /it.eng.spagobi.meta.queryengine
  24. Improvement SPAGOBI-1112
    calculated fields fuctions - META
  25. Bug SPAGOBI-1062
    Error in generating datamart.jar for model ...
  26. Improvement SPAGOBI-1060
    As a SpagoBI user i want that the datamart generated with SpagoBI Meta/Studio could be used with the Registry to update or insert records
  27. Bug SPAGOBI-1051
    Cannot change property of Business Model root (ex. Package Name)
  28. Bug SPAGOBI-1048
    The ' (quote) char causes problems on properties view tab
  29. Bug SPAGOBI-1036
    Error creating the jpa classes
  30. Bug SPAGOBI-1011
    Business model for SqlServer fails on server
  31. Bug SPAGOBI-895
    Empty columns panel (of target table) when creating a new relationship
  32. Bug SPAGOBI-894
    Incorrect labels.properties generation used by the QBE
  33. Bug SPAGOBI-862
    bad formed sql query in Spagobi Studio 3.4 (postgresql DB)
  34. Bug SPAGOBI-843
    Error generation views.json (wrong name for the columns in the relationships specification)
  35. Bug SPAGOBI-832
    META is unable to create the model when the name of one table or one column of the original schema is equal to a java resereved word (ex class, public, ecc ...)
  36. Bug SPAGOBI-831
    The jpa generator is unable to produce the mapping when in the schema there are tables whose names differ only for some underscore chars or when in a table there are columns whose names differ only for some underscore chars
  37. Improvement SPAGOBI-830
    Changed terms "Income" and "Outcome" to "Inbound" and "Outbound" relationships in contextual menu
  38. Bug SPAGOBI-829
    Query on Business Class (composed) use cartesian product and not the specified join path.
  39. Bug SPAGOBI-827
    Names defined in business model for sub-entities are not ported properly to the query-editor/qbe
  40. Bug SPAGOBI-826
    When adding a single column to an already existing business view, taken from a physical table that is not part of the view, all the columns of of the physical table are added to the view and not only the one really selected
  41. Bug SPAGOBI-825
    A compilation errror is thrown during mapping generation if more than one outbound relationship is created on the same busines column
  42. Bug SPAGOBI-824
    Property panel is not refreshed properly when moving within a business view from one column to another column whose associated physical columns have the same names
  43. Improvement SPAGOBI-800
    As SpagoBI Meta user I want that the query editor uses the same JDBC driver used by the ODA connection from which the metamodel has been generated
  44. Bug SPAGOBI-790
    META is unable to create a metamodel from an Infobright schema
  45. Bug SPAGOBI-789
    If the sbimodel file is malformed it cannot be deleted from SpagoBI Resource View
  46. Bug SPAGOBI-729
    MS SQL SERVER SQL. SQL quoted identifiers
  47. Bug SPAGOBI-718
    Postgre SQL. Error in catalog double quotes
  48. Bug SPAGOBI-717
    Query editor on metamodel does not open
  49. New Requirement SPAGOBI-707
    Derived business model
  50. Improvement SPAGOBI-706
    Model Validation
Refresh results
[{"value":"affectedVersion","displayName":"affectedVersion","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.project.version.Version"]},{"value":"assignee","displayName":"assignee","auto":"true","orderable":"true","searchable":"true","operators":["not in","is not","changed","is","was not in","=","was in","!=","was not","was","in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"attachments","displayName":"attachments","searchable":"true","operators":["is","is not"],"types":["com.atlassian.jira.issue.attachment.Attachment"]},{"value":"\"Bug type\"","displayName":"Bug type - cf[10020]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10020]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"category","displayName":"category","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.ProjectCategory"]},{"value":"comment","displayName":"comment","searchable":"true","operators":["~","!~"],"types":["java.lang.String"]},{"value":"component","displayName":"component","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"created","displayName":"created","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"createdDate","displayName":"createdDate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"creator","displayName":"creator","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"description","displayName":"description","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"due","displayName":"due","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"duedate","displayName":"duedate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"environment","displayName":"environment","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Colour\"","displayName":"Epic Colour - cf[10129]","orderable":"true","searchable":"true","cfid":"cf[10129]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Link\"","displayName":"Epic Link - cf[10126]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10126]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Epic Name\"","displayName":"Epic Name - cf[10127]","orderable":"true","searchable":"true","cfid":"cf[10127]","operators":["~","!~","=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Status\"","displayName":"Epic Status - cf[10128]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10128]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"filter","displayName":"filter","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"fixVersion","displayName":"fixVersion","auto":"true","orderable":"true","searchable":"true","operators":["not in","is not","<","=","was not","changed","is",">=","was not in",">","was in","!=","was","<=","in"],"types":["com.atlassian.jira.project.version.Version"]},{"value":"Flagged","displayName":"Flagged - cf[10120]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10120]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"id","displayName":"id","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issue","displayName":"issue","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issue.property","displayName":"issue.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.Number","java.lang.String","java.util.Date"]},{"value":"issuekey","displayName":"issuekey","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issuetype","displayName":"issuetype","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"key","displayName":"key","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"labels","displayName":"labels","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"lastViewed","displayName":"lastViewed","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"level","displayName":"level","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.security.IssueSecurityLevel"]},{"value":"originalEstimate","displayName":"originalEstimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"parent","displayName":"parent","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"priority","displayName":"priority","auto":"true","orderable":"true","searchable":"true","operators":["not in","is not","<","=","was not","changed","is",">=","was not in",">","was in","!=","was","<=","in"],"types":["com.atlassian.jira.issue.priority.Priority"]},{"value":"progress","displayName":"progress","orderable":"true","operators":[],"types":["java.lang.Object"]},{"value":"project","displayName":"project","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.Project"]},{"value":"\"Rank (Obsolete)\"","displayName":"Rank (Obsolete) - cf[10124]","orderable":"true","searchable":"true","cfid":"cf[10124]","operators":["is","is not"],"types":["java.lang.Number"]},{"value":"Rank","displayName":"Rank - cf[10220]","orderable":"true","searchable":"true","cfid":"cf[10220]","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.String"]},{"value":"\"Release Version History\"","displayName":"Release Version History - cf[10130]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10130]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.project.version.Version"]},{"value":"remainingEstimate","displayName":"remainingEstimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"reporter","displayName":"reporter","auto":"true","orderable":"true","searchable":"true","operators":["not in","is not","changed","is","was not in","=","was in","!=","was not","was","in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"request","displayName":"request","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"resolution","displayName":"resolution","auto":"true","orderable":"true","searchable":"true","operators":["not in","is not","<","=","was not","changed","is",">=","was not in",">","was in","!=","was","<=","in"],"types":["com.atlassian.jira.issue.resolution.Resolution"]},{"value":"resolutiondate","displayName":"resolutiondate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"resolved","displayName":"resolved","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"savedfilter","displayName":"savedfilter","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"searchrequest","displayName":"searchrequest","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"Sprint","displayName":"Sprint - cf[10125]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10125]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"status","displayName":"status","auto":"true","orderable":"true","searchable":"true","operators":["not in","is not","changed","is","was not in","=","was in","!=","was not","was","in"],"types":["com.atlassian.jira.issue.status.Status"]},{"value":"statusCategory","displayName":"statusCategory","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.status.category.StatusCategory"]},{"value":"\"Story Points\"","displayName":"Story Points - cf[10320]","orderable":"true","searchable":"true","cfid":"cf[10320]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"subtasks","displayName":"subtasks","orderable":"true","operators":[],"types":["java.lang.Object"]},{"value":"summary","displayName":"summary","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"text","displayName":"text","searchable":"true","operators":["~"],"types":["java.lang.String"]},{"value":"timeestimate","displayName":"timeestimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"timeoriginalestimate","displayName":"timeoriginalestimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"timespent","displayName":"timespent","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"type","displayName":"type","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"updated","displayName":"updated","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"updatedDate","displayName":"updatedDate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"voter","displayName":"voter","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"votes","displayName":"votes","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"watcher","displayName":"watcher","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"watchers","displayName":"watchers","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"worklogAuthor","displayName":"worklogAuthor","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"worklogComment","displayName":"worklogComment","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"worklogDate","displayName":"worklogDate","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.util.Date"]},{"value":"workratio","displayName":"workratio","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]}]
[{"value":"cascadeOption(\"\")","displayName":"cascadeOption(\"\")","isList":"true","types":["com.atlassian.jira.issue.customfields.option.CascadingOption"]},{"value":"closedSprints()","displayName":"closedSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"componentsLeadByUser()","displayName":"componentsLeadByUser()","isList":"true","types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"currentLogin()","displayName":"currentLogin()","types":["java.util.Date"]},{"value":"earliestUnreleasedVersion()","displayName":"earliestUnreleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"endOfDay()","displayName":"endOfDay()","types":["java.util.Date"]},{"value":"endOfMonth()","displayName":"endOfMonth()","types":["java.util.Date"]},{"value":"endOfWeek()","displayName":"endOfWeek()","types":["java.util.Date"]},{"value":"endOfYear()","displayName":"endOfYear()","types":["java.util.Date"]},{"value":"futureSprints()","displayName":"futureSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"issueHistory()","displayName":"issueHistory()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithRemoteLinksByGlobalId(\"\")","displayName":"issuesWithRemoteLinksByGlobalId(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"lastLogin()","displayName":"lastLogin()","types":["java.util.Date"]},{"value":"latestReleasedVersion()","displayName":"latestReleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"linkedIssues(\"\")","displayName":"linkedIssues(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"membersOf(\"\")","displayName":"membersOf(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"now()","displayName":"now()","types":["java.util.Date"]},{"value":"openSprints()","displayName":"openSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"projectsLeadByUser()","displayName":"projectsLeadByUser()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsWhereUserHasPermission(\"\")","displayName":"projectsWhereUserHasPermission(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsWhereUserHasRole(\"\")","displayName":"projectsWhereUserHasRole(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"releasedVersions()","displayName":"releasedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"standardIssueTypes()","displayName":"standardIssueTypes()","isList":"true","types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"startOfDay()","displayName":"startOfDay()","types":["java.util.Date"]},{"value":"startOfMonth()","displayName":"startOfMonth()","types":["java.util.Date"]},{"value":"startOfWeek()","displayName":"startOfWeek()","types":["java.util.Date"]},{"value":"startOfYear()","displayName":"startOfYear()","types":["java.util.Date"]},{"value":"subTaskIssueTypes()","displayName":"subTaskIssueTypes()","isList":"true","types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"svnAuthor(\"\")","displayName":"svnAuthor(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"svnComment(\"\")","displayName":"svnComment(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"svnCommitDateRange()","displayName":"svnCommitDateRange()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"svnCommitNumberRange(\"\")","displayName":"svnCommitNumberRange(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"svnItem(\"\")","displayName":"svnItem(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"svnMultiAuthor(\"\")","displayName":"svnMultiAuthor(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"svnMultiCommit(\"\")","displayName":"svnMultiCommit(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"svnMultiProject(\"\")","displayName":"svnMultiProject(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"svnMultiRepository(\"\")","displayName":"svnMultiRepository(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"unreleasedVersions()","displayName":"unreleasedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"votedIssues()","displayName":"votedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"watchedIssues()","displayName":"watchedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]}]
["explain","select","isnull","commit","isempty","when","rowid","output","number","character","identified","sqrt","delimiter","else","exclusive","lock","catch","join","strict","greater","if","between","order","having","in","byte","double","subtract","outer","index","raw","is","then","execute","input","as","defaults","field","size","left","unique","difference","returns","begin","modulo","object","trans","minus","access","increment","sum","long","into","uid","current","default","file","goto","min","audit","by","share","where","after","power","escape","connect","noaudit","table","validate","cf","set","break","initial","max","more","column","right","trigger","union","asc","rename","decrement","equals","fetch","char","exists","notin","to","first","return","transaction","checkpoint","date","privileges","declare","before","do","integer","float","while","empty","mode","view","whenever","prior","continue","function","intersection","limit","raise","create","from","collation","alter","group","add","all","last","like","resource","count","check","less","encoding","inner","rownum","collate","null","abort","immediate","true","decimal","exec","nowait","changed","desc","option","drop","next","string","session","values","for","distinct","insert","revoke","update","delete","not","synonym","avg","public","and","of","define","alias","divide","end","row","multiply","on","or","intersect","previous","false","go","start","was","rows","any","int","modify","with","inout","boolean","grant","remainder","user"]
{"searchers":{"groups":[{"searchers":[{"name":"Project","id":"project","key":"issue.field.project","isShown":true,"lastViewed":1653662792964},{"name":"Summary","id":"summary","key":"issue.field.summary","isShown":true},{"name":"Type","id":"issuetype","key":"issue.field.issuetype","isShown":true,"lastViewed":1653662792966},{"name":"Status","id":"status","key":"issue.field.status","isShown":true,"lastViewed":1653662792972},{"name":"Priority","id":"priority","key":"issue.field.priority","isShown":true},{"name":"Resolution","id":"resolution","key":"issue.field.resolution","isShown":true},{"name":"Creator","id":"creator","key":"issue.field.creator","isShown":true},{"name":"Affects Version","id":"version","key":"issue.field.affectsversions","isShown":true},{"name":"Fix Version","id":"fixfor","key":"issue.field.fixversions","isShown":true},{"name":"Component","id":"component","key":"issue.field.components","isShown":true,"lastViewed":1653662792976},{"name":"% Limits","id":"workratio","key":"issue.field.workratio","isShown":true},{"name":"Environment","id":"environment","key":"issue.field.environment","isShown":true},{"name":"Description","id":"description","key":"issue.field.description","isShown":true},{"name":"Comment","id":"comment","key":"issue.field.comment","isShown":true},{"name":"Label","id":"labels","key":"issue.field.labels","isShown":true},{"name":"Query","id":"text","key":"text","isShown":true},{"name":"Bug type","id":"customfield_10020","key":"com.atlassian.jira.plugin.system.customfieldtypes:select","isShown":false},{"name":"Epic Colour","id":"customfield_10129","key":"com.pyxis.greenhopper.jira:gh-epic-color","isShown":false},{"name":"Epic Link","id":"customfield_10126","key":"com.pyxis.greenhopper.jira:gh-epic-link","isShown":true},{"name":"Epic Name","id":"customfield_10127","key":"com.pyxis.greenhopper.jira:gh-epic-label","isShown":true},{"name":"Epic Status","id":"customfield_10128","key":"com.pyxis.greenhopper.jira:gh-epic-status","isShown":false},{"name":"Flagged","id":"customfield_10120","key":"com.atlassian.jira.plugin.system.customfieldtypes:multicheckboxes","isShown":true},{"name":"Rank","id":"customfield_10220","key":"com.pyxis.greenhopper.jira:gh-lexo-rank","isShown":true},{"name":"Rank (Obsolete)","id":"customfield_10124","key":"com.pyxis.greenhopper.jira:gh-global-rank","isShown":true},{"name":"Release Version History","id":"customfield_10130","key":"com.pyxis.greenhopper.jira:greenhopper-releasedmultiversionhistory","isShown":true},{"name":"Sprint","id":"customfield_10125","key":"com.pyxis.greenhopper.jira:gh-sprint","isShown":true},{"name":"Story Points","id":"customfield_10320","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false}],"type":"DETAILS","title":"Details"},{"searchers":[{"name":"Created Date","id":"created","key":"issue.field.created","isShown":true},{"name":"Updated Date","id":"updated","key":"issue.field.updated","isShown":true},{"name":"Resolution Date","id":"resolutiondate","key":"issue.field.resolution.date","isShown":true},{"name":"Due Date","id":"duedate","key":"issue.field.duedate","isShown":true}],"type":"DATES","title":"Dates"},{"searchers":[{"name":"Assignee","id":"assignee","key":"issue.field.assignee","isShown":true,"lastViewed":1653662792974},{"name":"Reporter","id":"reporter","key":"issue.field.reporter","isShown":true}],"type":"PEOPLE","title":"People"}]},"values":{"issuetype":{"name":"Type","editHtml":"\n\n\n\n <div class=\"field-group aui-field-issuetype\" >\n <label for=\"searcher-type\">Type</label>\n <select class=\"select js-default-checkboxmultiselect\" id=\"searcher-type\" multiple=\"multiple\" name=\"type\"\n data-placeholder-text=\"Find Issue Types...\" size=\"5\">\n <optgroup>\n \n <option class=\" \"\n id=\"type_-2\"\n title=\"All Standard Issue Types\"\n value=\"-2\">All Standard Issue Types</option>\n \n <option class=\" \"\n id=\"type_-3\"\n title=\"All Sub-Task Issue Types\"\n value=\"-3\">All Sub-Task Issue Types</option>\n </optgroup>\n\n <optgroup label=\"Standard Issue Types\">\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/jira/secure/viewavatar?size=xsmall&amp;avatarId=11523&amp;avatarType=issuetype\"\n data-fallback-icon=\"/jira/images/icons/issuetypes/blank.png\"\n id=\"type_1\"\n title=\"Bug\"\n value=\"1\">Bug</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/jira/secure/viewavatar?size=xsmall&amp;avatarId=11527&amp;avatarType=issuetype\"\n data-fallback-icon=\"/jira/images/icons/issuetypes/blank.png\"\n id=\"type_7\"\n title=\"Epic\"\n value=\"7\">Epic</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/jira/secure/viewavatar?size=xsmall&amp;avatarId=11530&amp;avatarType=issuetype\"\n data-fallback-icon=\"/jira/images/icons/issuetypes/blank.png\"\n id=\"type_4\"\n title=\"Improvement\"\n value=\"4\">Improvement</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/jira/secure/viewavatar?size=xsmall&amp;avatarId=11531&amp;avatarType=issuetype\"\n data-fallback-icon=\"/jira/images/icons/issuetypes/blank.png\"\n id=\"type_2\"\n title=\"New Feature\"\n value=\"2\">New Feature</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/jira/secure/viewavatar?size=xsmall&amp;avatarId=11535&amp;avatarType=issuetype\"\n data-fallback-icon=\"/jira/images/icons/issuetypes/blank.png\"\n id=\"type_5\"\n title=\"New Requirement\"\n value=\"5\">New Requirement</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/jira/secure/viewavatar?size=xsmall&amp;avatarId=11535&amp;avatarType=issuetype\"\n data-fallback-icon=\"/jira/images/icons/issuetypes/blank.png\"\n id=\"type_10000\"\n title=\"Story\"\n value=\"10000\">Story</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/jira/secure/viewavatar?size=xsmall&amp;avatarId=11538&amp;avatarType=issuetype\"\n data-fallback-icon=\"/jira/images/icons/issuetypes/blank.png\"\n id=\"type_3\"\n title=\"Task\"\n value=\"3\">Task</option>\n </optgroup>\n\n <optgroup label=\"Sub-Task Issue Types\">\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/jira/secure/viewavatar?size=xsmall&amp;avatarId=11536&amp;avatarType=issuetype\"\n data-fallback-icon=\"/jira/images/icons/issuetypes/blank.png\"\n id=\"type_6\"\n title=\"Sub-task\"\n value=\"6\">Sub-task</option>\n </optgroup>\n </select>\n </div>\n ","validSearcher":true,"isShown":true},"component":{"name":"Component","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldcomponent\">Component:</label><span id=\"fieldcomponent\" class=\"fieldValue\">\n \n META </span></div>\n","editHtml":"\n <div class=\"field-group aui-field-projectconstant\" >\n <label for=\"searcher-component\">Component</label>\n <select class=\"select js-default-checkboxmultiselect\" id=\"searcher-component\" multiple=\"multiple\" name=\"component\" size=\"2\">\n <optgroup label=\"\">\n <option value=\"-1\" title=\"No Component\">No Component</option>\n </optgroup>\n <optgroup label=\"\">\n <option selected=\"selected\" value=\"id:META\" title=\"META\">META</option>\n <option value=\"id:SERVER/AdHoc/Qbe\" title=\"SERVER/AdHoc/Qbe\">SERVER/AdHoc/Qbe</option>\n <option value=\"id:SERVER/AdHoc/Registry\" title=\"SERVER/AdHoc/Registry\">SERVER/AdHoc/Registry</option>\n <option value=\"id:SERVER/AdHoc/SmartFilter\" title=\"SERVER/AdHoc/SmartFilter\">SERVER/AdHoc/SmartFilter</option>\n <option value=\"id:SERVER/AdHoc/Worksheet\" title=\"SERVER/AdHoc/Worksheet\">SERVER/AdHoc/Worksheet</option>\n <option value=\"id:SERVER/Chart\" title=\"SERVER/Chart\">SERVER/Chart</option>\n <option value=\"id:SERVER/Cockpit/Cockpit\" title=\"SERVER/Cockpit/Cockpit\">SERVER/Cockpit/Cockpit</option>\n <option value=\"id:SERVER/Cockpit/Composed\" title=\"SERVER/Cockpit/Composed\">SERVER/Cockpit/Composed</option>\n <option value=\"id:SERVER/Cockpit/Console\" title=\"SERVER/Cockpit/Console\">SERVER/Cockpit/Console</option>\n <option value=\"id:SERVER/Collaboration/Dossier\" title=\"SERVER/Collaboration/Dossier\">SERVER/Collaboration/Dossier</option>\n <option value=\"id:SERVER/Core\" title=\"SERVER/Core\">SERVER/Core</option>\n <option value=\"id:SERVER/Database\" title=\"SERVER/Database\">SERVER/Database</option>\n <option value=\"id:SERVER/Datamining/R\" title=\"SERVER/Datamining/R\">SERVER/Datamining/R</option>\n <option value=\"id:SERVER/Datamining/Weka\" title=\"SERVER/Datamining/Weka\">SERVER/Datamining/Weka</option>\n <option value=\"id:SERVER/Demo\" title=\"SERVER/Demo\">SERVER/Demo</option>\n <option value=\"id:SERVER/Documentation\" title=\"SERVER/Documentation\">SERVER/Documentation</option>\n <option value=\"id:SERVER/Etl/Talend\" title=\"SERVER/Etl/Talend\">SERVER/Etl/Talend</option>\n <option value=\"id:SERVER/Geo/GeoReport\" title=\"SERVER/Geo/GeoReport\">SERVER/Geo/GeoReport</option>\n <option value=\"id:SERVER/Geo/MapReport\" title=\"SERVER/Geo/MapReport\">SERVER/Geo/MapReport</option>\n <option value=\"id:SERVER/ImportExport\" title=\"SERVER/ImportExport\">SERVER/ImportExport</option>\n <option value=\"id:SERVER/Installer\" title=\"SERVER/Installer\">SERVER/Installer</option>\n <option value=\"id:SERVER/Kpi\" title=\"SERVER/Kpi\">SERVER/Kpi</option>\n <option value=\"id:SERVER/Mobile\" title=\"SERVER/Mobile\">SERVER/Mobile</option>\n <option value=\"id:SERVER/Network\" title=\"SERVER/Network\">SERVER/Network</option>\n <option value=\"id:SERVER/OLAP/JPalo\" title=\"SERVER/OLAP/JPalo\">SERVER/OLAP/JPalo</option>\n <option value=\"id:SERVER/OLAP/JPivot\" title=\"SERVER/OLAP/JPivot\">SERVER/OLAP/JPivot</option>\n <option value=\"id:SERVER/OLAP/WhatIf\" title=\"SERVER/OLAP/WhatIf\">SERVER/OLAP/WhatIf</option>\n <option value=\"id:SERVER/Olap/Xmla\" title=\"SERVER/Olap/Xmla\">SERVER/Olap/Xmla</option>\n <option value=\"id:SERVER/Reporting/Accessible\" title=\"SERVER/Reporting/Accessible\">SERVER/Reporting/Accessible</option>\n <option value=\"id:SERVER/Reporting/BIRT\" title=\"SERVER/Reporting/BIRT\">SERVER/Reporting/BIRT</option>\n <option value=\"id:SERVER/Reporting/BIRT/ODA plugin\" title=\"SERVER/Reporting/BIRT/ODA plugin\">SERVER/Reporting/BIRT/ODA plugin</option>\n <option value=\"id:SERVER/Reporting/BO\" title=\"SERVER/Reporting/BO\">SERVER/Reporting/BO</option>\n <option value=\"id:SERVER/Reporting/Jasper\" title=\"SERVER/Reporting/Jasper\">SERVER/Reporting/Jasper</option>\n <option value=\"id:SERVER/Reporting/Jasper/Plugin\" title=\"SERVER/Reporting/Jasper/Plugin\">SERVER/Reporting/Jasper/Plugin</option>\n <option value=\"id:SERVER/SDK/JS-api\" title=\"SERVER/SDK/JS-api\">SERVER/SDK/JS-api</option>\n <option value=\"id:SERVER/SDK/Web-services\" title=\"SERVER/SDK/Web-services\">SERVER/SDK/Web-services</option>\n <option value=\"id:SERVER/SocialNetworksAnalysis\" title=\"SERVER/SocialNetworksAnalysis\">SERVER/SocialNetworksAnalysis</option>\n <option value=\"id:STUDIO\" title=\"STUDIO\">STUDIO</option>\n <option value=\"id:UTILITIES\" title=\"UTILITIES\">UTILITIES</option>\n <option value=\"id:whatif\" title=\"whatif\">whatif</option>\n </optgroup>\n </select>\n </div>\n ","jql":"component = META","validSearcher":true,"isShown":true},"project":{"name":"Project","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldpid\">Project:</label><span id=\"fieldpid\" class=\"fieldValue\">\n \n <a href=\"/jira/browse/SPAGOBI\" title=\"Browse SpagoBI project\">SpagoBI</a> </span></div>\n","editHtml":"\n <div class=\"field-group aui-field-project\" >\n <label for=\"searcher-pid\">Project</label>\n \n\n <select class=\"select js-default-checkboxmultiselect\" data-placeholder-text=\"Find Projects...\" id=\"searcher-pid\" multiple=\"multiple\" name=\"pid\" size=\"4\">\n <optgroup label=\"All Projects\">\n \n <option data-icon=\"/jira/secure/projectavatar?pid=10010&size=small\"\n title=\"Spagic\"\n value=\"10010\">\n Spagic (SPAGIC)\n </option>\n \n <option data-icon=\"/jira/secure/projectavatar?pid=10000&size=small\"\n title=\"Spago\"\n value=\"10000\">\n Spago (SPAGO)\n </option>\n \n <option data-icon=\"/jira/secure/projectavatar?pid=10001&size=small\"\n selected=\"selected\" title=\"SpagoBI\"\n value=\"10001\">\n SpagoBI (SPAGOBI)\n </option>\n </optgroup>\n </select>\n </div>\n \n","jql":"project = SPAGOBI","validSearcher":true,"isShown":true},"assignee":{"name":"Assignee","editHtml":"\n \n <div class=\"field-group aui-field-userlist\" >\n <label for=\"searcher-assigneeSelect\">Assignee</label>\n <fieldset rel=\"assignee\" class=\"hidden user-group-searcher-params\">\n </fieldset>\n <select class=\"js-usergroup-checkboxmultiselect\" multiple=\"multiple\" id=\"assignee\" name=\"assignee\" data-placeholder-text=\"Enter username or group\">\n <optgroup>\n <option class=\"headerOption\" data-icon=\"https://www.spagoworld.org/jira/secure/useravatar?size=xsmall&avatarId=10143\" value=\"empty\" title=\"Unassigned\">Unassigned</option>\n </optgroup>\n <optgroup>\n </optgroup>\n </select>\n <input type=\"hidden\" name=\"check_prev_assignee\" value=\"true\">\n </div>\n \n","validSearcher":true,"isShown":true},"status":{"name":"Status","editHtml":"\n <div class=\"field-group aui-field-constants\" >\n <label for=\"searcher-status\">Status</label>\n \n <select class=\"select js-default-checkboxmultiselectstatuslozenge\" data-placeholder-text=\"Find Statuses...\" id=\"searcher-status\" multiple=\"multiple\" name=\"status\" size=\"4\" data-status-lozenge=\"true\">\n <option class=\"imagebacked\" data-icon=\"/jira/images/icons/statuses/open.png\" value=\"1\" title=\"Open\" data-simple-status=\"{&quot;id&quot;:&quot;1&quot;,&quot;name&quot;:&quot;Open&quot;,&quot;description&quot;:&quot;The issue is open and ready for the assignee to start work on it.&quot;,&quot;iconUrl&quot;:&quot;/jira/images/icons/statuses/open.png&quot;,&quot;statusCategory&quot;:{&quot;id&quot;:2,&quot;key&quot;:&quot;new&quot;,&quot;colorName&quot;:&quot;blue-gray&quot;}}\">Open</option>\n <option class=\"imagebacked\" data-icon=\"/jira/images/icons/statuses/inprogress.png\" value=\"3\" title=\"In Progress\" data-simple-status=\"{&quot;id&quot;:&quot;3&quot;,&quot;name&quot;:&quot;In Progress&quot;,&quot;description&quot;:&quot;This issue is being actively worked on at the moment by the assignee.&quot;,&quot;iconUrl&quot;:&quot;/jira/images/icons/statuses/inprogress.png&quot;,&quot;statusCategory&quot;:{&quot;id&quot;:4,&quot;key&quot;:&quot;indeterminate&quot;,&quot;colorName&quot;:&quot;yellow&quot;}}\">In Progress</option>\n <option class=\"imagebacked\" data-icon=\"/jira/images/icons/statuses/reopened.png\" value=\"4\" title=\"Reopened\" data-simple-status=\"{&quot;id&quot;:&quot;4&quot;,&quot;name&quot;:&quot;Reopened&quot;,&quot;description&quot;:&quot;This issue was once resolved, but the resolution was deemed incorrect. From here issues are either marked assigned or resolved.&quot;,&quot;iconUrl&quot;:&quot;/jira/images/icons/statuses/reopened.png&quot;,&quot;statusCategory&quot;:{&quot;id&quot;:2,&quot;key&quot;:&quot;new&quot;,&quot;colorName&quot;:&quot;blue-gray&quot;}}\">Reopened</option>\n <option class=\"imagebacked\" data-icon=\"/jira/images/icons/statuses/resolved.png\" value=\"5\" title=\"Resolved\" data-simple-status=\"{&quot;id&quot;:&quot;5&quot;,&quot;name&quot;:&quot;Resolved&quot;,&quot;description&quot;:&quot;A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.&quot;,&quot;iconUrl&quot;:&quot;/jira/images/icons/statuses/resolved.png&quot;,&quot;statusCategory&quot;:{&quot;id&quot;:3,&quot;key&quot;:&quot;done&quot;,&quot;colorName&quot;:&quot;green&quot;}}\">Resolved</option>\n <option class=\"imagebacked\" data-icon=\"/jira/images/icons/statuses/closed.png\" value=\"6\" title=\"Closed\" data-simple-status=\"{&quot;id&quot;:&quot;6&quot;,&quot;name&quot;:&quot;Closed&quot;,&quot;description&quot;:&quot;The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.&quot;,&quot;iconUrl&quot;:&quot;/jira/images/icons/statuses/closed.png&quot;,&quot;statusCategory&quot;:{&quot;id&quot;:3,&quot;key&quot;:&quot;done&quot;,&quot;colorName&quot;:&quot;green&quot;}}\">Closed</option>\n </select>\n </div>\n \n","validSearcher":true,"isShown":true}}}
[{"id":-1,"name":"My open issues","jql":"assignee = currentUser() AND resolution = Unresolved order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-2,"name":"Reported by me","jql":"reporter = currentUser() order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-4,"name":"All issues","jql":"order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-5,"name":"Open issues","jql":"resolution = Unresolved order by priority DESC,updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-9,"name":"Done issues","jql":"statusCategory = Done order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-3,"name":"Viewed recently","jql":"issuekey in issueHistory() order by lastViewed DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-6,"name":"Created recently","jql":"created >= -1w order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-7,"name":"Resolved recently","jql":"resolutiondate >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-8,"name":"Updated recently","jql":"updated >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false}]
  • Atlassian JIRA Project Management Software (v7.2.2#72004-sha1:9d51328)
  • About JIRA
  • Report a problem
  • Powered by a free Atlassian JIRA open source license for Spago - SpagoBI - Spagic. Try JIRA - bug tracking software for your team.
Atlassian