Skip navigation FileNet logo
Glossary  |  Help Directory  
  Help for vwtool
  Search
Process Reference  
vwtool
Getting Started
Commands
  !<shell_cmd>
  =
  assertbehavior
  attachtran
  config
  convert
  count
  createDBviews
  dbconfig
  deletewob
  dispatchwob
  dump
  echo
  emptyqueue
  environment
  hardcopy
  help
  listdbconfig
  listobjects
  listobjects
  loadstatus
  lockwob
  logconfig
  logquery
  memory
  pagebreak
  queueconfig
  readcdl
  recover
  region
  regions
  resetloadstatus
  rosterconfig
  schemastatus
  statistics
  stepprocessors
  storedquery
  terminatewob
  trace
  unlockwob
  version
  views
  wobquery
  workstation
  writetrace

 

   

logquery

This command displays event log records. Via 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 workflow security for further information.

Syntax

The syntax varies depending on whether you use a selective 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. Following is an alphabetical listing of all valid parameters for the logquery command.

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 may 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 may 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.

   

TIP In vwtool, you can enter parameters on the command line (following the command name) or let vwtool prompt you for the information by entering just the command name. Generally, we recommend prompt mode for all but the simplest commands. Entering the parameters on the command line is intended primarily for script-driven input.

NOTE If necessary, change to the desired isolated region prior to executing this command.