14
Using Breeze Reporting Views
EXT_USERS
This view lists users and associated profile attributes. The EXT_USERS view uses data listed
in the following table:
Data is generated in this view whenever a user creates, updates or deletes a user.
EXT_USERS sample entries
Constraints
The EXT_USERS view excludes the following fields:
■
Password, which is not stored in plain text
■
Time zone and language, which are not available in human readable form. For example,
PST is 323.
■
Last login, which is too resource-intensive to calculate. Instead, you can retrieve this data
using a max(date_visited) query from the EXT_TRANSACTIONS view.
■
Active session, which is data from the EXT_TRANSACTION view. Instead, you can
retrieve this data by executing a STATUS='IN-PROGRESS' query.
Column name
Data type
Description
LOGIN
NVARCHAR
Unique user identifier.
NAME
NVARCHAR
Unique user name.
NVARCHAR
User’s unique email address.
MANAGER
NVARCHAR
The login of the user’s manager. Manager is always
set to NULL in version 5.1.
TYPE
NVARCHAR
User or guest. Type is always set to user in version 5.1.
LOGIN
NAME
MANAGER
TYPE
system admin
(null)
user
IT manager
(null)
user
NO
T
E
Deleted users do not appear in the EXT_USERS view. Deleted users continue to exist in
the EXT_TRANSACTION view.
Содержание BREEZE-MANAGING EXTERNAL BREEZE REPORTS
Страница 1: ...Managing External Breeze Reports ...
Страница 4: ...4 Contents ...
Страница 8: ...8 Understanding Breeze Reports ...
Страница 18: ...18 Using Breeze Reporting Views ...
