Opened 9 years ago

Closed 6 years ago

#2574 closed defect (worksforme)

postgis/mssql datetime properties in properties panel show as null

Reported by: Jamo Owned by: jng
Priority: low Milestone: 3.1.1
Component: Map Agent Version: 3.0.0
Severity: trivial Keywords: PostGis, MapAgent
Cc: External ID:

Description

Upon selecting a feature with a postgis dateTime value the dateTime value is returned as null to the selection panel from the map agent.

PostGis Table:

-- Table: gisgeom.plndevapp

-- DROP TABLE gisgeom.plndevapp;

CREATE TABLE gisgeom.plndevapp
(
  fid bigserial NOT NULL,
  xfmuuid character varying,
  id character varying(255),
  landuse character varying(255),
  approved_dt timestamp without time zone,
  supportingfiles text,
  geom geometry,
  CONSTRAINT plndevapp_pkey PRIMARY KEY (fid),
  CONSTRAINT enforce_dims_geom CHECK (st_ndims(geom) = 2),
  CONSTRAINT enforce_srid_geom CHECK (st_srid(geom) = 28356)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE gisgeom.plndevapp
  OWNER TO "GIS_ADMIN";

single data row

INSERT INTO gisgeom.plndevapp(
            fid, xfmuuid, id, landuse, approved_dt, supportingfiles, geom)
    VALUES (76,"","DP26-12","BRISBANE CONTAINER TERMINALS AMENDMENTS TO DP10-11","2012-11-20 10:36:27","<supportingFiles><file><file>A1805411</file><fileType>objective</fileType><status></status><comment>Consent Notice</comment></file><file><file>fA237425</file><fileType>objective</fileType><status></status><comment>Consent Notice</comment></file></supportingFiles>","0101000020C46E00002D06141A4C9C1F41D7DC34DA159A5A41");

Discussion on nabble: http://osgeo-org.1560.x6.nabble.com/Mapguide-3-0-and-postgis-mssql-datetime-properties-td5229375.html

Change History (2)

comment:1 by jng, 6 years ago

Milestone: 3.1.1
Owner: set to jng

comment:2 by jng, 6 years ago

Resolution: worksforme
Status: newclosed

Can't re-produce

Note: See TracTickets for help on using tickets.