I have two data providers Query1 and Query 2. Both have a common object country. However there are fewer countries in Query2 than in Query1. In the report i need to display the fewer countries from Query2 and not all the countries.
Hence I was looking to create a subquery by editing the Query1 data provider so tht Query1 only rerieves those countries which are present in Query2.
Hence, I go to Edit Data Provider of Query1
Then in its conditions panel I pull
and say
InList <Query2.Country> …but this does not work.
Which means the operand taken was select query result and then from the popup window, selected query2.country.
If yes then it should give you the desired result
this query has had me wondering for a long time now…
if we have 2 Data Providers, Detail and List.
Detail - complete info about all the candidates
List - complex custom SQL(or not) to generate a list of candidate ID’s
to restrict data fetched in Detail we use a Candidate ID inList From Data provider List :: Candidate ID
BUT the limitation being that the inlist operator permits only 1024 values, hence when the Data provider List generates more than 1024 candidates we get a LOV error.
Do we have a workaround for this?? this is at a Query panel level and not Universe or Report level. how will we restrict the no of rows fetched??