This discussion is archived
2 Replies Latest reply: Jun 24, 2013 11:08 PM by 1011804 RSS

Execute multiple queries in a single Query Zone

1011804 Newbie
Currently Being Moderated

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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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.