API Programming Guide › CA User Activity Reporting Module API Examples › Query and Report Viewer Calls › Query Specifications › Result Condition Specifications

Result Condition Specifications

Use param terms to set result conditions for a getQueryViewer, getReportViewer, or runQuery call.

The following param terms are available:

ARG_limit

Sets the number of rows returned by the query

ARG_show_other

Sets whether the show other column appears in a query viewer display, using true or false. This option is used for charts having Top N Queries (Aggregated Queries with Row Limit Set and aggregated based on event_count). If this option is selected, the first N -1 (N being the Row Limit) events are displayed normally. However, the Nth event is the "Other Event" which is an aggregated event based on the rest of the events.

ARG_event_datetime

Sets the granularity level of the time period used in the query display for trend queries. The available values are:

• event_datetime
• event_day_datetime
• event_minute_datetime
• event_hour_datetime
• event_month_datetime
• event_year_datetime

ARG_start

Sets the dynamic start time for the query.

ARG_stop

Sets the dynamic end time for the query.

ARG_minduring

Defines the earliest grouped event dated after a specified dynamic time. Relevant only for grouped queries.

ARG_maxduring

Defines the latest grouped event dated after a specified dynamic time. Relevant only for grouped queries.

ARG_maxbefore

Defines the latest grouped event dated before a specified dynamic time. Relevant only for grouped queries.

ARG_sumatleast

Defines the minimum number of events for grouping. Relevant only for grouped queries.

ARG_sumatmost

Defines the max number of events in the grouping. Relevant only for grouped queries.

Result Condition Specification Example

This example is shown with the params terms expanded for clarity.

https://ELMSERVER:5250/spin/calmapi/getObject.csp?type=getQueryViewer&objectId=Subscription/panels/System_Event_Count_By_Event_Action
<Params>
  <Param id="ARG_limit" val="'200'"/>
</Params>

The "ARG_limit" value '200' sets the query to display only the first 200 rows.

More information:

runQuery

Dynamic Time Terms