{"action":"closed","issue":{"url":"https://api.github.com/repos/INSPIRE-MIF/qgis-ogr-gmlas/issues/6","repository_url":"https://api.github.com/repos/INSPIRE-MIF/qgis-ogr-gmlas","labels_url":"https://api.github.com/repos/INSPIRE-MIF/qgis-ogr-gmlas/issues/6/labels{/name}","comments_url":"https://api.github.com/repos/INSPIRE-MIF/qgis-ogr-gmlas/issues/6/comments","events_url":"https://api.github.com/repos/INSPIRE-MIF/qgis-ogr-gmlas/issues/6/events","html_url":"https://github.com/INSPIRE-MIF/qgis-ogr-gmlas/issues/6","id":186777917,"number":6,"title":"QGIS / Discover relations / Multiple times same relation","user":{"login":"fxprunayre","id":1701393,"avatar_url":"https://avatars.githubusercontent.com/u/1701393?v=3","gravatar_id":"","url":"https://api.github.com/users/fxprunayre","html_url":"https://github.com/fxprunayre","followers_url":"https://api.github.com/users/fxprunayre/followers","following_url":"https://api.github.com/users/fxprunayre/following{/other_user}","gists_url":"https://api.github.com/users/fxprunayre/gists{/gist_id}","starred_url":"https://api.github.com/users/fxprunayre/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fxprunayre/subscriptions","organizations_url":"https://api.github.com/users/fxprunayre/orgs","repos_url":"https://api.github.com/users/fxprunayre/repos","events_url":"https://api.github.com/users/fxprunayre/events{/privacy}","received_events_url":"https://api.github.com/users/fxprunayre/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"pvalsecc","id":1180608,"avatar_url":"https://avatars.githubusercontent.com/u/1180608?v=3","gravatar_id":"","url":"https://api.github.com/users/pvalsecc","html_url":"https://github.com/pvalsecc","followers_url":"https://api.github.com/users/pvalsecc/followers","following_url":"https://api.github.com/users/pvalsecc/following{/other_user}","gists_url":"https://api.github.com/users/pvalsecc/gists{/gist_id}","starred_url":"https://api.github.com/users/pvalsecc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pvalsecc/subscriptions","organizations_url":"https://api.github.com/users/pvalsecc/orgs","repos_url":"https://api.github.com/users/pvalsecc/repos","events_url":"https://api.github.com/users/pvalsecc/events{/privacy}","received_events_url":"https://api.github.com/users/pvalsecc/received_events","type":"User","site_admin":false},"assignees":[{"login":"pvalsecc","id":1180608,"avatar_url":"https://avatars.githubusercontent.com/u/1180608?v=3","gravatar_id":"","url":"https://api.github.com/users/pvalsecc","html_url":"https://github.com/pvalsecc","followers_url":"https://api.github.com/users/pvalsecc/followers","following_url":"https://api.github.com/users/pvalsecc/following{/other_user}","gists_url":"https://api.github.com/users/pvalsecc/gists{/gist_id}","starred_url":"https://api.github.com/users/pvalsecc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pvalsecc/subscriptions","organizations_url":"https://api.github.com/users/pvalsecc/orgs","repos_url":"https://api.github.com/users/pvalsecc/repos","events_url":"https://api.github.com/users/pvalsecc/events{/privacy}","received_events_url":"https://api.github.com/users/pvalsecc/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/INSPIRE-MIF/qgis-ogr-gmlas/milestones/1","html_url":"https://github.com/INSPIRE-MIF/qgis-ogr-gmlas/milestones/1.0.0","labels_url":"https://api.github.com/repos/INSPIRE-MIF/qgis-ogr-gmlas/milestones/1/labels","id":2109211,"number":1,"title":"1.0.0","description":"","creator":{"login":"fxprunayre","id":1701393,"avatar_url":"https://avatars.githubusercontent.com/u/1701393?v=3","gravatar_id":"","url":"https://api.github.com/users/fxprunayre","html_url":"https://github.com/fxprunayre","followers_url":"https://api.github.com/users/fxprunayre/followers","following_url":"https://api.github.com/users/fxprunayre/following{/other_user}","gists_url":"https://api.github.com/users/fxprunayre/gists{/gist_id}","starred_url":"https://api.github.com/users/fxprunayre/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fxprunayre/subscriptions","organizations_url":"https://api.github.com/users/fxprunayre/orgs","repos_url":"https://api.github.com/users/fxprunayre/repos","events_url":"https://api.github.com/users/fxprunayre/events{/privacy}","received_events_url":"https://api.github.com/users/fxprunayre/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":5,"state":"open","created_at":"2016-11-02T10:58:08Z","updated_at":"2016-11-07T12:55:15Z","due_on":"2016-12-15T00:00:00Z","closed_at":null},"comments":2,"created_at":"2016-11-02T11:39:36Z","updated_at":"2016-11-07T12:55:15Z","closed_at":"2016-11-07T12:55:15Z","body":"\r\nWhen clicking on discover relations, the same relation is listed multiple times:\r\n\r\n![image](https://cloud.githubusercontent.com/assets/1701393/19927179/deeb9032-a0f8-11e6-85d4-f7ded64f2f93.png)\r\n\r\n\r\nTable definition:\r\n\r\n```\r\nCREATE TABLE br.bio_geographicalregion_name\r\n(\r\n  ogc_fid serial NOT NULL,\r\n  ogr_pkid character varying NOT NULL,\r\n  parent_ogr_pkid character varying NOT NULL,\r\n  codespace character varying,\r\n  value character varying NOT NULL,\r\n  CONSTRAINT bio_geographicalregion_name_pkey PRIMARY KEY (ogc_fid),\r\n  CONSTRAINT bio_geographicalregionogr_pkid FOREIGN KEY (parent_ogr_pkid)\r\n      REFERENCES br.bio_geographicalregion (ogr_pkid) MATCH SIMPLE\r\n      ON UPDATE NO ACTION ON DELETE NO ACTION\r\n)\r\nWITH (\r\n  OIDS=FALSE\r\n);\r\n```\r\n\r\nrelated to \r\n\r\n```\r\nCREATE TABLE br.bio_geographicalregion\r\n(\r\n  ogc_fid serial NOT NULL,\r\n  ogr_pkid character varying NOT NULL,\r\n  id character varying NOT NULL,\r\n  description_href character varying,\r\n  description_title character varying,\r\n  description_nilreason character varying,\r\n  description character varying,\r\n  descriptionreference_href character varying,\r\n  descriptionreference_title character varying,\r\n  descriptionreference_nilreason character varying,\r\n  identifier_codespace character varying,\r\n  identifier character varying,\r\n  location_location_pkid character varying,\r\n  inspireid_identifier_localid character varying,\r\n  inspireid_identifier_namespace character varying,\r\n  inspireid_identifier_versionid_nilreason character varying,\r\n  inspireid_identifier_versionid character varying,\r\n  regionclassification_owns boolean DEFAULT false,\r\n  regionclassification_href character varying,\r\n  regionclassification_title character varying,\r\n  regionclassification_nilreason character varying,\r\n  regionclassificationscheme_owns boolean DEFAULT false,\r\n  regionclassificationscheme_href character varying,\r\n  regionclassificationscheme_name character varying,\r\n  regionclassificationscheme_definition character varying,\r\n  regionclassificationscheme_title character varying,\r\n  regionclassificationscheme_nilreason character varying,\r\n  regionclassificationlevel_owns boolean DEFAULT false,\r\n  regionclassificationlevel_href character varying,\r\n  regionclassificationlevel_name character varying,\r\n  regionclassificationlevel_definition character varying,\r\n  regionclassificationlevel_title character varying,\r\n  regionclassificationlevel_nilreason character varying,\r\n  beginlifespanversion_nilreason character varying,\r\n  beginlifespanversion timestamp with time zone,\r\n  endlifespanversion_nilreason character varying,\r\n  endlifespanversion timestamp with time zone,\r\n  wkb_geometry geometry(MultiPolygon,3035),\r\n  CONSTRAINT bio_geographicalregion_pkey PRIMARY KEY (ogc_fid),\r\n  CONSTRAINT bio_geographicalregionogr_pkid_uk UNIQUE (ogr_pkid)\r\n)\r\nWITH (\r\n  OIDS=FALSE\r\n);\r\n```\r\n\r\nAny ideas why ?\r\n\r\n"}}
{"actor":{"display_login":"pvalsecc"}}