NHSP-21Update Spatial for NH 4.0
NHSP-15Query failes in NHSP2.1.2 with PostGIS
NHSP-20Longitude and latitude swapped?
NHSP-19Change ToString and ToByteArray methods in PostGisGeometryType
NHSP-18Line geometry insertion fails if line contains only two idantical points
NHSP-13Release a 3.0.0 Alpha 1 build
NHSP-17Better error message for RelateProjection for MsSQL2008
NHSP-16No longer builds against NH 3.0.0
NHSP-10LINQ support for spatial data
NHSP-11Provide SQL Server union aggregate support
NHSP-8SQL Server 2008 queries return X and Y inverted (X is Lat, should be Lon, and Y is Lon, should be Lat)
NHSP-9Include QueryOver support for existing criterium
NHSP-3Support for SQL Server 2008 Geography type
NHSP-7Update release versions
NHSP-12Release a 2.1.2 build
NHSP-14Two Geometry are alway not equals for MsSQL2008
NHSP-4Unnecessary SQL Update
NHSP-6Use spatial types on PostgreSQL
NHSP-5Incorrect conversion from BOX to WKT POLYGON in PostGIS Geometry Data Type
NHSP-1SqlGeometry has bad SqlSuperType and is not serializable
NHSP-2Incorrect SQL generated when mapped geometry object is 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":"a4j-incident-creation-deduplication-alias","displayName":"a4j-incident-creation-deduplication-alias","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","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","is not","was","not in","=","!=","was in","changed","was not","was not in","in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"assignee.property","displayName":"assignee.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.Number","java.util.Date","java.lang.String"]},{"value":"atlasGoalKeys","displayName":"atlasGoalKeys","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"atlasGoalStatuses","displayName":"atlasGoalStatuses","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"atlasProjectKey","displayName":"atlasProjectKey","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Atlas project key\"","displayName":"Atlas project key - cf[11914]","orderable":"true","searchable":"true","cfid":"cf[11914]","operators":["is","is not","not in","=","!=","in"],"types":["java.lang.String"]},{"value":"atlasProjectStatus","displayName":"atlasProjectStatus","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Atlas project status\"","displayName":"Atlas project status - cf[11915]","orderable":"true","searchable":"true","cfid":"cf[11915]","operators":["is","is not","not in","=","!=","in"],"types":["java.lang.String"]},{"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":"Category","displayName":"Category - Category","auto":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"\"Category[Category]\"","displayName":"Category - Category[Category]","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"cf[11913]","displayName":"Category - cf[11913]","auto":"true","orderable":"true","cfid":"cf[11913]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"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":"Compass","displayName":"Compass - cf[11912]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11912]","operators":["=","!=","in","not in","is","is not"],"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.Number","java.util.Date","java.lang.String"]},{"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","is not","was","=","~","<",">=","not in","!=","was in","changed","!~",">","was not","was not in","in","<="],"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":"hierarchyLevel","displayName":"hierarchyLevel","auto":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.hierarchy.HierarchyLevel"]},{"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.util.Date","java.lang.String"]},{"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":"issueFormsVersion","displayName":"issueFormsVersion","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"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":"jsm-new-issue","displayName":"jsm-new-issue","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"jsm-primary-incident-issue-id","displayName":"jsm-primary-incident-issue-id","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"jsm-system-incident-id","displayName":"jsm-system-incident-id","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":"\"Locked forms\"","displayName":"Locked forms - cf[11910]","orderable":"true","searchable":"true","cfid":"cf[11910]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"\"Open forms\"","displayName":"Open forms - cf[11908]","orderable":"true","searchable":"true","cfid":"cf[11908]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"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","auto":"true","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","deprecated":"true","deprecatedSearcherKey":"com.atlassian.jpo:jpo-custom-field-parent-searcher","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","is not","was","=","<",">=","not in","!=","was in","changed",">","was not","was not in","in","<="],"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.Number","java.util.Date","java.lang.String"]},{"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","i