I need to get an attribute value of a selected polygon in job assignment. It's best that I can do this from SQL.
Any idea ?
i will answer and what i understood from your question is that you need to get the LOI from the job id
you have many options to get the LOI
2- you can publish the LOI as a map service and this optional when you publish the workflow manager service. then you can query the map services by jobid
3- your question about using the SQL : i think you can use SQL SDE commands refering to the following URIs:
SQL reference for query expressions used in ArcGIS—ArcGIS Pro | ArcGIS Desktop
Workflow: Use SQL with existing feature classes—Help | ArcGIS Desktop
i hope this is helpful for you
As part of our longterm roadmap we are planning on allowing you to associate a record of a feature (in a feature service) to a job and use the attributes as extended properties.
Would this resolve your request?