SPAGOBI-2359
Query editor cannot be opened
Error while executing query with calculated fied defined on SpagoBI MetaSPAGOBI-2338
Definición de funcionalidades de documentos sin necesidad de subir templates
free inquiry smart filtre
SpagoBI studio mapping dimension table
Calculated fields QBE/ERROR
In business models calculations are not working correctlySPAGOBI-2166
As a SpagoBI admin I Want to be able to lock/unlock a model in the Business Model Catalogue
Error in the generation of the OLAP template
As a SpagoBI Meta User I Want to generate a datamart specific for the Registry component
Problem creating a model: error occurs when I create a query
Can’t create a OLAP schema (if I select the key in a table the generated template is empty)
Catalog with null name throw exception that also prevent schema combo population
Cannot generate Olap Schema if the primary key of a dimension isn't corresponding to a physical primary key
Cannot set hierarchy name for Olap Model
In the calculated fields the operator / doesn't work
Add the sbimodel into the datamart.jar
SpagoBI Meta: error in generating query from model
SpagoBIStudio should retrieve the description of the entities from the database, if available
Cannot save metamodel when a Business Class set as Dimension (in relation with a cube) is changed to Business View
If in the business model there are tables without relationships the relationships.json file could be generated in a wrong way
The model is not refereshed in the engine
Add entire libs/jdbc to plugin.xml of /it.eng.spagobi.meta.queryengine
calculated fields fuctions - META
Error in generating datamart.jar for model ...
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
Cannot change property of Business Model root (ex. Package Name)
The ' (quote) char causes problems on properties view tab
Error creating the jpa classes
Business model for SqlServer fails on server
Empty columns panel (of target table) when creating a new relationship
Incorrect labels.properties generation used by the QBE
bad formed sql query in Spagobi Studio 3.4 (postgresql DB)
Error generation views.json (wrong name for the columns in the relationships specification)
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 ...)
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
Changed terms "Income" and "Outcome" to "Inbound" and "Outbound" relationships in contextual menu
Query on Business Class (composed) use cartesian product and not the specified join path.
Names defined in business model for sub-entities are not ported properly to the query-editor/qbe
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
A compilation errror is thrown during mapping generation if more than one outbound relationship is created on the same busines column
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
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
META is unable to create a metamodel from an Infobright schema
If the sbimodel file is malformed it cannot be deleted from SpagoBI Resource View
MS SQL SERVER SQL. SQL quoted identifiers
Postgre SQL. Error in catalog double quotes
Query editor on metamodel does not openSPAGOBI-707
Derived business model
Model Validation
[{"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&avatarId=11523&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&avatarId=11527&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&avatarId=11530&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&avatarId=11531&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&avatarId=11535&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&avatarId=11535&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&avatarId=11538&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&avatarId=11536&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=\"{"id":"1","name":"Open","description":"The issue is open and ready for the assignee to start work on it.","iconUrl":"/jira/images/icons/statuses/open.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">Open</option>\n <option class=\"imagebacked\" data-icon=\"/jira/images/icons/statuses/inprogress.png\" value=\"3\" title=\"In Progress\" data-simple-status=\"{"id":"3","name":"In Progress","description":"This issue is being actively worked on at the moment by the assignee.","iconUrl":"/jira/images/icons/statuses/inprogress.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">In Progress</option>\n <option class=\"imagebacked\" data-icon=\"/jira/images/icons/statuses/reopened.png\" value=\"4\" title=\"Reopened\" data-simple-status=\"{"id":"4","name":"Reopened","description":"This issue was once resolved, but the resolution was deemed incorrect. From here issues are either marked assigned or resolved.","iconUrl":"/jira/images/icons/statuses/reopened.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">Reopened</option>\n <option class=\"imagebacked\" data-icon=\"/jira/images/icons/statuses/resolved.png\" value=\"5\" title=\"Resolved\" data-simple-status=\"{"id":"5","name":"Resolved","description":"A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.","iconUrl":"/jira/images/icons/statuses/resolved.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Resolved</option>\n <option class=\"imagebacked\" data-icon=\"/jira/images/icons/statuses/closed.png\" value=\"6\" title=\"Closed\" data-simple-status=\"{"id":"6","name":"Closed","description":"The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.","iconUrl":"/jira/images/icons/statuses/closed.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">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}]