Options for joining tables/features
Hi all,
I am trying to perform a join on a point feature dataset and a corresponding table with some information about these points (one matching ID field, 1:n).
What probably will work is using the data link option and I am currently investigating that.
However, I am curious whether it is also possible to join dynamically inside the workflow. Both datasets are available in ArcGIS Server and the workflow.
Of course cascading in a DisplayForm activity should be possible with using both datasets, but I think that visualizing joined information of both datasets is not possible with that.
Can anyone help me out with the possible options here?
0
-
You can join data in a workflow, but I don't think that you'll be able to create a datalink for the app session if that is what you're after. What precisely do you want to accomplish in the workflow, some reporting? Or are you looking to view data from fields of both layers in the autocomplete box? 0 -
I have a point FS with fire hydrants and a table with inspections of these hydrants.
Relation is 1:n like:
hydrant
inspection1 hydrant1
inspection2 hydrant1
etc.
I created a workflow to query a certain set of hydrants and visualize these in the map and in a table view. In the table view, I would like to add a field with the inspection-id of the most recent inspection. This I can use to dynamically create a URL with this inspection-id value in it.
I already have some working implementation using a spatial view in SDE. Still my question is what the (best) options are in Essentials Workflow/Manager to join these two tables.
Hydrants are available via ArcGIS Server and inspections via ArcGIS Server and/or MSSQL connection. Using Workflow Designer 4.6.1.0 -
There are multiple alternatives
I would create a view in the database to join to the hydrants en the most recent inspection.
If you have created a relationship class in the database or a relate in the MXD, you can use the Relationship Query Task activity in the workflow.
But you can also just get the hydrants and the inspections in feature sets in the workflow and loop through the inspection featureset to find the most recent inspection.
Other suggestion: in the query task you can order your results, or use the out statistics property to get the max value of an attribute.0 -
Nico is right that the database view is the best way for you to move forward with regards to the most recent inspection. If what you mean by table view is the panel at the bottom of the screen with a table of all related features, you'll need the url's in the data to display it on this panel. 0
Please sign in to leave a comment.
Comments
4 comments