Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Modify queryText with subset of data from outer query
Migrateduser
<p>I have a query having a result set of a Lot # and a Component Lot #. 1 or more Component Lot #'s can be associated with a Lot #. The following table depicts a sample data set.</p><p> </p><p>Lot # Component Lot #</p><p>ABC123 XYZ987</p><p>ABC123 EFG454</p><p>ABC123 PBJ999</p><p>DEF456 PDQ001</p><p>DEF456 DNF225</p><p> </p><p>For each Component Lot # I need to find quality values in seperate databases - I do not know which database I will find the lot # in so I have to include all Component Lot #'s in the query.</p><p> </p><p>To complicate this I need to provide one row for each Lot # showing the Lot #, and a reading for 3 different quality values. To get a single row for each Lot #, I'm using a Group to group on Lot #. My attempt here is to build a commad deimited string of Component Lot #'s which will be used 3 inner queries for the 3 quality value columns. I was hoping to use the comma delimited string of Compoent Lot #'s and use it the beforeOpen event of the inner query, but that isn't working as I expected.</p><p> </p><p>My question is this, with an inner query being on the Group row of the outer query, is it possible to build a string of the Component Lot #'s for this Group to be used by the inner query. Once the inner query has executed for the 2 or 3 Component Lot #'s, I want to clear the string being built for the next Group processed by the outer query. The string is being built and cleared using a PersistentGlobalVariable.</p><p> </p><p>Thank you,</p><p> </p><p>Daron</p>
Find more posts tagged with
Comments
There are no comments yet