I am trying to create a new zone (zone type - F1-DE-QUERY) with the intention of executing 2 queries when the user hits the refresh button. Is this possible?
I've populated both SQL Statement 1 and 2 in the Zone parameters however, it would seem that only SQL 1 gets executed. Am I missing something?
Query zones fetch rows from the first SQL that satisifies the SQL condition.
i.e, If more than one SQL condition is satisfied, it would fetch the result of lowest numbered SQL among them.
You can combine both querys using 'UNION' clause and try.
or you can use an info zone with visible filters where results of all satisified SQL conditions are fetched and combined.
Thank you for the clarification. We decided to go with another route which is to make use of 2 different zones to handle the query execution.
Do you have any idea on how to pass values between zones though? Examples of such values are Characteristic Types and Characteristic Values. We would rather not have the users input the same values in two different zone.