cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Report Manager (Query Builder) Question

DarinS
1-Newbie

Report Manager (Query Builder) Question

All,



I have my query about 95% complete but I'm having difficulty with the
final step.



My query joins the Change Request, Change Order, Change Activity and
Changeable.



It returns the ECR linked to its ECO, the creator of the ECR, the
Context, ECR cycle time, track, ECR to ECO cycle time and the affected
data in the Change Activity.



Currently its giving me individual lines for each affected item in the
Change Activity; see below:



ECR No.
<
4 REPLIES 4
DarinS
1-Newbie
(To:DarinS)

Thanks to Bjarne and Brian.



You must use the Count function with a GROUP BY. Once activating GROUP
BY I counted the ECR rows and got the output I needed!



Thanks again!

Darin


I have a site level report. It is visible from all products on the
report page. I would like to have the report pass in the current
context to the report query as a constraint. This would limit the query
to only relevant items from that context. Not unlike how the Change
Monitor works but I think in that case, the Context is passed from the
URL created on the JSP page.


cadjett
1-Newbie
(To:DarinS)

I could be way off on what you are asking Antonio & I am no QML guy (yet), but I found a fewold qml files that allows for context or domain entry fields:


<where>
<compositecondition type="and">
<condition>
<operand>
<column alias="Administrative" domain&quot;=" heading="Name" isexternal="false" propertyname="name" selectonly="false" type="java.lang.String">
name
</column>
</operand>
<operator type="equal"/">
<operand>
<parametertarget name="DJ_WC"/">
</operand>
</condition>
</compositecondition>
</where>

<where>
<compositecondition type="and">
<condition>
<operand>
<column alias="Context" heading="Context" name&quot;=" isexternal="false" propertyname="name" selectonly="false" type="java.lang.String">
containerInfo.name
</column>
</operand>
<operator type="like"/">
<operand>
<parametertarget name="Context" name&quot;="/>
</operand>
</condition>
</compositecondition>
</where>

<where>
<compositecondition type="and">
<condition>
<operand>
<column alias="Context" heading="Context" name=" (name)&quot;=" isexternal="false" propertyname="name" selectonly="false" type="java.lang.String">
containerInfo.name
</column>
</operand>
<operator type="like"/">
<operand>
<constant heading="GOLFCART" ismacro="false" type="java.lang.Object">
GOLF_CART
</constant>
</operand>
</condition>

</compositecondition>
</where>

Hope im on track.

I also added a file with the same inserted, which has better format than this message will show.

L Jett

Announcements