NH-3664SchemaExport for Sqlite creates invalid foreign keys
NH-3644Merge IEnhancedProjection into IProjection
NH-3642PostgreSQL: Support LINQ DateTime.Date in select clause
NH-3635<filter> doesn't work well in self-associated class
NH-3633Add Support for Dropping Columns on Dialect
NH-3632Add Support for AlteringColumns on Dialect
NH-3631Add support for BatchTerminator on Dialect
NH-3622Fetching in query causes incorrect/missing joins in subquery
NH-3621 Does Not Create Database Automatically For MySQL
NH-3620ORA-01483 when inserting two blobs and a date using the OracleManagedDataClientDriver
NH-3609Using Projections.Conditional inside of Projections.Count and Projections.Avg generates invalid sql.
NH-3608AbstractSessionImpl abstract method visibility
NH-3607Resilient Connection Provider
NH-3606Allow Creating of Child Stateless Session
NH-3604Map ByCode fails when property is protected (not public)
NH-3599Allow Setting Lock Mode Per Query
NH-3598Unit test fails at closing already disposed connections
NH-3597added seqhilo
NH-3594MSSql2012Dialect generates invalid order by clause for paging distinct query
NH-3591IncrementGenerator unnecessarily creates a new connection to the db
NH-3590Detached entity with set of primitives throws
NH-3584cascade setting not work for sqlite
NH-3581nhibernate.everything.sln doesn't compile
NH-3580Remove dependency to Iesi.Collections
NH-3579Session leak in the Query Plan Cache
NH-3578Subcriteria.UniqueResult<T> for value types should return default(T), same as CriteriaImpl.UniqueResult<T> when result is null
NH-3577Fix in SessionFactory.Statistics.LogSummary() method to show 0 milisecond as MaxQueryTime when no query was executed, instead of -922337203685477
NH-3576session load exception with enableFilter
NH-3573Query cache statistics not updated when using MultiCriteria
NH-3571Linq does not support dynamic components inside components
NH-3569Polymorphic HQL query on not mapped base class does not return any row when row limits are set
NH-3562Not retrieve data with null many-to-one property in 4.0.0.Alpha1 too
NH-3561Date time generic hql functions
NH-3560Fix for not using bytecode optimizer for componets
NH-3559UnionSubclassEntityPersister does not quote column names
NH-3558Table check and enhanced id generators in Mapping By Code
NH-3556IQueryable<T> implementation failes with OData $expand operation used againt collection with TypeMismatchException
NH-3555Modify key object in dictionary throws
NH-3525Db2Dialect should issue FETCH FIRST N ROWS ONLY when there is no offset
NH-3506ICriteria/QueryOver create incorrect left join condition when table-per-hierarchy is used with filters
NH-3499Allow query model visitor to be provided through the session factory
NH-3475Split tests to unit and integration
NH-3459DefaultIfEmpty not supported when used with a GroupBy
NH-3446GroupBy, OrderBy key, Select to custom class fails with HibernateException
NH-3445Select, Distinct, OrderBy, Take fails with NotSupportedException
NH-3431Replace System.Data with System.Data.Common
NH-3410Reflection optimizer not used for components
NH-3402Refactor ThreadLocalSessionContext
NH-3396Fetch requests do not work with collection projections
NH-3391StatelessSession: one-to-one detail-object is always null
[{"value":"\"[CHART] Date of First Response\"","displayName":"[CHART] Date of First Response - [CHART] Date of First Response","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"[CHART] Date of First Response[Date of first response]\"","displayName":"[CHART] Date of First Response - [CHART] Date of First Response[Date of first response]","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"cf[10311]","displayName":"[CHART] Date of First Response - cf[10311]","orderable":"true","cfid":"cf[10311]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"[CHART] Time in Status\"","displayName":"[CHART] Time in Status - [CHART] Time in Status","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"[CHART] Time in Status[Time in Status]\"","displayName":"[CHART] Time in Status - [CHART] Time in Status[Time in Status]","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"cf[10310]","displayName":"[CHART] Time in Status - cf[10310]","orderable":"true","cfid":"cf[10310]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"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":"Approvals","displayName":"Approvals - Approvals","operators":["="],"types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"\"Approvals[Approvals]\"","displayName":"Approvals - Approvals[Approvals]","searchable":"true","operators":["="],"types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"cf[11310]","displayName":"Approvals - cf[11310]","orderable":"true","cfid":"cf[11310]","operators":["="],"types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"assignee","displayName":"assignee","auto":"true","orderable":"true","searchable":"true","operators":["is not","=","was in","not in","was","was not","was not in","changed","in","is","!="],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"assignee.property","displayName":"assignee.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.util.Date","java.lang.Number"]},{"value":"attachments","displayName":"attachments","searchable":"true","operators":["is","is not"],"types":["com.atlassian.jira.issue.attachment.Attachment"]},{"value":"buildName","displayName":"buildName","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"buildState","displayName":"buildState","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"category","displayName":"category","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.ProjectCategory"]},{"value":"change-control-type","displayName":"change-control-type","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"change-gating-type","displayName":"change-gating-type","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"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":"creator.property","displayName":"creator.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.util.Date","java.lang.Number"]},{"value":"deploymentEnvironmentName","displayName":"deploymentEnvironmentName","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"deploymentEnvironmentType","displayName":"deploymentEnvironmentType","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"deploymentName","displayName":"deploymentName","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"deploymentState","displayName":"deploymentState","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"description","displayName":"description","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"development","displayName":"development - cf[11510]","orderable":"true","searchable":"true","cfid":"cf[11510]","operators":["<","<=",">",">="],"types":["java.lang.Number"]},{"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":"cf[10011]","displayName":"Epic/Theme - cf[10011]","auto":"true","orderable":"true","cfid":"cf[10011]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"\"Epic/Theme\"","displayName":"Epic/Theme - Epic/Theme","auto":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"\"Epic/Theme[Labels]\"","displayName":"Epic/Theme - Epic/Theme[Labels]","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"\"Epic Colour\"","displayName":"Epic Colour - cf[10913]","orderable":"true","searchable":"true","cfid":"cf[10913]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Link\"","displayName":"Epic Link - cf[10910]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10910]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Epic Name\"","displayName":"Epic Name - cf[10911]","orderable":"true","searchable":"true","cfid":"cf[10911]","operators":["~","!~","=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Status\"","displayName":"Epic Status - cf[10912]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10912]","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","<",">=",">","=","was in","not in","was","was not","!=","<=","was not in","changed","in","is"],"types":["com.atlassian.jira.project.version.Version"]},{"value":"flagDisabledRollout","displayName":"flagDisabledRollout","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"flagEnabled","displayName":"flagEnabled","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"flagEnabledRollout","displayName":"flagEnabledRollout","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"cf[10010]","displayName":"Flagged - cf[10010]","auto":"true","orderable":"true","cfid":"cf[10010]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"Flagged","displayName":"Flagged - Flagged","auto":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"\"Flagged[Checkboxes]\"","displayName":"Flagged - Flagged[Checkboxes]","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"flagKey","displayName":"flagKey","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"flagName","displayName":"flagName","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"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.String","java.util.Date","java.lang.Number"]},{"value":"issueBlocks","displayName":"issueBlocks","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueCauses","displayName":"issueCauses","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Issue color\"","displayName":"Issue color - cf[11903]","orderable":"true","searchable":"true","cfid":"cf[11903]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"issueDependant","displayName":"issueDependant","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueDependsOn","displayName":"issueDependsOn","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueDiscoveredWhileTesting","displayName":"issueDiscoveredWhileTesting","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueDuplicates","displayName":"issueDuplicates","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueIsBlockedBy","displayName":"issueIsBlockedBy","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueIsCausedBy","displayName":"issueIsCausedBy","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueIsDuplicatedBy","displayName":"issueIsDuplicatedBy","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueIsRelatedTo","displayName":"issueIsRelatedTo","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issuekey","displayName":"issuekey","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueLink","displayName":"issueLink","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","is","is not"],"types":["com.atlassian.jira.issue.link.IssueLinkType"]},{"value":"issueTestingDiscovered","displayName":"issueTestingDiscovered","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":"jsd-linked-incident-ids","displayName":"jsd-linked-incident-ids","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"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":"linkedIssue","displayName":"linkedIssue","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"Organizations","displayName":"Organizations - cf[11700]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11700]","operators":["=","!=","not in","in"],"types":["com.atlassian.servicedesk.api.organization.CustomerOrganization"]},{"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","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"parentEpic","displayName":"parentEpic","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Parent Link\"","displayName":"Parent Link - cf[11410]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11410]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"priority","displayName":"priority","auto":"true","orderable":"true","searchable":"true","operators":["is not","<",">=",">","=","was in","not in","was","was not","!=","<=","was not in","changed","in","is"],"types":["com.atlassian.jira.issue.priority.Priority"]},{"value":"progress","displayName":"progress","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"project","displayName":"project","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.Project"]},{"value":"project.property","displayName":"project.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.util.Date","java.lang.Number"]},{"value":"projectType","displayName":"projectType","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.project.type.ProjectTypeKey"]},{"value":"cf[10012]","displayName":"Rank (Obsolete) - cf[10012]","orderable":"true","cfid":"cf[10012]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"\"Rank (Obsolete)\"","displayName":"Rank (Obsolete) - Rank (Obsolete)","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"\"Rank (Obsolete)[Number]\"","displayName":"Rank (Obsolete) - Rank (Obsolete)[Number]","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"Rank","displayName":"Rank - cf[11010]","orderable":"true","searchable":"true","cfid":"cf[11010]","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.String"]},{"value":"cf[10110]","displayName":"Release Version History - cf[10110]","auto":"true","orderable":"true","cfid":"cf[10110]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.project.version.Version"]},{"value":"\"Release Version History\"","displayName":"Release Version History - Release Version History","auto":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.project.version.Version"]},{"value":"\"Release Version History[Version Picker (multiple versions)]\"","displayName":"Release Version History - Release Version History[Version Picker (multiple versions)]","auto":"true","searchable":"true","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":["is not","=","was in","not in","was","was not","was not in","changed","in","is","!="],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"reporter.property","displayName":"reporter.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.util.Date","java.lang.Number"]},{"value":"request","displayName":"request","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"request-channel-type","displayName":"request-channel-type","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"request-last-activity-time","displayName":"request-last-activity-time","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Request participants\"","displayName":"Request participants - cf[11901]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11901]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"\"Request Type\"","displayName":"Request Type - cf[11800]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11800]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.servicedesk.internal.api.origin.VpOrigin"]},{"value":"resolution","displayName":"resolution","auto":"true","orderable":"true","searchable":"true","operators":["is not","<",">=",">","=","was in","not in","was","was not","!=","<=","was not in","changed","in","is"],"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":"cf[11904]","displayName":"Satisfaction - cf[11904]","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"cf[11905]","displayName":"Satisfaction - cf[11905]","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"savedfilter","displayName":"savedfilter","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"sd-kb-shared","displayName":"sd-kb-shared","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"searchrequest","displayName":"searchrequest","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"Sprint","displayName":"Sprint - cf[10610]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10610]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"cf[11900]","displayName":"Start date - cf[11900]","orderable":"true","cfid":"cf[11900]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Start date\"","displayName":"Start date - Start date","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Start date[Date]\"","displayName":"Start date - Start date[Date]","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"status","displayName":"status","auto":"true","orderable":"true","searchable":"true","operators":["is not","=","was in","not in","was","was not","was not in","changed","in","is","!="],"types":["com.atlassian.jira.issue.status.Status"]},{"value":"statusCategory","displayName":"statusCategory","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.status.category.StatusCategory"]},{"value":"statusCategoryChangedDate","displayName":"statusCategoryChangedDate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Story point estimate\"","displayName":"Story point estimate - cf[11902]","orderable":"true","searchable":"true","cfid":"cf[11902]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"cf[10013]","displayName":"Story Points - cf[10013]","orderable":"true","cfid":"cf[10013]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"\"Story Points\"","displayName":"Story Points - Story Points","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"\"Story Points[Number]\"","displayName":"Story Points - Story Points[Number]","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"subtasks","displayName":"subtasks","orderable":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"summary","displayName":"summary","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Target end\"","displayName":"Target end - cf[11907]","orderable":"true","searchable":"true","cfid":"cf[11907]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Target start\"","displayName":"Target start - cf[11906]","orderable":"true","searchable":"true","cfid":"cf[11906]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"cf[11600]","displayName":"Team - cf[11600]","auto":"true","orderable":"true","cfid":"cf[11600]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.Number"]},{"value":"Team","displayName":"Team - Team","auto":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.Number"]},{"value":"\"Team[Team]\"","displayName":"Team - Team[Team]","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.Number"]},{"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","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"voter.property","displayName":"voter.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.util.Date","java.lang.Number"]},{"value":"votes","displayName":"votes","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"watcher","displayName":"watcher","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"watcher.property","displayName":"watcher.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.util.Date","java.lang.Number"]},{"value":"watchers","displayName":"watchers","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"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":"approved()","displayName":"approved()","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"approver(\"\")","displayName":"approver(\"\")","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"breached()","displayName":"breached()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"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":"completed()","displayName":"completed()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"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":"elapsed(\"\")","displayName":"elapsed(\"\")","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"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":"everBreached()","displayName":"everBreached()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"value":"futureSprints()","displayName":"futureSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"inactiveUsers()","displayName":"inactiveUsers()","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"iqlFunction(\"\")","displayName":"iqlFunction(\"\")","isList":"true","types":["com.atlassian.servicedesk.cmdb.model.CmdbObjectReference"]},{"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":"myApproval()","displayName":"myApproval()","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"myPending()","displayName":"myPending()","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"now()","displayName":"now()","types":["java.util.Date"]},{"value":"openSprints()","displayName":"openSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"organizationMembers(\"\")","displayName":"organizationMembers(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"paused()","displayName":"paused()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"value":"pending()","displayName":"pending()","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"pendingBy(\"\")","displayName":"pendingBy(\"\")","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"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":"remaining(\"\")","displayName":"remaining(\"\")","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"value":"running()","displayName":"running()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"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"]},{"value":"withinCalendarHours()","displayName":"withinCalendarHours()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]}]
["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","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,"favourite":false},{"id":-2,"name":"Reported by me","jql":"reporter = currentUser() order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true,"favourite":false},{"id":-4,"name":"All issues","jql":"order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false},{"id":-5,"name":"Open issues","jql":"resolution = Unresolved order by priority DESC,updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false},{"id":-9,"name":"Done issues","jql":"statusCategory = Done order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false},{"id":-3,"name":"Viewed recently","jql":"issuekey in issueHistory() order by lastViewed DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true,"favourite":false},{"id":-6,"name":"Created recently","jql":"created >= -1w order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false},{"id":-7,"name":"Resolved recently","jql":"resolutiondate >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false},{"id":-8,"name":"Updated recently","jql":"updated >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false}]