Content Platform Engine, Version 5.2.1            

logquery

The logquery command displays event log records in the current isolated region. Through the selective query option, you can use an index name to control the query and return the records in ascending index order for the range of the index specified.

You can optionally specify verbose output to output all fields of the selected records. When you don't select verbose output, logquery prints out all data fields and a subset of the system fields for each record selected.

You cannot view an event log record if you do not have access to the roster corresponding to the referenced work item. See About security workflow for further information.

Syntax

The syntax varies depending on whether you use a selective query.

Table 1. Table of syntax for query
To query event log table Syntax

without
selective query

logquery <logtablename> n <verbose>

with
selective query

logquery <logtablename> {y <indexname> <minfieldval> <getvaluesequalmin> <maxfieldval> <getvaluesequalmax> <filter>} <verbose>

Parameters

The parameters required depend on whether you use a selective query. The following table lists the parameters for the logquery command.

Table 2. Table of parameters and description for the logquery command
Parameter Description
filter This is a standard SQL WHERE clause using fields of the event log table.

For details on the syntax for your query, see the documentation for the SQL database server to which you're sending the query.

getvaluesequalmax Whether output should include records with values equal to maxfieldval. Enter "y" to include these records or "n" to exclude them.
getvaluesequalmin Whether output should include records with values equal to minfieldval. Enter "y" to include these records or "n" to exclude them.
indexname Index key name.

In prompt mode, enter "?" to view a list of the available indices.

logtablename Name of event log table. Use the config command to find the event log table name. The default value is DefaultEventLog.
maxfieldval The maximum value of the database field indicated by fieldname. The data type displays in datatype to help you determine the proper input. Depending on your answer, you might receive additional prompts for other minimum or maximum field values.
minfieldval The minimum value of the database field indicated by fieldname. The data type displays in datatype to help you determine the proper input. Depending on your answer, you might receive additional prompts for other minimum or maximum field values.
n No selective query specified.
verbose Output the selected records in verbose mode.

Enter "y" to display all fields or "n" to display all data fields and a subset of the system fields.

y Selective query specified.

When using a selective query, you must specify an index key name to control the query. The records display in ascending index order for the range of the index specified.



Last updated: October 2015
bpfvl022.htm

© Copyright IBM Corporation 2015.