<div style="font-family: arial; font-size: 14px;"><div fr-original-style="" style="box-sizing: border-box;">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 fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">Did you set DEBUG 5 and check the contents of the log file?</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;" contenteditable="false"><span fr-original-style="" style="box-sizing: border-box;"> </span></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><hr id="previousmessagehr" fr-original-style="" style="box-sizing: border-box; clear: both; user-select: none;"><div fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">From</strong>: "Christopher Hughes" <chughes@co.lincoln.or.us><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">Sent</strong>: 1/5/23 5:32 PM<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">To</strong>: geomoose-users-osgeo <geomoose-users@lists.osgeo.org>, "bfraser@geoanalytic.com" <bfraser@geoanalytic.com><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">Subject</strong>: Re: [GeoMoose-users] One to Many Join - GeoMoose 3</span></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-class="elementToProof" fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); box-sizing: border-box;">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 fr-original-class="elementToProof" fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" id="Signature" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); box-sizing: border-box;"><span fr-original-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); display: inline !important;" 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); display: inline !important; box-sizing: border-box;">--</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;" fr-original-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);"><div dir="ltr" fr-original-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; background-color: rgb(255, 255, 255);" 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; background-color: rgb(255, 255, 255); box-sizing: border-box;"><div dir="ltr" fr-original-style="margin:0px;" style="margin: 0px; box-sizing: border-box;">Chris Hughes<div fr-original-style="font-size:12.79px;margin:0px;" style="font-size: 12.79px; margin: 0px; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="font-size:12.79px;margin:0px;" style="font-size: 12.79px; margin: 0px; box-sizing: border-box;">GIS Analyst</div><div fr-original-style="font-size:12.79px;margin:0px;" style="font-size: 12.79px; margin: 0px; box-sizing: border-box;">Lincoln County GIS Department </div><div fr-original-style="margin:0px;" style="margin: 0px; box-sizing: border-box;"><span fr-original-style="font-family:Roboto, arial, sans-serif;margin:0px;" style="font-family: Roboto, arial, sans-serif; margin: 0px; box-sizing: border-box;">880 NE 7th S</span><span fr-original-style="font-family:Roboto, arial, sans-serif;margin:0px;" style="font-family: Roboto, arial, sans-serif; margin: 0px; box-sizing: border-box;">t</span>. l Newport, OR 97365</div><div fr-original-style="font-size:12.79px;margin:0px;" style="font-size: 12.79px; margin: 0px; box-sizing: border-box;">Tel: (541) 574 1283</div></div></div><br fr-original-style="" style="box-sizing: border-box;"></div></div></div></div><div fr-original-style="" id="appendonsend" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><hr style="display: inline-block; width: 98%; box-sizing: border-box; clear: both; user-select: none; break-after: page;" tabindex="-1" fr-original-style="display:inline-block;width:98%;"><div dir="ltr" fr-original-style="" id="divRplyFwdMsg" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">From:</strong> Brent Fraser <bfraser@geoanalytic.com><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">Sent:</strong> Thursday, January 5, 2023 4:06 PM<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">To:</strong> Christopher Hughes <chughes@co.lincoln.or.us>; geomoose-users-osgeo <geomoose-users@lists.osgeo.org><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">Subject:</strong>RE: [GeoMoose-users] One to Many Join - GeoMoose 3<div fr-original-style="" style="box-sizing: border-box;"> </div></div><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="font-family:arial; font-size:14px;" style="font-family: arial; font-size: 14px; box-sizing: border-box;"><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;">Hi Chris,</div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;">  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 fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;">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 fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;">Best Regards,</div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;">Brent Fraser</div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><span fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"> </span></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div><hr id="x_previousmessagehr" style="box-sizing: border-box; clear: both; user-select: none; break-after: page;" fr-original-style="box-sizing:border-box; clear:both;"><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><span fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><strong fr-original-style="box-sizing:border-box; font-weight:700;" style="box-sizing:border-box; font-weight:700;">From</strong>: "Christopher Hughes" <chughes@co.lincoln.or.us><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"> <strong fr-original-style="box-sizing:border-box; font-weight:700;" style="box-sizing:border-box; font-weight:700;">Sent</strong>: 1/5/23 4:27 PM<br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"> <strong fr-original-style="box-sizing:border-box; font-weight:700;" style="box-sizing:border-box; font-weight:700;">To</strong>: geomoose-users-osgeo <geomoose-users@lists.osgeo.org><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"> <strong fr-original-style="box-sizing:border-box; font-weight:700;" style="box-sizing:border-box; font-weight:700;">Subject</strong>: [GeoMoose-users] One to Many Join - GeoMoose 3</span></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><span fr-original-style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;">Hello all,</span></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><span fr-original-style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></span></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><span fr-original-style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;">I was curious if anyone's tried to do a join (in my case one-to-many) in GeoMoose 3.</span></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><span fr-original-style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></span></div><div fr-original-style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;">I have a shapefile of parcels that I was trying to join to a dbf of related information for each parcel.</div><div fr-original-style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;">I was following the mapserver documentation for joins <a fr-original-style="box-sizing:border-box; color:rgb(0,102,147); text-decoration:underline;" href="https://mapserver.org/mapfile/join.html" id="LPNoLPOWALinkPreview" rel="noopener noreferrer" style="box-sizing: border-box; color: rgb(0, 102, 147); text-decoration: underline; user-select: auto;" title="https://mapserver.org/mapfile/join.html" target="_blank" rel="noopener noreferrer"> 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 fr-original-style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div><div fr-original-style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;">Any feedback would be appreciated,</div><div fr-original-style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div><div fr-original-style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); box-sizing:border-box;">Chris</div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><div fr-original-style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); box-sizing:border-box;" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div><div fr-original-style="box-sizing:border-box;" id="x_Signature" style="box-sizing:border-box;"><div fr-original-style="box-sizing:border-box;" style="box-sizing:border-box;"><div fr-original-style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); box-sizing:border-box;" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); box-sizing:border-box;"><span fr-original-style="font-size:15px; text-align:start; background-color:rgb(255,255,255); display:inline!important; box-sizing:border-box;" style="font-size:15px; text-align:start; background-color:rgb(255,255,255); display:inline!important; box-sizing:border-box;">--</span><br style="font-size:15px; text-align:start; background-color:rgb(255,255,255); box-sizing:border-box;" fr-original-style="font-size:15px; text-align:start; background-color:rgb(255,255,255); box-sizing:border-box;"><div dir="ltr" fr-original-style="font-size:15px; margin:0px; text-align:start; background-color:rgb(255,255,255); box-sizing:border-box;" style="font-size:15px; margin:0px; text-align:start; background-color:rgb(255,255,255); box-sizing:border-box;"><div dir="ltr" fr-original-style="margin:0px; box-sizing:border-box;" style="margin:0px; box-sizing:border-box;">Chris Hughes<div fr-original-style="font-size:12.79px; margin:0px; box-sizing:border-box;" style="font-size:12.79px; margin:0px; box-sizing:border-box;"><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div><div fr-original-style="font-size:12.79px; margin:0px; box-sizing:border-box;" style="font-size:12.79px; margin:0px; box-sizing:border-box;">GIS Analyst</div><div fr-original-style="font-size:12.79px; margin:0px; box-sizing:border-box;" style="font-size:12.79px; margin:0px; box-sizing:border-box;">Lincoln County GIS Department </div><div fr-original-style="margin:0px; box-sizing:border-box;" style="margin:0px; box-sizing:border-box;"><span fr-original-style="font-family:Roboto,arial,sans-serif; margin:0px; box-sizing:border-box;" style="font-family:Roboto,arial,sans-serif; margin:0px; box-sizing:border-box;">880 NE 7th S</span><span fr-original-style="font-family:Roboto,arial,sans-serif; margin:0px; box-sizing:border-box;" style="font-family:Roboto,arial,sans-serif; margin:0px; box-sizing:border-box;">t</span>. l Newport, OR 97365</div><div fr-original-style="font-size:12.79px; margin:0px; box-sizing:border-box;" style="font-size:12.79px; margin:0px; box-sizing:border-box;">Tel: (541) 574 1283</div></div></div><br style="box-sizing:border-box;" fr-original-style="box-sizing:border-box;"></div></div></div></div></div></div></div>