topic Re: Possible to include SQL view in OFFLINE Collector? in ArcGIS Collector Questions https://community.esri.com/t5/arcgis-collector-questions/possible-to-include-sql-view-in-offline-collector/m-p/656160#M11322 <HTML><HEAD></HEAD><BODY><P>As an alternative - There have been posts here on how to use Arcade to change the symbols based on related records.&nbsp;&nbsp;</P><P></P><P>Edit: found it&nbsp;<A href="https://community.esri.com/thread/243196-dynamic-symbology-based-on-days-passed">https://community.esri.com/thread/243196-dynamic-symbology-based-on-days-passed</A>&nbsp;</P></BODY></HTML> Mon, 24 Feb 2020 23:42:49 GMT DougBrowning 2020-02-24T23:42:49Z Possible to include SQL view in OFFLINE Collector? https://community.esri.com/t5/arcgis-collector-questions/possible-to-include-sql-view-in-offline-collector/m-p/656159#M11321 <HTML><HEAD></HEAD><BODY><P>We have the following:</P><UL style="margin-top: 0in;"><LI>Sewer Main=feature class</LI><LI>Sewer_SLRAT_Insp=related table</LI><LI>SEWER_MAIN_RAT_REL=Relationship class between fc and table (1:M)</LI><LI>v_WC_SLRatInsp=SQL view of related table</LI></UL><P>&nbsp;</P><P>The related table holds inspection data (many records for each Sewer Main record).&nbsp;</P><P>The SQL view filters down to only the single most RECENTLY DATED record from the inspection table for each Sewer Main feature.&nbsp;</P><UL><LI>&nbsp;Service 1:&nbsp; Feature class joined to related table.&nbsp; Used to ADD new inspection records; shows all related records.&nbsp; Published with SYNC, no problem.</LI><LI>Service 2:&nbsp; Feature class joined to SQL View.&nbsp; Used only to symbolize whether the Sewer Main has been inspected after a certain date.&nbsp; Cannot publish with SYNC capability (see attached screen shot).&nbsp;&nbsp;</LI></UL><P>&nbsp;</P><P>Everything is working fine in Collector in connected mode.</P><P>&nbsp;</P><P><STRONG>The question I have is…can an MXD that contains a S<SPAN style="text-decoration: underline;">QL view</SPAN> be published with SYNC capability (and thus be taken offline in Collector)?</STRONG>&nbsp;&nbsp;</P><P></P><P>Software:&nbsp; ArcGIS 10.3, Server 10.3,&nbsp;SQL Server</P><P></P><P>Thanks,</P><P>Jay</P></BODY></HTML> Wed, 04 Apr 2018 22:22:32 GMT https://community.esri.com/t5/arcgis-collector-questions/possible-to-include-sql-view-in-offline-collector/m-p/656159#M11321 JayJohnsonWashoeCounty 2018-04-04T22:22:32Z Re: Possible to include SQL view in OFFLINE Collector? https://community.esri.com/t5/arcgis-collector-questions/possible-to-include-sql-view-in-offline-collector/m-p/656160#M11322 <HTML><HEAD></HEAD><BODY><P>As an alternative - There have been posts here on how to use Arcade to change the symbols based on related records.&nbsp;&nbsp;</P><P></P><P>Edit: found it&nbsp;<A href="https://community.esri.com/thread/243196-dynamic-symbology-based-on-days-passed">https://community.esri.com/thread/243196-dynamic-symbology-based-on-days-passed</A>&nbsp;</P></BODY></HTML> Mon, 24 Feb 2020 23:42:49 GMT https://community.esri.com/t5/arcgis-collector-questions/possible-to-include-sql-view-in-offline-collector/m-p/656160#M11322 DougBrowning 2020-02-24T23:42:49Z