API Programming Guide › CA Enterprise Log Manager 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.