Hi all,

I need some help to remember how to customize reports.

I spent a few weeks customizing a report last year, but didn't document
anything and now I have forgot everything!!

I still have iReport and the SDK installed.

What I want to do is customize a report I made last year so that the
user can input a parameter that will be used in the query to only select
certain information.

We are using Sentinel Log Manager 1.2

I have gone through
http://www.novell.com/developer/deve..._sentinel.html and I do not
see any information about how to do what I want to do... But I remember
that there was a resource that I used to get where I am currently.

Do I just edit the "package.xml" file and set that field for prompting?
But how would that value then be used in the query?

Code:
--------------------
<PluginParameterDefinition>
<Description>Select the event field to display.</Description>
<Type>EventTag</Type>
<DefaultValue>cv38</DefaultValue>
<InternalName>EventField3</InternalName>
<DisplayName>Workflow Status</DisplayName>
<IsForPrompting>0</IsForPrompting>
</PluginParameterDefinition>
<PluginParameterDefinition>
--------------------


This is my report query:


Code:
--------------------
SELECT
dt AS event_parse_time,
cv40 AS workflowid,
cv28 AS requestee_bu,
cv29 AS requestee_comp,
cv30 AS requestee_cc,
$P{PrimaryEventField_validated} AS primary_event_field,
$P{EventField1_validated} AS event_field1,
$P{EventField2_validated} AS event_field2,
$P{EventField3_validated} AS event_field3,
$P{EventField4_validated} AS event_field4,
$P{EventField5_validated} AS event_field5,
$P{EventField6_validated} AS event_field6,
$P{EventField7_validated} AS event_field7,
$P{EventField8_validated} AS event_field8,
$P{EventField9_validated} AS event_field9,
$P{EventField10_validated} AS event_field10,
$P{EventField11_validated} AS event_field11,
xdasoutcome AS xdasoutcome
WHERE
sev:[$P{MinSevStr} TO $P{MaxSevStr}] $P{VendorProduct_Query} $P{SEARCH_QUERY_USE}
OVER $P{FromDtQry}, $P{ToDtQry}
$P{MaximumResultsStr}
--------------------


Where the "$P{SEARCH_QUERY_USE}" is defined in the "package.xml" as:


Code:
--------------------
<PluginParameterDefinition>
<Type>String</Type>
<DefaultValue>((workflow) AND (evt:&quot;User Message \: log_workflow_complete&quot) NOT st:&quot;I&quot; NOT st:&quot;A&quot; NOT st:&quot;P&quot;</DefaultValue>
<InternalName>SEARCH_QUERY</InternalName>
<DisplayName>SEARCH_QUERY</DisplayName>
</PluginParameterDefinition>
--------------------


Thanks in advance for the help!!!


--
ccikara
------------------------------------------------------------------------
ccikara's Profile: https://forums.netiq.com/member.php?userid=506
View this thread: https://forums.netiq.com/showthread.php?t=49684