Latest Contributions by SimonMorgan

Robert, I have a question. I just switched one of my esearch widgets over to the new 2.5.0.7 XML format. This is how I setup the link: <links>     <link includeinresults="false" field="WEB_URL" alias="School Website">      <linkprefix></linkprefix>      <linksuffix></linksuffix>      <iconfield></iconfield>      <iconprefix></iconprefix>      <iconsuffix></iconsuffix>     </link>    </links> I am NOT getting the default icon int he search results window. I do get the link in the popup and the link in the datagrid (I have that setup in fields). ... View more

Thanks for the quick reply!!! Any plans to incorperate this into a future release? So if I convert this table into a point layer and give each record the geometry of the related existing point, could I just turn off symbology in the map document and accomplish the same thing? Thanks! I kind of acheieved what you are looking for. I have a point layer of schools and a table only dataset with a list of school reservations. I wanted Robert's tool to return the location of every schoool that had made a reservation. I did it using a little SQL: <definitionexpression>     EXISTS (SELECT * FROM central2.GISADMIN.TRPD_Schdgrps_Schools     WHERE central2.GISADMIN.MN_Schools_PUBLIC.ORGID_REL = central2.GISADMIN.TRPD_Schdgrps_Schools.School_Code)    </definitionexpression>    <enableexport>true</enableexport>    <name>Minnesota Schools - Users</name>    <url>http://[server]/ArcGIS/rest/services/swan/CRANE_alldata/MapServer/1</url>    <expressions>     <expression alias="All users"        textsearchlabel="Search for all non-user schools"        userlist="1=1">[value]</expression>     <expression alias="All users by time period"        textsearchlabel="Enter a year (2010) or a time period (2010 Q1)">        EXISTS (SELECT * FROM central2.GISADMIN.TRPD_Schdgrps_Schools        WHERE central2.GISADMIN.MN_Schools_PUBLIC.ORGID_REL = central2.GISADMIN.TRPD_Schdgrps_Schools.School_Code        AND central2.GISADMIN.TRPD_Schdgrps_Schools.TimePeriod LIKE '%[value]%')</expression>     <expression alias="Multiple reservations"        textsearchlabel="Enter a year (2010) or a time period (2010 Q1)">        gisadmin.MN_SCHOOLS_PUBLIC.ORGID_REL IN        (SELECT tss.School_Code FROM central2.gisadmin.TRPD_SCHDGRPS_SCHOOLS tss        WHERE tss.TimePeriod Like '%[value]%' GROUP BY tss.School_Code HAVING COUNT(*) > 1)</expression>     <expression alias="Single reservation"        textsearchlabel="Enter a year (2010) or a time period (2010 Q1)">        gisadmin.MN_SCHOOLS_PUBLIC.ORGID_REL IN        (SELECT tss.School_Code FROM central2.gisadmin.TRPD_SCHDGRPS_SCHOOLS tss        WHERE tss.TimePeriod Like '%[value]%' GROUP BY tss.School_Code HAVING COUNT(*) = 1)</expression>     <expression alias="School Name"        textsearchlabel="Search for schools by name">        SCHNAME Like '%[value]%'</expression>     <expression alias="Type of School"        textsearchlabel="Search for schools by type"        userlist="ELEM,MIDD,HIGH,ALC,SECOND FACILITY COOP,CHARTER,COLLEGE,COOP,        CORRECTIONAL,EDUCATION_DISTRICT,DISTRICT-OTHER,        INDEPENDENT,INTERMEDIATE DIST,OFFICE,OTHER,SPECIAL">SCH_TYPE1 LIKE '%[value]%'</expression>     <expression alias="School District Number"        textsearchlabel="Search for schools by Schoo District Number">        SDNUM = [value]</expression>    </expressions> You will notice that in the definition query tag, I used the exists command of SQL. ArcGIS automatically starts every query with the select statement, so you essentially can only build a query after "select * from where" and so you do not need to type that as you may already know. EXISTS (SELECT * FROM central2.GISADMIN.TRPD_Schdgrps_Schools     WHERE central2.GISADMIN.MN_Schools_PUBLIC.ORGID_REL = central2.GISADMIN.TRPD_Schdgrps_Schools.School_Code) This query essentially looks at the schools table and only returns schools that have a matching school ID in the reservations table. Just thought I would share, it may not do exactly what you need, but hopefully it was helpful! One thign to note, this query may not give an expected result if your table is registered as versioned because it does nto query the  A and D tables. ... View more

Simon,    It is not a bug, it seems that it is a feature that was added as in the code they are calling createFeatureLayersFromDynamicMapService for all DynamicMapServices to see if there is a corresponding FeatureService and if there is present that as an editable layer. So yes it seems you have to do the extra steps of excluding those. Thank you for clarifying. I did not notice this listed in the waht's documentation. Luckily I have only just started making sure all my apps work with 2.5 so I may rethink how I have some of them configured. ... View more

Simon,    All you need to do is exclude the unwanted layers in the EditWidget.xml <excludelayer>Park District Base Map</excludelayer> and change the others back to type="feature" and url="http://[server]/ArcGIS/rest/services/swan/CRANE_alldata/FeatureServer/3"/> My apologies I did not explain very well. I know how to fix this. The ones that are type feature and point ot the mapserver endpoint are INTENDED to be that way, so no issue there. As for the exclude layer, I had already done that, it just seems that at 2,4 I did not need to for a DYNAMIC layer. Maybe this is a bug? My concern is that when I migrate all my current apps from 2.3.1 to 2.5 I will need to go in and do a whole bunch of exclude layer entries that I did not need to do before. ... View more

Simon,    You should win a prize for this. Some how you choose the one programmatic path that I missed a step in. Because you were using a layer with multiple relates and you did not define specific return fields for any of the relates the oid was not getting passed to the query... Anyway I have it fixed and will get it released ASAP. Thanks for using my new feature and helping me fine tune it. Version 2.5.0.4 - 12/7/2011 * Fixed a relate query error that only occurred in certain situations Much obliged Robert. Thank you very much for all of your hard work!!! ... View more

Simon,    Care to provide a specific example I can using in the testing? If you do a search for Jackson Middle, then you should get a result that has related records in all 3 relates. When I do use the query related tables link on the rest end point pages I get results. ... View more

Simon,    Try downloading again. I updated the zip to ensure the correct number of assets in each folder. I will add attachment support to the wish list, although I am getting concerned that this widget does to much (the main mxml is nearly 4000 lines of code. and has 22 supporting files). Thanks for doing that!! I am having an issue with relates again. The relate button displays but says there are no related records, even for schools where I know there are multile related records. <layer>    <definitionexpression></definitionexpression>    <enableexport>true</enableexport>    <name>Minnesota School</name>    <url>http://gis.threeriversparkdistrict.org/ArcGIS/rest/services/swan/CRANE_alldata/MapServer/1</url>    <expressions>     <expression alias="School Name" textsearchlabel="Search by school name...">SCHNAME LIKE '%[value]%'</expression>    </expressions>    <graphicalsearchlabel>Use one of the graphical search tools to select schools</graphicalsearchlabel>    <spatialsearchlayer>true</spatialsearchlayer>    <titlefield>SCHNAME</titlefield>    <fields all="false">     <field name="SCHNAME" gridfield="true"/>     <field name="SDNUM" gridfield="true"/>     <field name="WEB_URL" gridfield="true" hyperlinkgridfield="true"/>    </fields>    <linkfield>WEB_URL</linkfield>    <icon isfield="false"></icon>    <zoomscale usegeometry="true"/>    <autoopendatagrid>false</autoopendatagrid>    <relates>     <relate id="0" label="Reservations">      <fields all="true" />     </relate>     <relate id="1" label="Enrollment by Gender and Ethnicity">      <fields all="true" />     </relate>     <relate id="2" label="Enrollment by Special Populations">      <fields all="true" />     </relate>    </relates>   </layer> Any ideas? ... View more

Simon,    I used your xml you provided and searched for "Weaver lake Elem" and the reservation for that school came up fine. I did several things, including clearing my rest cache, copying the widget you had precompiled (instead on the one I had compiled with my viewer), and made sure all the assets were in place and now it works. As a side note the images folder in eSearch\uncompiled\eSearch\assets\images has 21 images and the images folder in eSearch\FV2.5compiled\eSearch\assets\images only has 17. Just wanted to let you know. Thank you for this GREAT widget. I know the code base is complex for this widget but would you entertain a request to bring attachments to this widget like your infotemplates widget? ... View more

Robert, I am trying to get the relate feature to work, any ideas why it doesn't: <layer>    <definitionexpression></definitionexpression>    <enableexport>true</enableexport>    <name>All Minnesota Public Schools</name>    <url>http://[server]/ArcGIS/rest/services/swan/CRANE_alldata/MapServer/1</url>    <expressions>     <expression alias="School Name" textsearchlabel="Search for schools by name">SCHNAME Like '%[value]%'</expression>     <expression alias="Type of School" textsearchlabel="Search for schools by type" userlist="ELEM,MIDD,HIGH,ALC,SECOND FACILITY COOP,CHARTER,COLLEGE,COOP,CORRECTIONAL,EDUCATION_DISTRICT,DISTRICT-OTHER,INDEPENDENT,INTERMEDIATE DIST,OFFICE,OTHER,SPECIAL">SCH_TYPE1 LIKE '%[value]%'</expression>     <expression alias="School District Number" textsearchlabel="Search for schools by Schoo District Number">SDNUM = [value]</expression>    </expressions>    <graphicalsearchlabel>Use one of the graphical search tools to select schools</graphicalsearchlabel>    <spatialsearchlayer>true</spatialsearchlayer>    <titlefield>SCHNAME</titlefield>    <linkfield linkprefix="" linksuffix="">WEB_URL</linkfield>    <icon isfield="false" iconprefix="" iconsuffix=""></icon>    <fields all="false">     <field name="SCHNAME" alias="School Name" gridfield="true"/>     <field name="ORGID_REL" alias="School Unique ID" gridfield="true"/>     <field name="ADDRESS" alias="Address" gridfield="true" gridfieldonly="true"/>     <field name="CITY" alias="City" gridfield="true" gridfieldonly="true"/>     <field name="STATE" alias="State" gridfield="true" gridfieldonly="true"/>     <field name="ZIP" alias="Zip Code" gridfield="true" gridfieldonly="true"/>     <field name="SCH_TYPE" alias="School Type" gridfield="true" gridfieldonly="true"/>     <field name="SCH_TYPE1" alias="School Type 1" gridfield="true" gridfieldonly="true"/>     <field name="WEB_URL" alias="School Website" hyperlinkgridfield="true" hyperlinkaliastext="Visit School's Website"/>    </fields>    <autoopendatagrid>false</autoopendatagrid>    <relates>     <relate id="1" label="Resevations">      <fields all="true" />     </relate>    </relates>   </layer> ... View more

Simon,    have you looked at the sum capability of the eSearch datagrid? <field name="Length_" numberformat="2|,|." sum="true" sumlabel="Total Length: " gridfield="true"/> Thank you so very much!! I have not tried it yet but I am excited to!!! I also wanted to let you know that your widgets alone have enabled us to bring GIS to over 100 users within our organization, thank you very much and have a great thanksgiving. ... View more

Robert, I have a favor to ask. I have been asked to produce a quick solution. A user would like to be bale to select some polygons and see a total pop up of population. I have the data and I am thinking modifying your widget is the way to go. Maybe add a label to the data grid that displays the total of a preset field of the results currently selected, in this case popluation. Ihave a tight turn around, could you point the way for me? Or does anyone have a simpler solution? ... View more

Simon,    Give this correction a shot: <field name="ReporterNotes" alias="Encroachment Inventory Notes" gridfield="true" gridfieldonly="true"/> Good catch, but that did not fix the issue. ... View more

Simon,    And your SearchWidget.xml configuration for this layer, I need to see that too. My apologies, that one should have been obvious: <layer>    <definitionexpression></definitionexpression>    <enableexport>true</enableexport>       <name>Encroachments</name>       <url>http://[SERVER]/ArcGIS/rest/services/PublicSafety/GPSData_v112111/MapServer/7</url>       <expressions>        <expression alias="Reported by/Badge Number" textsearchlabel="Search by badge number or reporter initials">Reporter like ('%[value]%')</expression>        <expression alias="Homeowner Visits" textsearchlabel="Search by homeowner visit status" field ="HomeowneVisit" usedomain="yes">HomeownerVisit = ('[value]')</expression>       </expressions>       <graphicalsearchlabel>Use one of the graphical search tools to select encroachments</graphicalsearchlabel>    <spatialsearchlayer>true</spatialsearchlayer>    <titlefield>Type</titlefield>       <linkfield linkprefix="" linksuffix="">GISSiteReviewPacketLink</linkfield>    <icon isfield="true" iconprefix="" iconsuffix=""></icon>       <fields all="false">     <field name="Reporter" alias="Reporter" gridfield="true"/>     <field name="GISSiteReviewPacketLink" alias="GIS Site Review Packet Link" hyperlinkgridfield="true" hyperlinkaliastext="Get Packet"/>     <field name="ReporterNote" alias="Encroachment Inventory Notes" gridfield="true" gridfieldonly="true"/>     <field name="InvDate" alias="Date Reported" gridfield="true" gridfieldonly="true" dateformat="MM/DD/YYYY" useutc="true"/>    </fields>       <zoomscale usegeometry="true">5000</zoomscale>     </layer> ... View more