• 0 Vote(s) - 0 Average
  • 5
  • 4
  • 3
  • 2
  • 1
Thread Modes

SQL Condition in workflow
#1
Hello,

We are in the process of consolidating our onboarding process. We have a workflow where HR puts in an initial Service Request with employee information which goes to another group of users which fill out a questionnaire detailing what the employees need. It is a 5-part questionnaire - Account/Hardware/Software/Phone/Internal Apps. At the beginning of each section, there is a Yes/No radio button on if the employee needs anything from the following section. If yes is selected, that portion of the workflow should be kicked off. If no, it is not. 

Our current conditional step is : 

SELECT question_id
FROM sd_question_result 
WHERE request_id = @@ID@@ 
AND question_id = xxx 
AND result in ('1')

However we have modified this conditional step, the workflow never proceeds. We have been trouble shooting this for a couple days now and any help would be greatly appreciated. Please let me know if I can provide any other information.


Chris
cbarnett, proud to be a member of EV CONNECT FORUM since Oct 2019.


Messages In This Thread
SQL Condition in workflow - Chris - 11-12-2019, 12:48 PM
RE: SQL Condition in workflow - Andrew - 11-12-2019, 01:55 PM
RE: SQL Condition in workflow - Chris - 11-12-2019, 02:24 PM
RE: SQL Condition in workflow - Andrew - 11-12-2019, 03:23 PM
RE: SQL Condition in workflow - Chris - 11-12-2019, 03:36 PM




Users browsing this thread: 1 Guest(s)