<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=iso-8859-1"><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;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
span.StileMessaggioDiPostaElettronica20
{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=IT link="#0563C1" vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>Hi Mark<o:p></o:p></p><p class=MsoNormal>Thank you, I tried with MG_CONTROL (very good script!!) and my polygon table<o:p></o:p></p><p class=MsoNormal><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> ('ATS_BASE', 'BA_MUNICIPALITY_POLYGON', 'GEOM', 'MY_POLYGON', 82087, <o:p></o:p></p><p class=MsoNormal> 'FID');<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>than I Used the Mapagent Web Tier Test page with WFS GETCAPABILITIES to see the result<o:p></o:p></p><p class=MsoNormal>http://xxx:8018/mapguide/mapagent/index.html<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><img width=704 height=263 style='width:7.3333in;height:2.7395in' id="Immagine_x0020_2" src="cid:image002.png@01D7DC64.BB954040"><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>When I use Gaia to test the service, the reference name is <b><span style='background:yellow;mso-highlight:yellow'>ns160697717</span>:MY_POLYGON</b><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>Result<o:p></o:p></b></p><p class=MsoNormal>In my opinion MG_CONTROL can handle the name of the feature class, but not the ID before the name that depends from the data source created in MGOS (I’m trying to force/change the ID)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Do you have experienced something else, please?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Best regards<o:p></o:p></p><p class=MsoNormal>Gvtomm<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><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 style='mso-fareast-language:IT'>Da:</span></b><span style='mso-fareast-language:IT'> mapguide-users <mapguide-users-bounces@lists.osgeo.org> <b>Per conto di </b>mark volz<br><b>Inviato:</b> mercoledė 17 novembre 2021 22:11<br><b>A:</b> MapGuide Users Mail List <mapguide-users@lists.osgeo.org><br><b>Oggetto:</b> Re: [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=EN-AU>Yes, you can.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-AU>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></span></p><p class=MsoNormal><span lang=EN-AU><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-AU>The table needs to be in the same schema that you set in the OracleSchema field.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-AU>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></span></p><p class=MsoNormal><span lang=EN-AU><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-AU>Here is a sample insert statement:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU>Insert into MG_CONTROL<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU> ( FDO_ORA_OWNER, FDO_ORA_NAME, FDO_ORA_GEOMCOLUMN, FDO_CLASS_NAME, FDO_SRID,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU> FDO_IDENTITY)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU>Values<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU> ('someSchema', 'someTable', 'theGeometryColumn', 'exposed feature name', 3112, <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU> 'primaryKeyOnTable');<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-AU><img width=358 height=159 style='width:3.7291in;height:1.6562in' id="Picture_x0020_1" src="cid:image001.png@01D7DC63.A24828B0"></span><span lang=EN-AU><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU><o:p> </o:p></span></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 <<a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>> <b>On Behalf Of </b>gvtomm<br><b>Sent:</b> Thursday, 18 November 2021 7:37 AM<br><b>To:</b> <a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br><b>Subject:</b> [mapguide-users] MapGuide WFS uniqueID<o:p></o:p></span></p></div></div><p class=MsoNormal><span lang=EN-AU><o:p> </o:p></span></p><p class=MsoNormal>Hi,<o:p></o:p></p><p class=MsoNormal>I’m using MGOS 3.1<o:p></o:p></p><p class=MsoNormal>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></p><p class=MsoNormal>For example<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></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><o:p> </o:p></p><p class=MsoNormal>Is it possibile to change/force the identifier, after moving MGOS in a new server?<o:p></o:p></p><p class=MsoNormal>Because my application works with static link for WFS service that I can’t change<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Best regards<o:p></o:p></p><p class=MsoNormal>gvtomm<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>