2 Replies Latest reply: Jun 25, 2013 1:08 AM by 1011804 RSS

    Execute multiple queries in a single Query Zone

    1011804

      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?

        • 1. Re: Execute multiple queries in a single Query Zone
          Jagadeesh P

          Hi,

           

          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.

          Thanks,

          • 2. Re: Execute multiple queries in a single Query Zone
            1011804

            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.