layer filter workflow with where clause 'IN' argument?

Permanently deleted user

11 Maj 2016 05:12

I've created an additional 'in' argument for the built in layer filter workflow for the where clause as a string but it doesn't seem to be getting passed to the layer. Works fine if I hardcode "OCI=1" or use a variable "OCI=1" and assign that to the output arugment 'where'. But if I use that as a string input argument the filter is not applied. Is this doable?

0

• 

  John Nerge

  13 Maj 2016 14:33

  Can you post the workflow xaml and/or the where clause you want to use? Maybe there's a syntax issue with your query that's using IN.

  0
• 

  Permanently deleted user

  25 Maj 2016 22:27

  Thanks John,

   

  I mean to say 'IN' in terms of an in argument to the workflow rather than as part of the query or like an SQL IN clause. My query uses "OCI=1" as the where clause but what I would like to do is pass that query in as an argument to the workflow. I've had success with a variable for that query but not an argument.

  0
• 

  John Nerge

  03 Juni 2016 13:33

  Not sure if you tried this or not, but what about using an Assign activity to assign the value of your argument string to a new variable string? It sounds like it's working if you use a variable and assign it for your Query Task where clause, so maybe that extra step will take care of whatever reason the argument string isn't working.

  0

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