AnsweredAssumed Answered

Workflow Oracle SQL Queries? (Specify content column names)

Question asked by stempb on Feb 4, 2016

I was able to get Store default result working in a Nintex Workflow using an Oracle SQL query   but I do not understand how the Specify column names is supposed to work.   Can someone please explain how this is supposed to work?   I checked the help file but it is almost no help at all.

 

 

My query is

select b.cstbuildingidtx from tridata.CSTLOCATIONVIEW b order by b.cstregioncodetx

 

What I did was to enter b.cstbuildingidtx   for the Column to retrieve and tied that to a collection variable but I am getting zero results in the collection.   What am I doing wrong?

Outcomes