Workflow Soluiton

 View Only
  • 1.  how do I go from a value to an ID

    Posted Jun 23, 2010 10:32 AM
    I'm using WorkFlow 7.0 to create a SelfService Form integrating with HelpDesk 6. I have a drop down for urgency with the values (high, medium, low)that corresponds to my urgency lookup table in HelpDesk. When I am going from my form to create ticket component how do I translate the value "High" to ID "1" which is what Helpdesk is expecting Thanks in advance


  • 2.  RE: how do I go from a value to an ID

    Posted Jun 23, 2010 01:44 PM

    You could do this in a number of ways... the easiest way would probably be to use a Matches Rule component and introduces the ID value on the path for you to use, depending on the values High/Medium/Low.


  • 3.  RE: how do I go from a value to an ID
    Best Answer

    Posted Jun 23, 2010 01:49 PM
    I would tie this directly to the table in helpdesk that supplies the possible values.  By using the SQL Table Generator integration builder and connecting that to the workitem urgency lookup table, you would get all the setup you need.  Then you can display all possible values in a drop down list, and the data type of the output will already have the corresponding ID value.


  • 4.  RE: how do I go from a value to an ID

    Posted Jun 24, 2010 09:44 AM
    Aaron.....Thanks.....took your advice ....works like a charm
    reecardo...thanks for your imput as well