<div dir="auto">Personally, I haven’t used MapServer JOIN in a very long time and instead, as Brent suggested, prefer using doing joins in SQL (OGR’s SQL capabilities, PostGIS or GPKG).</div><div dir="auto"><br></div><div dir="auto">One thought is I’m not sure MapServer JOIN would work over WFS.  My impression is it is meant more for use with MapServer templates (mode=query, mode=nquery) which GeoMoose no longer uses (as of ver 3).  The interesting bit here is the MapServer join one-to-many join doesn’t appear to duplicate the feature like a SQL join ahead of MapServer would generally do (unless some SQL tricks are done to transform the multiple joined rows into columns.  I’m not sure how MapServer/GeoMoose would handle an array column or a json column.)</div><div dir="auto"><br></div><div dir="auto">And besides auto=true, looking at the WFS response GML with the browser debugger can be helpful too (or looking at the WFS in QGIS).  My guess is the JOINed columns aren’t in the WFS response.</div><div dir="auto"><br></div><div dir="auto">On Thu, Jan 5, 2023 at 18:59 Brent Fraser <<a href="mailto:bfraser@geoanalytic.com">bfraser@geoanalytic.com</a>> wrote:<br></div><div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;padding-left:1ex;border-left-color:rgb(204,204,204)"><div style="font-family:arial;font-size:14px"><div style="box-sizing:border-box;font-family:arial">I've done a join in the DATA statement and in an ogr vrt file, but I don't recall using the JOIN object in the map file.  Likely you need to be careful to use upper case for the DBF column names. GeoMoose 3 uses WMS/WFS to communicate with Mapserver; maybe the JOIN doesn't work with these protocols.</div><div style="box-sizing:border-box;font-family:arial"><br style="box-sizing:border-box"></div><div style="box-sizing:border-box;font-family:arial">Did you set DEBUG 5 and check the contents of the log file?</div><div style="box-sizing:border-box;font-family:arial"><br style="box-sizing:border-box"></div><div style="box-sizing:border-box;font-family:arial"><span style="box-sizing:border-box;font-family:arial"> </span></div><div style="box-sizing:border-box;font-family:arial"><br style="box-sizing:border-box"></div><hr id="m_-856113953552453035previousmessagehr" style="box-sizing:border-box;clear:both;font-family:arial"><div style="box-sizing:border-box;font-family:arial"><span style="box-sizing:border-box;font-family:arial"><strong style="box-sizing:border-box;font-weight:700;font-family:arial">From</strong>: "Christopher Hughes" <<a href="mailto:chughes@co.lincoln.or.us" target="_blank" style="font-family:arial">chughes@co.lincoln.or.us</a>><br style="box-sizing:border-box"><strong style="box-sizing:border-box;font-weight:700;font-family:arial">Sent</strong>: 1/5/23 5:32 PM<br style="box-sizing:border-box"><strong style="box-sizing:border-box;font-weight:700;font-family:arial">To</strong>: geomoose-users-osgeo <<a href="mailto:geomoose-users@lists.osgeo.org" target="_blank" style="font-family:arial">geomoose-users@lists.osgeo.org</a>>, "<a href="mailto:bfraser@geoanalytic.com" target="_blank" style="font-family:arial">bfraser@geoanalytic.com</a>" <<a href="mailto:bfraser@geoanalytic.com" target="_blank" style="font-family:arial">bfraser@geoanalytic.com</a>><br style="box-sizing:border-box"><strong style="box-sizing:border-box;font-weight:700;font-family:arial">Subject</strong>: Re: [GeoMoose-users] One to Many Join - GeoMoose 3</span></div></div><div style="font-family:arial;font-size:14px"><div style="box-sizing:border-box;font-family:arial"><br style="box-sizing:border-box"></div><div style="box-sizing:border-box;font-family:arial"><span style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;box-sizing:border-box;background-color:rgb(255,255,255);color:rgb(0,0,0)">In this case my join is one-to-many. For each parcel I have multiple results in the table I'm trying to join. The issue is that I only get results for the initial layer, not for the table I'm trying to join to the initial layer. I've tried auto="true", which works except it only gives me the values for the parcel layer, not the table I'm trying to join in the mapfile. I wasn't sure if there was a way of setting the join parameters in the mapbook map-source rather than in mapfile layer.</span></div><div style="box-sizing:border-box;font-family:arial"><div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;box-sizing:border-box;color:rgb(0,0,0)"><br style="box-sizing:border-box"></div><div id="m_-856113953552453035Signature" style="box-sizing:border-box;font-family:arial"><div style="box-sizing:border-box;font-family:arial"><div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;box-sizing:border-box;color:rgb(0,0,0)"><span style="font-family:"Segoe UI","Segoe UI Web (West European)","Segoe UI",-apple-system,BlinkMacSystemFont,Roboto,"Helvetica Neue",sans-serif;font-size:15px;text-align:start;box-sizing:border-box;display:inline!important;background-color:rgb(255,255,255)">--</span><br style="font-family:"Segoe UI","Segoe UI Web (West European)","Segoe UI",-apple-system,BlinkMacSystemFont,Roboto,"Helvetica Neue",sans-serif;font-size:15px;text-align:start;background-color:rgb(255,255,255);box-sizing:border-box"><div dir="ltr" style="font-size:15px;font-family:"Segoe UI","Segoe UI Web (West European)","Segoe UI",-apple-system,BlinkMacSystemFont,Roboto,"Helvetica Neue",sans-serif;margin:0px;text-align:start;box-sizing:border-box;background-color:rgb(255,255,255)"><div dir="ltr" style="margin:0px;box-sizing:border-box;font-family:"Segoe UI","Segoe UI Web (West European)","Segoe UI",-apple-system,BlinkMacSystemFont,Roboto,"Helvetica Neue",sans-serif">Chris Hughes<div style="font-size:12.79px;margin:0px;box-sizing:border-box;font-family:"Segoe UI","Segoe UI Web (West European)","Segoe UI",-apple-system,BlinkMacSystemFont,Roboto,"Helvetica Neue",sans-serif"><br style="box-sizing:border-box"></div><div style="font-size:12.79px;margin:0px;box-sizing:border-box;font-family:"Segoe UI","Segoe UI Web (West European)","Segoe UI",-apple-system,BlinkMacSystemFont,Roboto,"Helvetica Neue",sans-serif">GIS Analyst</div><div style="font-size:12.79px;margin:0px;box-sizing:border-box;font-family:"Segoe UI","Segoe UI Web (West European)","Segoe UI",-apple-system,BlinkMacSystemFont,Roboto,"Helvetica Neue",sans-serif">Lincoln County GIS Department </div><div style="margin:0px;box-sizing:border-box;font-family:"Segoe UI","Segoe UI Web (West European)","Segoe UI",-apple-system,BlinkMacSystemFont,Roboto,"Helvetica Neue",sans-serif"><span style="font-family:Roboto,arial,sans-serif;margin:0px;box-sizing:border-box"><a href="https://www.google.com/maps/search/880+NE+7th?entry=gmail&source=g" style="font-family:Roboto,arial,sans-serif">880 NE 7th</a> S</span><span style="font-family:Roboto,arial,sans-serif;margin:0px;box-sizing:border-box">t</span>. l Newport, OR 97365</div><div style="font-size:12.79px;margin:0px;box-sizing:border-box;font-family:"Segoe UI","Segoe UI Web (West European)","Segoe UI",-apple-system,BlinkMacSystemFont,Roboto,"Helvetica Neue",sans-serif">Tel: (541) 574 1283</div></div></div><br style="box-sizing:border-box"></div></div></div></div><div id="m_-856113953552453035appendonsend" style="box-sizing:border-box;font-family:arial"><br style="box-sizing:border-box"></div><hr style="display:inline-block;width:98%;box-sizing:border-box;clear:both;break-after:page;font-family:arial"><div dir="ltr" id="m_-856113953552453035divRplyFwdMsg" style="box-sizing:border-box;font-family:arial"><strong style="box-sizing:border-box;font-weight:700;font-family:arial">From:</strong> Brent Fraser <<a href="mailto:bfraser@geoanalytic.com" target="_blank" style="font-family:arial">bfraser@geoanalytic.com</a>><br style="box-sizing:border-box"><strong style="box-sizing:border-box;font-weight:700;font-family:arial">Sent:</strong> Thursday, January 5, 2023 4:06 PM<br style="box-sizing:border-box"><strong style="box-sizing:border-box;font-weight:700;font-family:arial">To:</strong> Christopher Hughes <<a href="mailto:chughes@co.lincoln.or.us" target="_blank" style="font-family:arial">chughes@co.lincoln.or.us</a>>; geomoose-users-osgeo <<a href="mailto:geomoose-users@lists.osgeo.org" target="_blank" style="font-family:arial">geomoose-users@lists.osgeo.org</a>><br style="box-sizing:border-box"><strong style="box-sizing:border-box;font-weight:700;font-family:arial">Subject:</strong>RE: [GeoMoose-users] One to Many Join - GeoMoose 3<div style="box-sizing:border-box;font-family:arial"> </div></div><div style="box-sizing:border-box;font-family:arial"><div style="font-family:arial;font-size:14px;box-sizing:border-box"><div style="box-sizing:border-box;font-family:arial">Hi Chris,</div><div style="box-sizing:border-box;font-family:arial"><br style="box-sizing:border-box"></div><div style="box-sizing:border-box;font-family:arial">  Usually what I do is in the mapbook set   <template name="identify" auto="true" /> and do an Identify on a parcel to what Mapserver sends back via GML format.  You can then tune your GeoMoose template using the property names shown in the Identify results.</div><div style="box-sizing:border-box;font-family:arial"><br style="box-sizing:border-box"></div><div style="box-sizing:border-box;font-family:arial">Should your join be a one-to-one?  Have a look in the mapserver error log to see if there any problems on the Mapserver side.</div><div style="box-sizing:border-box;font-family:arial"><br style="box-sizing:border-box"></div><div style="box-sizing:border-box;font-family:arial">Best Regards,</div><div style="box-sizing:border-box;font-family:arial">Brent Fraser</div><div style="box-sizing:border-box;font-family:arial"><br style="box-sizing:border-box"></div><div style="box-sizing:border-box;font-family:arial"><span style="box-sizing:border-box;font-family:arial"> </span></div><div style="box-sizing:border-box;font-family:arial"><br style="box-sizing:border-box"></div><hr id="m_-856113953552453035x_previousmessagehr" style="box-sizing:border-box;clear:both;break-after:page;font-family:arial"><div style="box-sizing:border-box;font-family:arial"><span style="box-sizing:border-box;font-family:arial"><strong style="box-sizing:border-box;font-weight:700;font-family:arial">From</strong>: "Christopher Hughes" <<a href="mailto:chughes@co.lincoln.or.us" target="_blank" style="font-family:arial">chughes@co.lincoln.or.us</a>><br style="box-sizing:border-box"> <strong style="box-sizing:border-box;font-weight:700;font-family:arial">Sent</strong>: 1/5/23 4:27 PM<br style="box-sizing:border-box"> <strong style="box-sizing:border-box;font-weight:700;font-family:arial">To</strong>: geomoose-users-osgeo <<a href="mailto:geomoose-users@lists.osgeo.org" target="_blank" style="font-family:arial">geomoose-users@lists.osgeo.org</a>><br style="box-sizing:border-box"> <strong style="box-sizing:border-box;font-weight:700;font-family:arial">Subject</strong>: [GeoMoose-users] One to Many Join - GeoMoose 3</span></div><div style="box-sizing:border-box;font-family:arial"><br style="box-sizing:border-box"></div><div style="box-sizing:border-box;font-family:arial"><span style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;box-sizing:border-box;background-color:rgb(255,255,255);color:rgb(0,0,0)">Hello all,</span></div><div style="box-sizing:border-box;font-family:arial"><span style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;box-sizing:border-box;background-color:rgb(255,255,255);color:rgb(0,0,0)"><br style="box-sizing:border-box"></span></div><div style="box-sizing:border-box;font-family:arial"><span style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;box-sizing:border-box;background-color:rgb(255,255,255);color:rgb(0,0,0)">I was curious if anyone's tried to do a join (in my case one-to-many) in GeoMoose 3.</span></div><div style="box-sizing:border-box;font-family:arial"><span style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;box-sizing:border-box;background-color:rgb(255,255,255);color:rgb(0,0,0)"><br style="box-sizing:border-box"></span></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;box-sizing:border-box;background-color:rgb(255,255,255);color:rgb(0,0,0)">I have a shapefile of parcels that I was trying to join to a dbf of related information for each parcel.</div><div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;box-sizing:border-box;background-color:rgb(255,255,255);color:rgb(0,0,0)">I was following the mapserver documentation for joins <a href="https://mapserver.org/mapfile/join.html" id="m_-856113953552453035LPNoLPOWALinkPreview" rel="noopener noreferrer" style="box-sizing:border-box;text-decoration:underline;font-family:Calibri,Arial,Helvetica,sans-serif;color:rgb(0,102,147)" title="https://mapserver.org/mapfile/join.html" target="_blank"> Here</a> but I couldn't figure out how to convert the mapserver format where the templates and joins are specified in the mapfile to the GeoMoose 3 format where the templates are set in the mapbook.xml. I couldn't get results to reflect the JOIN parameters that were set in the mapfile.</div><div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;box-sizing:border-box;background-color:rgb(255,255,255);color:rgb(0,0,0)"><br style="box-sizing:border-box"></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;box-sizing:border-box;background-color:rgb(255,255,255);color:rgb(0,0,0)">Any feedback would be appreciated,</div><div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;box-sizing:border-box;background-color:rgb(255,255,255);color:rgb(0,0,0)"><br style="box-sizing:border-box"></div><div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;box-sizing:border-box;background-color:rgb(255,255,255);color:rgb(0,0,0)">Chris</div><div style="box-sizing:border-box;font-family:arial"><br style="box-sizing:border-box"></div><div style="box-sizing:border-box;font-family:arial"><div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;box-sizing:border-box;color:rgb(0,0,0)"><br style="box-sizing:border-box"></div><div id="m_-856113953552453035x_Signature" style="box-sizing:border-box;font-family:arial"><div style="box-sizing:border-box;font-family:arial"><div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;box-sizing:border-box;color:rgb(0,0,0)"><span style="font-size:15px;text-align:start;box-sizing:border-box;font-family:Calibri,Arial,Helvetica,sans-serif;display:inline!important;background-color:rgb(255,255,255)">--</span><br style="font-size:15px;text-align:start;background-color:rgb(255,255,255);box-sizing:border-box"><div dir="ltr" style="font-size:15px;margin:0px;text-align:start;box-sizing:border-box;font-family:Calibri,Arial,Helvetica,sans-serif;background-color:rgb(255,255,255)"><div dir="ltr" style="margin:0px;box-sizing:border-box;font-family:Calibri,Arial,Helvetica,sans-serif">Chris Hughes<div style="font-size:12.79px;margin:0px;box-sizing:border-box;font-family:Calibri,Arial,Helvetica,sans-serif"><br style="box-sizing:border-box"></div><div style="font-size:12.79px;margin:0px;box-sizing:border-box;font-family:Calibri,Arial,Helvetica,sans-serif">GIS Analyst</div><div style="font-size:12.79px;margin:0px;box-sizing:border-box;font-family:Calibri,Arial,Helvetica,sans-serif">Lincoln County GIS Department </div><div style="margin:0px;box-sizing:border-box;font-family:Calibri,Arial,Helvetica,sans-serif"><span style="font-family:Roboto,arial,sans-serif;margin:0px;box-sizing:border-box"><a href="https://www.google.com/maps/search/880+NE+7th?entry=gmail&source=g" style="font-family:Roboto,arial,sans-serif">880 NE 7th</a> S</span><span style="font-family:Roboto,arial,sans-serif;margin:0px;box-sizing:border-box">t</span>. l Newport, OR 97365</div><div style="font-size:12.79px;margin:0px;box-sizing:border-box;font-family:Calibri,Arial,Helvetica,sans-serif">Tel: (541) 574 1283</div></div></div><br style="box-sizing:border-box"></div></div></div></div></div></div></div>
_______________________________________________<br>
GeoMoose-users mailing list<br>
<a href="mailto:GeoMoose-users@lists.osgeo.org" target="_blank">GeoMoose-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/geomoose-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/geomoose-users</a><br>
</blockquote></div></div>