topic Utility Network in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/utility-network/m-p/464717#M6853 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am not working with the Utility Network, but I believe that someone here might have the right answer for me.&nbsp;</P><P><SPAN style="background-color: #ffffff;">I have a feature class with a one to many relationship to an inspection table in a SDE database. With traditional versioning I am able to create a query layer showing the most recent inspection, publishing this to Portal for ArcGIS and symbolizing the&nbsp;assets based on&nbsp;condition. I switched to branch versioning and realized that I can't do&nbsp;SQL queries anymore, however symbolizing the assets based on the last entry in the related table is crucial to the workflow.<SPAN>&nbsp;</SPAN></SPAN></P><P><SPAN style="background-color: #ffffff;"></SPAN></P><P><SPAN style="background-color: #ffffff;"><SPAN>How is querying a branch versioned services based on its related table handled in the Utility Network. I read that queries are now performed against REST API, but I have no idea how this would look like.</SPAN></SPAN></P><P><SPAN style="background-color: #ffffff;"></SPAN></P><P><SPAN style="background-color: #ffffff;"><SPAN>Thanks a lot!</SPAN></SPAN></P><P><SPAN style="background-color: #ffffff;"><SPAN>Doreen</SPAN></SPAN></P></BODY></HTML> Tue, 03 Nov 2020 19:10:57 GMT DoreenGroth 2020-11-03T19:10:57Z Utility Network https://community.esri.com/t5/geodatabase-questions/utility-network/m-p/464717#M6853 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am not working with the Utility Network, but I believe that someone here might have the right answer for me.&nbsp;</P><P><SPAN style="background-color: #ffffff;">I have a feature class with a one to many relationship to an inspection table in a SDE database. With traditional versioning I am able to create a query layer showing the most recent inspection, publishing this to Portal for ArcGIS and symbolizing the&nbsp;assets based on&nbsp;condition. I switched to branch versioning and realized that I can't do&nbsp;SQL queries anymore, however symbolizing the assets based on the last entry in the related table is crucial to the workflow.<SPAN>&nbsp;</SPAN></SPAN></P><P><SPAN style="background-color: #ffffff;"></SPAN></P><P><SPAN style="background-color: #ffffff;"><SPAN>How is querying a branch versioned services based on its related table handled in the Utility Network. I read that queries are now performed against REST API, but I have no idea how this would look like.</SPAN></SPAN></P><P><SPAN style="background-color: #ffffff;"></SPAN></P><P><SPAN style="background-color: #ffffff;"><SPAN>Thanks a lot!</SPAN></SPAN></P><P><SPAN style="background-color: #ffffff;"><SPAN>Doreen</SPAN></SPAN></P></BODY></HTML> Tue, 03 Nov 2020 19:10:57 GMT https://community.esri.com/t5/geodatabase-questions/utility-network/m-p/464717#M6853 DoreenGroth 2020-11-03T19:10:57Z