Changing the SqlQuery of a layer

TommyBouchard — Thu, 12 Dec 2024 19:08:49 GMT

Hi, I am trying to change the SqlQuery in my layer and have it update to include my new fields.

var layer = map.Layers.First(layer => layer.Name == "name");
var conn = layer.GetDataConnection() as CIMSqlQueryDataConnection;

////Changing the query
conn.SqlQuery = "select * from " + conn.SqlQuery.Split(" from ").Last();
layer.SetDataConnection(conn, true);

My goal is to have all my new fields displayed in the table view.

The fields are not recalculated by SetDataConnection.

Is there a way to always view all my fields?

Thanks
Tommy

topic Changing the SqlQuery of a layer in ArcGIS Pro SDK Questions