Using Datalinks in Workflows
Hello,
I've watched a couple of webinars and all of them are using data from the layers in the mapservices. I already made some datalinks to the sites and now I want to use this data to make searchworkflows. I'm still using arcgis 9.3.1 and not bye version 10. Does anyone have samples where datalinks are used and are willing to share (even if it's using arcgis 10)?
Erik
-
As of today, you cannot access the datalinks data which configured on the site on the workflow designer.
You need to create custom Code Activity to get the data from the external db to use as the data source of the workflow Form control.
In the next version of GE (may be 3.7), the Geocortex Feature will contain the DataLinks data. Then, you may create a custom module to extract the datalink data from the feature (use the custom command), and pass it to the workflow as the serializable collection to use it. (That is what I can think now!).
M. Gim
0 -
Is there an other way to make a searchworkflow using attributedata that's not in a feaureclass? At the moment we use a lot of searches that search on tables rather than joining data to the featureclasses. In other words: Is it possible to make a search workflow using tables (not featureclasses) from e.g oracle/sqlserver?
0 -
In ArcGIS Server 10 you can add the table to the map service. You'll be able to access the table via the workflow.
0 -
Hello,
Is there a method yet for querying a DataLink?
0 -
Hi to all
even better now you can make use of the SQL Non-Query and SQL Query activities so you can make use of stored procedures etc.
Regards
Ralph
0 -
First of all, Site object is not available to access from the WF.
Therefore, the Datalink associated with the Layer on Site.xml (configured with Rest Manager) is not accessible on WF with the easy way.
There are few ways to consume the external db data from WF.
(1) Use the two databased activities (non-sql, and sql) on the product.
(2) On the WF, you may use the WEB Request activity to consume the REST endpoint for the Datalink (for example, http://sampleserver1.geocortex.com/geocortex/essentials/rest/sites/Charlotte/map/mapservices/Charlotte/layers/3/datalinks/ProjectsDataLink/link) or/and the Search Tables configured on Site.xml. This case you have to deal with the JSon string if the return format is Json. I used this way (esp Search Tables) when I need to implement the custom Module for the custom view to get the look up data for the VIew control.
(3) Also someone says, you can include the external table to the MXD with which Site's map service is configured, so then you can use "QueryTask" activity. I like this approach most of case.
Wish this helps out!
0 -
There is also a SearchTableParameterQuery workflow activity under Common Server, which can be used to query a Search Table that has been set up on your datalink. This activity returns a featureSet, which can then be used in a Select Features or other activity.
-Victoria
0 -
Munwhan,
if I use your method 2 and access the data link via the rest endpoint, how would I go about accessing the data in a particular field? I am trying to access this data for a search, and to populate an autocomplete box... is this possible? Thanks in advance!
Kind regards,
Thad
0 -
Both QueryTask activity and SearchTableParameterQuery activity returns the outArgument, which is Esri FeatureSet.
Therefore, I think you can get the field (column of the db table which you added on your SELECT -clause) as what you do with the FeatureSet from QueryTask for Auto-complete, doesn't it?
- Munhwan
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
9 Kommentare