Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Background

Retrieve information from your database from the Out Of Office Rules Table

SQL Queries

  1. Total number of Out of Office Rules created 

    mysql> select * from AO_86B55C_OUT_OF_OFFICE_RULES 
    +----------+ 
    | COUNT(*) | 
    +----------+ 
    | 35       | 
    +----------+
  2. Number of users creating Out of Office Rules

    mysql> SELECT COUNT(distinct assignee) from AO_86B55C_OUT_OF_OFFICE_RULES;
    +--------------------------+
    | COUNT(distinct assignee) |
    +--------------------------+
    |                        8 |
    +--------------------------+
  • No labels