No doing change in subflow

General
1

Hi

I've got a subflow within my setup that does a SQL select and then has a change node after, but for some reason it's never going to the change. if I put a debug in after the SQL command I can see it's returning values in the payload.

I've tried with a different node but it' s like it's neverdoing anythign after the MSSQL node and I can't figure out why as it's not throwing any errors, and if it was I wouldn't expect anything to appear in the debug 2

image
image797Ă—217 19 KB

2

Hi.

No magic answer from me here.

But I'm confused.

I (now) realise this is the subflow.

So the sql node does what it does. I'm also not an sql person.

So it does what ever it does.

As debug nodes don't work in subflows, I'd suggest you move the two nodes out of the subflow and see what is happening there.
(Maybe on their own tab.)

Do that and link to the sql node and put the debug node - showing entire message.

What do you get there?

Then: what is the change node doing?
Only for the sake of easy viewing, open/edit it and post a screen shot.

Hope this helps in some way.

3

The debug does work in subflow as I'm getting the message from debug2? However if that was the case it's still not going to the change as the payload doesn't have the new field I created in the change in the subworkflow.

I've got a very similar thing in another subflow which works fine which is why it's confusing me even more.

I've put the nodes into a main flow instead of a subflow and it works fine

4

Move the nodes around a bit to verify the wires are connected where you think they are.

2 Likes
5

Oh. Ok. Sorry. It's been a long time for me.

Does debug2 show the entire message?

Could you post it?
(Not that it would mean much for me)
But....

6

That's what it was :tired_face: thanks all for your help