Question

Photo of Nzeacha Walter

0

VIew Result of an "SELECT" SQL request in a "Run SQL" action of an Workflow

1

I want to know how to get result of an SQL request "SELECT" in a "Run SQL" action of a Workflow. What type of attribute can store that? and how to print it in a "User Entry Form"? Please I need your help.

  • Photo of Nick Airdo

    0

    If you don't like my answer you might consider asking this question in the General Use Q &A. I believe that many more regular admins have been building complex workflows than the developers have. :)

    While I have not created many Workflows, I did make one that I described in an answer to Jeremy's question here. As you can see from the screenshot in my "Get Category" action, I pull the SQL select value into an attribute value of the workflow. (I'm pretty certain the value from the select is going to be cast as a string so you should probably use a Text type attribute too.) Then you can do what you want with it -- even display it in a workflow form via Lava as mentioned in the Lava Tips For Workflows chapter of the Workflows book.