My question is not about WAB but I'm sure you guys can help me out.
I have polygon layer A and a layer B
When there's a new polygon created in layer B, I need to compare that polygons with all the polygons in A layer and the get an ID field from layer A. I'd like to do this in SQL.
Thanks for your help.
I'd like to do this in SQL.
There lies the issue. You could do this using a queryTask (spatial Query) in JS, but not sure what this requirement for SQL is.
Could you please tell me more about the issue I could run into ?
I plan to use update trigger in SQL table B. When there's new record -> compare 'shape' fields from both tables and get & return me a field I need from table A. It's strictly SQL because I'm not calling this from any JS app. I just need that field added to a SQL table. I'm stuck at the syntax to compare the 'shape' fields. Thanks.
I can not provide any help on database triggers. This is something you should post to a https://community.esri.com/community/gis/enterprise-gis/arcgis-for-server?sr=search&searchId=ded7e84... or a SQL server forum.