Row created trigger outputs in automations doesn't work in query rows filter.

[PramodThilina]

I'm working in a Inventory management system for a restaurant and need to create an automation so that when a row is created in sales table the inventory will be updated accordingly (final goal is to have it deduct ingredients from the stock ,that is used the in sold product when a sale is registered), but the issue is the trigger row outputs of row created in sales table doesn't work in the query rows filter.

I'm querying the join table to filter out the ingredients use by the product in the sale.
fk_products_sales is the foreign key in the sales table for the product id in the product table

the filter does not work and does not out put anything when testing the automation

the filter works only if i manually set a value for the product id , and not when using the binding

test run output -

i need help on how i could set up so that it use the trigger output in the query filter,
any help provided is highly appreciated 🙏

Sales Table

fk_products_sales is the foreign key in the sales table for the product id in the product table

Products Table

Join table (relational table that keeps track of ingredients used in products )

product and ingredient fields are foreign keys for the respective ID's