[mapguide-users] PostGIS view with a join not selectable

[techdude1996]

Kajar wrote
> Sometimes I create new layer and then it start working.

I deleted the layer resource and re-created it. That fixed it and is now
working.


RenoSun wrote
> Did you set up the primary key of your database data source?

Yes, and I also had to add the primary key to the complexType further down
that was not shown in the tutorial.

Here's the top part:

<schema>
...
    <xs:element name="v_parcels" type="public:v_parcelsType"
abstract="false" substitutionGroup="gml:_Feature">
        <xs:key name="v_parcelsKey">
            <xs:selector xpath=".//v_parcels" />
            <xs:field xpath="gid" />
        </xs:key>
        </xs:element>
            <xs:complexType name="v_parcelsType" abstract="false"
fdo:geometryName="geom">...
...

Here's the part much further down:

<SchemaMapping>
...
    <complexType name="v_parcelsType" tableMapping="Concrete">
        <xs:Table pkeyName="v_parcelsKey" name="public.v_parcels"/>
...

There's no "xs:" in front of the Table, but in order to show it without
being rendered as HTML I had to put it there.

Thank you both for your help.



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html