Secondary query within Fetch returns one row

Options
wwilliams
edited February 11, 2022 in Analytics #1
<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>

Comments

  • <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>
  • <p>Best I recall, I was able to accomplish it by nesting the tables.</p>