Avatar

Community Advisor

Hi,

For update: It updates data only when condition is met

For query: When you add 'Taken into Account If' you can see your query condition gets changed. It does not take into condition you have specified. It queries on full table. You can see this by ''Generated SQL Query'.

Thanks.