11 Replies Latest reply on Oct 17, 2018 4:46 PM by Deepak Rai

    Datasource: multiple datasets for different queries


      Hi Team,

      I need a guidance in building the datasource.

      Ex: I have a  sales table and promotion table.

      Query 1. The user requirements to get some data from only Sales table.

      Query 2. The user also need some data from combine sales and promotion table.

      the join should be inner for query 2.

      How do you build the datasource?

      How do you approach query 1 where all data needed from sales table only. If I build the datasource using join to promotion table then I loose the data in query1.

      Please guide. Thanks.