@ninja
You need to understand how reservation works. The SQL INSERT/UPDATE statements executed in reservations tab are not committed on the mysql Database. They are maintained in separate reservation tables handled by WFA.
Hence you can't see the impact of those SQL queries by looking into DB. You can only see them through WFA.
So how do you see that your reservations got executed the way you wanted to?
1. There will be an entry in Execution->Reservation table for the execution job. If you have properly written Reservation representation string, you can see the values of the variables.
2. The 2nd and better way is to use User-Input of type query to your service. So have a 'Test Reservation workflow' to help you.
Add a workflow and put a 'Search or Define command'. Or you can put any command you wish.
Don't select any dictionary, just press Ok
In constants tab, have a constant named; QUERY , value: $query
Now you have a user-input to your workflow.
Chnage its type from string to 'Query'.
Now when you write your query, and do TEST you'll have option check-box to use reservation data.
SO now the rows will show : data in DB + Data due to reservation
You can uncheck it to see the difference your reservation is making.
Save your workflow for all your future Reservation tests.
sinhaa
If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.