<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 2.0cm 2.0cm 2.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-AU" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Yes, you can.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">When you create a connection, you can set “kingFDOClass”. This field needs to point to a table with metadata information about the tables you want to use within MapGuide. Typically I call this table mg_control, but you can name it anything
you want so long as it has all the required columns. In addition to controlling the FDO class name (the exposed object names you see), the control table allows you to use point data where you don’t have a geometry field but have x and y columns.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The table needs to be in the same schema that you set in the OracleSchema field.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Attached is a SQL statement to create the table and a trigger and sequence to set the unique id field and comments on the key attributes.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Here is a sample insert statement:<o:p></o:p></p>
<p class="MsoNormal">Insert into MG_CONTROL<o:p></o:p></p>
<p class="MsoNormal"> ( FDO_ORA_OWNER, FDO_ORA_NAME, FDO_ORA_GEOMCOLUMN, FDO_CLASS_NAME, FDO_SRID,<o:p></o:p></p>
<p class="MsoNormal"> FDO_IDENTITY)<o:p></o:p></p>
<p class="MsoNormal">Values<o:p></o:p></p>
<p class="MsoNormal"> ('someSchema', 'someTable', 'theGeometryColumn', 'exposed feature name', 3112,
<o:p></o:p></p>
<p class="MsoNormal"> 'primaryKeyOnTable');<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><img width="358" height="159" style="width:3.7291in;height:1.6562in" id="Picture_x0020_1" src="cid:image001.png@01D7DC53.C31AF8C0"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="mso-fareast-language:EN-AU">From:</span></b><span lang="EN-US" style="mso-fareast-language:EN-AU"> mapguide-users <mapguide-users-bounces@lists.osgeo.org>
<b>On Behalf Of </b>gvtomm<br>
<b>Sent:</b> Thursday, 18 November 2021 7:37 AM<br>
<b>To:</b> mapguide-users@lists.osgeo.org<br>
<b>Subject:</b> [mapguide-users] MapGuide WFS uniqueID<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="IT">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="IT">I’m using MGOS 3.1<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="IT">When I publish a King.Oracle data source in WFS, the name of WFS service is composed by an Identifier (<span style="background:yellow;mso-highlight:yellow">yellow</span>) and the name of the Oracle table/view<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="IT">For example<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="IT"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-align:justify"><span lang="EN-US" style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:blue;mso-fareast-language:IT"><</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#990000;mso-fareast-language:IT">wfs:Name</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:blue;mso-fareast-language:IT">></span><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Verdana",sans-serif;background:yellow;mso-highlight:yellow;mso-fareast-language:IT">ns125641909</span></b><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Verdana",sans-serif;mso-fareast-language:IT">:ABC_BASE~TB_PERIMETER~GEOM</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:blue;mso-fareast-language:IT"></</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#990000;mso-fareast-language:IT">wfs:Name</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:blue;mso-fareast-language:IT">><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="IT"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="IT">Is it possibile to change/force the identifier, after moving MGOS in a new server?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="IT">Because my application works with static link for WFS service that I can’t change<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="IT"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="IT">Best regards<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="IT">gvtomm<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="IT"><o:p> </o:p></span></p>
</div>
</body>
</html>