Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Secondary query within Fetch returns one row
wwilliams
<p>I am trying to use a Maximo scripted dataset with another query inside as the example under the section Queries in the Fetch Method, page 58 V7.5 Report Development Guide.</p>
<p>The additional query results in numerous rows, but I only get one row when I run it in the main fetch.</p>
<p>I am attempting to populate an array of values to manipulate the main query's presentation which is based on a pivot table.</p>
<p> </p>
<p>Thx</p>
<p> </p>
<p>Well I took another approach that works by using a function and creating the dataset in the initialize method.</p>
Find more posts tagged with
Comments
Rani
<p>Hi,</p>
<p> </p>
<p>I am looking for the same functionality. Can you please explain me how can you get this done.</p>
<p> </p>
<p>Thanks in Advance.</p>
wwilliams
<p>Best I recall, I was able to accomplish it by nesting the tables.</p>