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?