Previous Topic

Next Topic

Book Contents

Book Index

AD_QueryHistory_All

This view contains information about actions that have created or updated queries, along with the current status of the queries.

AD_QueryHistory_All report view

Column

Description

SITE_ID

Database identifier of the site. (Can be NULL.)

ID

Database identifier of the query.

QUERY_ID

Identifier of the query as it appears in the user interface.

QUERY_CATEGORY

Type of query:

  • System
  • Manual

TIMESTAMPS

Date and time that the query was updated.

CHANGE_USER

User who updated the query.

AUTHOR

User who created the query. The author is System if the query was automatically issued.

EVENT_NAME

Name of the event associated with the query status change:

  • Created
  • Re-issued
  • Approved
  • Closed

QUERYSTATUS_ID

Database identifier of the current query status.

QUERYSTATUS

Query status:

  • Open
  • Answered
  • Approved
  • Closed
  • Candidate
  • Deleted

NOTES

Text of the query.

LAN_ID

Identifier of the language, enabling you to filter the view by language.

Copyright © 2011 - 2014 Oracle and/or its affiliates. All rights reserved.