Export - CSV (All fields)
Export - CSV (Current fields)
- OFFICE-4006
Follow-up to OFFICE-3842 Bessel function - OFFICE-3669
Draft ODF-Next Proposal: XPATH() spreadsheet function - OFFICE-3668
Public Comment: [formula] missing statement about content of covered-table-cell informula - OFFICE-2684
repetitive terms in semantics of LEN - OFFICE-2681
Should openformula evaluators be *required* to support BMP or all Unicode/10646 characters? - OFFICE-2680
Part 2 changes needed to connect Parts 1 and 2 - OFFICE-2675
Public Comment: [office-formula] IMARGUMENT needs improvements - OFFICE-2674
Public Comment: longer-than-expected strings (OpenFormula CD01) - OFFICE-2673
Public Comment: U+0222? (OpenFormula CD01) - OFFICE-2662
Public Comment: [office-formula] incomplete change from B to BINOM.DIST.RANGE - OFFICE-2661
Public Comment: {office-formula]Why is TDIST a "right tail" type? - OFFICE-2660
Public Comment: [office-formula] TINV(0) is not defined - OFFICE-2659
3.8 Reference header added following paragraph - OFFICE-2651
Array Functions - OFFICE-2650
PROB - OFFICE-2649
FDIST - OFFICE-2648
FV - OFFICE-2647
LOGNORMDIST - OFFICE-2645
GAUSS - OFFICE-2644
NEGBINOMDIST - OFFICE-2643
B function inclusive or exclusive? - OFFICE-2641
Redefine ill-defined NUMBERVALUE - OFFICE-2640
ODF 1.2 Part 2 section 4.8 Fails to Say How the Cuboids Are Resolved - OFFICE-2632
ODF 1.2 Part 2 CD01 5.18.72-5.18.75 STDEV* DANGEROUS EXTRA FORMULAS - OFFICE-2631
Do all Day Count Basis values truncate the dates and reverse the order of date 1 and date 2 if needed? - OFFICE-2629
OpenFormula 5.16.18 CONVERT Use of Unit Symbol Prefixes and Case-Sensitivity Unclear - OFFICE-2627
TINV(0) is not defined - OFFICE-2616
5.16.29 EUROCONVERT, update link - OFFICE-2615
5.16.18 CONVERT, what is "slug" - OFFICE-2614
5.13.34 VALUE, typo date example - OFFICE-2613
5.13.25 ISTEXT, typo "f" - OFFICE-2612
5.13.6 COUNT, typo "propogated" - OFFICE-2611
5.12.38 PPMT, typo "a... payments" - OFFICE-2610
5.12.30 NPER, equation layout - OFFICE-2609
5.12.6 COUPDAYBS, typo "athe" - OFFICE-2607
3.8 Reference, duplication - OFFICE-2606
3.6 Error, typo I - OFFICE-2605
3.3 Number, layout of data types - OFFICE-2604
3.3.3 Date and DateTime, duplication - OFFICE-2602
small error in TTEST type=1 - OFFICE-2601
2.3 non-scalar, 2.1.1 typo "." - OFFICE-2588
incomplete change from B to BINOM.DIST.RANGE - OFFICE-2586
SHEET / SHEETS function (5.13.32) cannot be fully implemented as written - OFFICE-2585
Pseudotypes and the return of errors - OFFICE-2568
Figure deleted during creation of CD1 - OFFICE-2567
superfluous chart in part 2 CD1 - OFFICE-2566
ACCRINT needs description - OFFICE-2565
8.3.2 E2.5 is insufficiently clear - OFFICE-2513
8.3.2 Conforming Small Group Evaluator should not require to implement External Named Expressions - OFFICE-2453
1.5 Non-Normative References duplicate Normatives - OFFICE-2452
1.4 Normative Reference: duplicate - OFFICE-2451
1.3 Scope Conflicts with Text - OFFICE-2450
Precisely-represented Integers not differentiated from Imprecise Integers - OFFICE-2449
IMSUM ComplexSequence and Portability - OFFICE-2448
5.7 Byte-Position Text Positions - Deprecated? - OFFICE-2447
5.20.24 TRIM - removes "spaces" but doesn't define "space." TBD asks if more than U+0020? - OFFICE-2443
3.10.9 Criteria - incoherent use of the term criteria - OFFICE-2399
Should requirements on PI? - too vague? - OFFICE-2392
6.5 Traditional Complex Number Notation - error in description - OFFICE-2389
5.17.2 Ceiling - Warning and requirements on saving to OpenFormula format? - OFFICE-2387
5.18.56 PEARSON - OFFICE-2385
5.4.7 Infix Operator "=" - OFFICE-2382
4.11.2, 4.111.3, 4.11.4 - Only examples? - OFFICE-2380
4.9 Reference List and 3.8 Reference List - OFFICE-2379
4.8 References - Additional description or additional rules? - OFFICE-2376
2.3 Non-Scalar Evaluation - Functions that take scalar arguments - OFFICE-2374
3.10.9 Criteria - match where "search-criteria-must-apply-to-whole-cell" is false - description unclear - OFFICE-2373
3.10.9 Criteria A number or logical value. The matching field shall equal the given number. (?) - OFFICE-2372
3.10.7 Database - comments on good practice - delete or note? - OFFICE-2370
3.7 Reference - reference to cell with no value = number 0? - OFFICE-2348
3.10.8 Field - OFFICE-2347
3.9 Array, move conformance requirement to conformance clauses - OFFICE-2346
3.3.1 General - treat as notes? - OFFICE-2345
3.6 Error: Defining error? - OFFICE-2344
3.4 Complex Number - conversion to complex - OFFICE-2343
3.3.3 Date and DateTime - 1900 as leap year - OFFICE-2342
Epoch - how is it meant? - OFFICE-2335
Lack definitions of Complex Number as subtypes of Number and Text (PROPOSE-RESOLVED) - OFFICE-2334
Reference - Rewording needed - OFFICE-2333
OpenFormula makes references to how values are stored in OpenDocument. Not in scope for OpenFormula. - OFFICE-2332
Logical Number material appears under Logical Boolean - OFFICE-2331
OpenFormula 3.1 generally - OFFICE-2329
Consistent definition of "empty cell" - OFFICE-2327
Bit Operation Functions Inadequately Defined - OFFICE-2326
Treat all types equally, i.e., no pseudotypes - OFFICE-2325
Negative and non-integer inputs for BASE and DECIMAL Functions - OFFICE-2324
Definition of RRI function uses both N and P for number of payments - OFFICE-2323
More detail needed for Sheet and Sheets functions - OFFICE-2322
Input Constraints for Arabic Function - OFFICE-2321
Case sensitivity of Base conversions - OFFICE-2320
IM trig functions should take complex numbers as inputs - OFFICE-2312
Consistency check: constraint violations and error values - OFFICE-2311
ZTEST - OFFICE-2310
TDIST - OFFICE-2309
LEGACY.CHITEST - OFFICE-2308
FISHER - OFFICE-2307
BINOMDIST - OFFICE-2300
ZTEST - OFFICE-2299
WEIBULL - OFFICE-2298
TTEST - OFFICE-2297
TRIMMEAN - OFFICE-2296
TDIST - OFFICE-2295
STDEVA - OFFICE-2294
RANK - OFFICE-2293
QUARTILE - OFFICE-2292
PHI - OFFICE-2291
LEGACY.NORMSDIST - OFFICE-2290
INTERCEPT - OFFICE-2289
GCD - OFFICE-2288
GAMMA - OFFICE-2287
BETADIST - OFFICE-2286
FREQUENCY: returns 0 for all bins if no data values given - OFFICE-2285
Incorrect COVAR constraint - OFFICE-2284
Invalid constraints - OFFICE-2272
PRICEMAT: wrong constraints - OFFICE-2271
error in ttest formula - OFFICE-2256
COUNTA - DCOUNTA - Inconsistent definitions of counting? (Does COUNTA exclude logical types?) - OFFICE-2255
Database functions as search functions? - OFFICE-2254
Use of "generally" for database functions - OFFICE-2252
Inconsistency on Hexadecimal numbers - BASE produces Hexadecimal with uppercase only, HEX2DEC "must accept lowercase" - OFFICE-2251
Value requirements - DDB for example - "Must be a positive integer." - OFFICE-2250
Replace "required" and "not required" in all normative text - OFFICE-2249
COUNTBLANK - required to support references as parameters? - OFFICE-2247
Array Functions categorization - OFFICE-2246
PROB: check and specify details - OFFICE-2242
EUROCONVERT: add reference to the European Commission's conversion rates; new rates may appear - OFFICE-2229
VDB: check more detailed explanation - OFFICE-2228
FTEST: does it test the variances, or whether two datasets come from the same population? Is it 2-tailed? - OFFICE-2227
XNPV: more details needed - OFFICE-2225
ISPMT: "amortized investment" is jargon - OFFICE-2224
TBILLEQ: add formula, needs better description - OFFICE-2223
DOLLARDE, DOLLARFR: return Number instead of Currency - OFFICE-2222
DDB: add formula - OFFICE-2221
SYD: add formula and correct method's name - OFFICE-2220
PV: Payment can be omitted if Fv is given - OFFICE-2219
PMT: add constraints and note - OFFICE-2218
DDE: check details of data conversion and cell style - OFFICE-2217
ZTEST: inaccurate description and one-sided vs. two-tailed - OFFICE-2216
Clarify patterns (regular expressions and wildcards) - OFFICE-2212
OpenFormula: Cleanup of Normative References - OFFICE-2210
Section 3.3 calculation settings - OFFICE-2178
Part 2: Move Conformance Section to the Last Numbered Section - OFFICE-2175
Add constraints to CORREL, PEARSON, COVAR, STEYX - OFFICE-2174
Sequence evaluation order in arguments significant for CORREL, PEARSON and others - OFFICE-2170
From Office-662- 'NumberSequence' is not properly defined - OFFICE-2169
From Office-662: 'DateSequence' is undefined. - OFFICE-2166
COUNTA, AVERAGEA, xxxA.... Reword to have consistent treatment of text - OFFICE-2165
Description of MUNIT function contains a typo - OFFICE-2160
Explanation of SHEET incomplete. - OFFICE-2159
BINOMDIST's fourth argument should be logical - OFFICE-2158
Reconciling External References in ODF 1.2 (Part 2) - OFFICE-2073
Public Comment: UNICHAR function (ODF 1.2 Pt 2) - OFFICE-2071
Public Comment: LOWER function (ODF 1.2 Part 2) - OFFICE-2070
Public Comment: Whitespace (ODF 1.2 Pt 2) - OFFICE-2069
Public Comment: Conformance language (ODF 1.2 Part 2) - OFFICE-2059
Resolve potential ambiguity with optionality in leading "=" and "==" - OFFICE-2057
CONVERT lacks SI prefixes for some units - OFFICE-2054
Ensure SI prefix compliance with base2 prefixes - OFFICE-2039
ARABIC definition incomplete - OFFICE-2035
Namespace / Named Expression ambiguity - OFFICE-2033
Table:search-criteria-must-apply-to-whole-cell Setting - OFFICE-2032
6.11.37 PPMT - Test case includes too many arguments, function definition missing - OFFICE-2031
5.12.37 PMT - OFFICE-2030
6.15.59 SUBTOTAL - Fuction definition doesn't mention hidden rows or additional parameters - OFFICE-2029
5.10.21 WEEKNUM - not well defined - OFFICE-2024
B -BINOMDIST duplication - OFFICE-2023
SUMIF and AVERAGEIF functions missing from list of functions in large group - OFFICE-2022
Section 5.8 (References) doesn't explicitly state how 3D range references handle sheets positioned between the worksheets named in the reference - OFFICE-2021
Notes in 6.14.5 IFNA - OFFICE-2020
Multiple versions of the standard normal density function - OFFICE-2019
6.17.32 GAUSS does not make sense - OFFICE-2018
PERMUTATIONA specification - OFFICE-2017
6.15.16 COMBINA incorrect argument type - OFFICE-2015
PHI needs work for a more detailed definition - OFFICE-2006
CEILING and FLOOR: allow 2nd parameter to be missing - OFFICE-1998
Clarify date "basis" value - OFFICE-1911
Public Comment: [office-formula] Problems in evaluating MULTIPLE.OPERATIONS - OFFICE-1898
CHAR and CODE are inconsistent - OFFICE-1895
RIGHTB and friends is incompletely specified - OFFICE-1894
CSC is listed twice in the large group - OFFICE-1893
FISHER is just ATANH - OFFICE-1874
Description of Roundup is confusing - OFFICE-1505
<table:null-date> definition - OFFICE-1500
Public Comment: [office-formula] Error in description of CONFIDENCE - OFFICE-1469
Public Comment: [office-formula] Domain problems with exponential operator and functionPOWER - OFFICE-1207
Public Comment: [office-formula] domain for x in HYPGEOMDIST(x;n;M;N) - OFFICE-1206
Public Comment: [office-formula] domain for x in HYPGEOMDIST(x;n;M;N) - OFFICE-1196
Public Comment: Re: [office-comment] [office-formula] SUMIF and behavior of empty cells in reference ranges - OFFICE-1194
Public Comment: [office-formula] SUMIF and behavior of empty cells in reference ranges - OFFICE-1191
Public Comment: [ODFF] SERIESSUM needs a rule for x=0 - OFFICE-1189
Public Comment: [ODFF] Improvement for ACOSH - OFFICE-1188
Public Comment: Re: [office-comment] ODFF: more suggestions: CORREL - OFFICE-1187
Conversion to NumberSequence - OFFICE-1186
Public Comment: Re: [office-comment] ODFF: list of suggestions: TRIMMEAN - OFFICE-1185
Public Comment: Re: [office-comment] ODFF: list of suggestions: LINEST - OFFICE-1184
Public Comment: Re: [office-comment] ODFF: list of suggestions: MATCH - OFFICE-1183
Public Comment: Re: [office-comment] ODFF: list of suggestions: INDEX - OFFICE-1182
Public Comment: Re: [office-comment] ODFF: more suggestions - OFFICE-1181
Public Comment: Re: [office-comment] ODFF: list of suggestions - OFFICE-1180
Public Comment: Re: [office-comment] ODFF: list of suggestions
[{"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":["is not","was in","in","!=","is","was not","not in","was","was not in","changed","="],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"attachments","displayName":"attachments","searchable":"true","operators":["is","is not"],"types":["com.atlassian.jira.issue.attachment.Attachment"]},{"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":"Development","displayName":"Development - cf[10120]","orderable":"true","searchable":"true","cfid":"cf[10120]","operators":[">",">=","=","<","<=","in","!~","not in","is","is not"],"types":["java.lang.Number","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/Theme\"","displayName":"Epic/Theme - cf[10027]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10027]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"\"Epic Color\"","displayName":"Epic Color - cf[10024]","orderable":"true","searchable":"true","cfid":"cf[10024]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Link\"","displayName":"Epic Link - cf[10021]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10021]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Epic Name\"","displayName":"Epic Name - cf[10023]","orderable":"true","searchable":"true","cfid":"cf[10023]","operators":["~","!~","=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Status\"","displayName":"Epic Status - cf[10022]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10022]","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":["is not",">=","<=","is","was not","not in","was not in","changed","was in","!~","in","~",">","!=","was","=","<"],"types":["com.atlassian.jira.project.version.Version"]},{"value":"Flagged","displayName":"Flagged - cf[10026]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10026]","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":"issueLinkType","displayName":"issueLinkType","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.link.IssueLinkType"]},{"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":"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":["is not",">=","<=","is","was not","not in","was not in","changed","was in","in",">","!=","was","=","<"],"types":["com.atlassian.jira.issue.priority.Priority"]},{"value":"project","displayName":"project","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.Project"]},{"value":"Proposal","displayName":"Proposal - cf[10001]","orderable":"true","searchable":"true","cfid":"cf[10001]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"Rank","displayName":"Rank - cf[10025]","orderable":"true","searchable":"true","cfid":"cf[10025]","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.String"]},{"value":"reporter","displayName":"reporter","auto":"true","orderable":"true","searchable":"true","operators":["is not","was in","in","!=","is","was not","not in","was","was not in","changed","="],"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":["is not",">=","<=","is","was not","not in","was not in","changed","was in","in",">","!=","was","=","<"],"types":["com.atlassian.jira.issue.resolution.Resolution"]},{"value":"cf[10002]","displayName":"Resolution - cf[10002]","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"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[10020]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10020]","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":["is not","was in","in","!=","is","was not","not in","was","was not in","changed","="],"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[10028]","orderable":"true","searchable":"true","cfid":"cf[10028]","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":"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":"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":"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":"unreleasedVersions()","displayName":"unreleasedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"updatedBy(\"\")","displayName":"updatedBy(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"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"]
{"errorMessages":["jqlTooComplex"],"errors":{}}
[{"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}]