Bolt
Schema
Forms
Business Rules
Database Info
SQL
Lists
Licenses
About
View Name:
user_view
View Number:
54
Group:
Resource Mgr
Description:
Selects a user's status; i.e., active/inactive
Flags:
VIEW_OPTIMIZED
Baseline/Custom:
Baseline
Fields
Joins
select * from table_user_view
Keyboard shortcuts available
Fields:
View Field Name
Table Name
Field Name
Comment
Generic Field Id
objid
user
objid
User internal record number
3 (UNIQUE)
name
user
login_name
User login name
status
user
status
User status; i.e., 0=inactive, 1=active, default=1
Joins:
Join From
Join To
My Recent Objects
user_view
Quick Links
act_entry
case
contact
employee
rol_contct
site
site_view
user
Keyboard shortcuts
×
alt-s
Execute SQL
alt-t
Execute SQL, getting latest 10 rows
?
Bring up this help dialog