display non spatial data in popup

Permanently deleted user

03 Juli 2013 21:32

I am using the sql activity to query an access table.  is there anyway to display the query results to the user in the results section, or a popup window or as a data link that is established in a workflow?

Bigger question is how do you display stand alone table records in the viewer to the users?

J

0

• 

  Permanently deleted user

  03 Juli 2013 22:04

  I have the same issue I have a workflow that uses a routing task and I would like to display the driving directions but there is currently not an option that I could find on how to display the results. There isn't an activity to display results in the form builder that I am aware of. It would be nice if there was a region for displaying results from non-spatial data sources in the viewer. I would like to how others are handling displaying non-spatial data or is this even possible in the current enviornment.

  0
• 

  Permanently deleted user

  03 Juli 2013 23:28

  You can use the SelectFeatures workflow activity with non-spatial data. In your example you could take the datatable from your sql query activity and convert it to a featureset using the DataTableToFeatureSet activity, and then use that featureset in the SelectFeatures activity, but do not set the layer id, layer name or map service id values. The results will be displayed in the left-side region just as if they were from a spatial source.

  0
• 

  Permanently deleted user

  04 Juli 2013 01:28

  yes...the select works great, i can now select data from an access table via the sql activity, and i can display it, and i can edit values in the fields -- thank you!

   

  0
• 

  Permanently deleted user

  08 Juli 2013 10:41

  Hi Jeff, how are you editing the data? I'm querying a registered table in Arc SDE via the SQL Query activity and it doesn't allow me to edit the values at all, which makes sense as it's only a Select query. Are you running further processing in the Workflow on the datatable\featureset to enable editing?

  Thanks,

   

  Mark

  0
• 

  Permanently deleted user

  23 Augusti 2013 20:00

  i have not edited data in arcsde in a workflow with the sql activities, but i have used the sql activities to read an access table and update records there, same with an excel table. but that was only in some experiments.  it worked well if the access or excell was stored in the resources area in the virtual directory of the site folder.  these tables were also linked to my data as a dataconnection, so the changed results showed up in my map tips. i imagine you could set up a form that based on a user selection, retrieved the related records, gave the user a pulldown of possible values, then updated the related table with the sql activity, then in the next call, the changed records would appear.  but i think to edit sde tables, you should use the update records etc and have the rest site take care of updating all the delta tables etc. A stand alone table in a database, such as oracle,  would probaby work fine.

  J

  0

Du måste logga in om du vill lämna en kommentar.