Workflow Soluiton

 View Only

Use a value to find a match(es) in a table

  • 1.  Use a value to find a match(es) in a table

    Posted Mar 02, 2009 11:29 AM

    I am building a workflow and I 've ran into some problems regarding SQL and building form logic.

     

    The basic logic of this flow is that a user will be able to pick values through dropdowns and depending on which value they pick the value should be compared to tables and when the match is found, that column will present further choices. The thing I haven’t worked out yet is how to create this match table function. My final goal is to build an array out of the result of the match.

    I've tried to solve this challange in two ways:

    First: I tried the “Find Rows in dynamic data” without any success. When i press the “…” next to the “Input Rows Variable name” I should be presented with a possibility to pick variable or/and arrays but the list i completely empty. This is odd because I do exactly as the help instruction tells me.

    <o p=""></o>Secondly: I have also tried the "Select Command Component" but it throws "The multi-part identifier "c.Name" could not be bound." when I try my query. The query works fine when asked through the SQL server.

     

    Any help is appreciated.

     

    Cheers,

    Patrik