Set SqlQuery Command text (GE3.10 / SL1.6)

Permanently deleted user

October 25, 2012 04:26

Hi to all

has anyone figured out how to set the Command for the SqlQuery Activity to the string variable previously set in the workflow?

I want to organise the workflow so that the command is effectively dynamic based on user selections etc

Thanks

Ralph

0

• 

  Ryan Cooney

  October 25, 2012 05:41

  Hi Ralph,

  The Command is a property rather than an argument so it cannot be set using a variable. It must be configured directly by the workflow author. You can still pass variable values to the activity by using the Parameters collection. We have used this pattern to prevent SQL injection attacks.

  --Ryan

  0
• 

  Permanently deleted user

  October 25, 2012 06:16

  Hi Ryan

  thanks for reminding me that 'there is more than one way to skin the cat'.

  All working now.

  The other part of the problem was that I wanted to run the workflow from a button in the SL Viewer using using:

  • Command being: RunWorkflowWithArguments
  • Command Parameter being: WorkflowID=processUnmatchedParcels&argTopologyType=primary

  Unfortunately the Button was remaining greyed out in the Viewer.

  Do all args need to be supplied that the workflow may expect OR will the ones specified just overwrite/replace the ones set as properties already against the Workflow in the Site?

  Any clues on what was stopping the button for being Enabled?

  To work around this for the moment I have two workflows configured in the site that are pointing at the same .xaml file with different properties set against them.

  Thanks

  Ralph

  0
• 

  Ryan Cooney

  October 25, 2012 12:26

  Hi Ralph,

  I'm not sure if this is what is happening in your case, but we fixed a bug today where a button configured to use the RunWorkflowWithArguments command would be disabled if it was in the first tab of the toolbar and the toolbar was open by default. If the toolbar was closed on startup it would be fine. This fix will be in 1.7.

  --Ryan

  0
• 

  Permanently deleted user

  October 26, 2012 01:54

  Hi Ryan

  yes indeed it is on the first tab. I had forgotten that Malcolm had mentioned that in another thread. The site/viewer that yesterdays problem was around was a site that I am working on being cut down with a custom tab as the first tab with custom tools there.

  So yes great news to hear that it is fixed. You may or may not be able to comment but is it still looking good for a release at the end of the month?

  Thanks

  Ralph

  0

Please sign in to leave a comment.