The missing items don’t pass through, since MySQL returns nothing. The MySQL node is only producing 1 empty item (when the MySQL query returns no results) regardless of how many queries it cycles through, so I can go back to a previous node and get the data for 1 “false” result, but only for 1 of the items that passed through in the run. If I query 50 IDs in MySQL, all separately, and they all have no results, I will get 1 response from MySQL instead of 50, thus only being able to process 1 item down the line.
Like this:
Here is someone with a similar issue in terms of a “no results” MySQL query, however, the solution he is using doesn’t work for me: How can I validate with IF Block when MySQL Node returns nothing? - #6 by MutedJam
In my scenario I’m using a boolean true/false in the IF node to check if a item is present in the results, in the solution there provided by MutedJam he is using an “If field is empty” in his IF node. Either works, but again, since MySQL only returns 1 empty item, the remaining items in my queue don’t process.
Typically I use a Merge node to work around this, but in this case I haven’t been able to come up with a way to make it work. I don’t care whether I use a Merge node or not, I just need it to iterate though all of the the “False” items, not just one.
I’m assuming that the MySQL node when it gets 50 inputs, it is querying 50 times, so I’m not sure why it only returns 1 empty item, but that’s what it’s doing. I do not have “Execute Once” checked, and I do have “Always Output Data” checked.