Workflow and query sql database

Permanently deleted user

07 Juli 2011 14:36

I want add a query to sql database in workflow designer. Anyone ever do that?

0

• 

  Permanently deleted user

  21 Juli 2011 11:23

  I like to do the same thing as well!! 

  Is it possible?  And has anybody got it working?

  0
• 

  Permanently deleted user

  30 Januari 2012 10:10

  I have got the same question too.

  Anyone please advise how you managed to make it work?

  Thanks!

  0
• 

  Permanently deleted user

  30 Januari 2012 15:24

  Hi all,

  You might want to look into these activites found on codeplex: http://wf.codeplex.com/releases/view/43585

  Sune

  0
• 

  Permanently deleted user

  03 Februari 2012 07:14

  Hi Sune,

  This looks like a service park to general WF.

  Would it possibly influence the Geocortex Workflow app?

  Thanks

  Alex

  0
• 

  Ryan Cooney

  03 Februari 2012 07:35

  If you put the Microsoft.Data.Activities.dll and Microsoft.Data.Activities.Design.dll assemblies into the Workflow Designer directory "C:\Program Files (x86)\Latitude Geographics\Geocortex Essentials\<INSTANCE>\Workflow Designer" the activities will appear in the "Other" category of the Toolbox and you can use them. When you deploy your workflow to the Essentials Site you will need to put the Microsoft.Data.Activities.dll assembly into the "C:\Program Files (x86)\Latitude Geographics\Geocortex Essentials\<INSTANCE>\REST Elements\REST\bin" directory so that Essentials can run the activities.

  --Ryan

  0
• 

  Permanently deleted user

  11 Maj 2012 21:26

  Thanks for this tip Ryan implementing something like the WF ADO.NET Activity Pack to interact with SQL was exactly the type of thing I was looking for!

  -Alex

  0
• 

  Permanently deleted user

  11 Maj 2012 22:32

  I was successful in integrating the ExecuteSqlNonQuery into a workflow (Very cool, by the way ), I'm wondering if anybody has been successful in utilizing the ExecuteSqlQuery and return the results to the viewer in a table?

   

  If so could you post how to go about returning the results to the viewer.

   

  -Alex

  0
• 

  Permanently deleted user

  26 Maj 2012 01:05

  Alex, returning the results to the viewer would not be possible, as the viewer's controls are expecting ESRI recordset objects, not ADO.NET types.  You'd need to write your own module and include it into the silverlight viewer, or open it into your own way.  The easiest thing I can think to do would be to save it as a CSV and then you can have it downloadable by the user.  This would be possible without any programming.

  0
• 

  Permanently deleted user

  26 Maj 2012 01:12

  Thank you Shawn

   

  -Alex

  0

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