Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Added on March 13, 2025 2:40PM
Likes: 1
Replies: 2
Hi guys, I have a flow with 2 different scenarios. I have one variable v_idproduct used in a post filter join recipe in a sql code (id_product IN v_id_product). In each scenario I have a different list of id products.
I want to modify one of the scenarios so that this filter is no longer applied, allowing all product IDs to be selected. However, I'm not sure how to achieve this, as I assume I still need to define the variable list in my scenario.
Thank you !
It depends on how you want to handle variables. Personally I prefer to define at scenario level with a Define variables scenario step and then use in the SQL expression in recipes. However you do get an error as the recipe doesn't see the variable until it runs under the scenario so I also define them with dummy values as project variables. You could use a set project variable scenario set but that's dangerous as two different scenarios could change the same variable and also the vsriable value is left in the project. That's why scenario variables are better as they are only available for that scenario only.
Thank you for your answer!
I'll try it and let you know if it worked