Bolt
Schema
Forms
Business Rules
Database Info
SQL
Lists
Licenses
About
View Name:
case2wip_dfe
View Number:
122
Group:
Support
Description:
Used to join case and dispatch engineer objects
Flags:
VIEW_OPTIMIZED
Baseline/Custom:
Baseline
Fields
Joins
select * from table_case2wip_dfe
Keyboard shortcuts available
Fields:
View Field Name
Table Name
Field Name
Comment
Generic Field Id
case_id
case
objid
Case internal record number
19
sub_id
disptchfe
objid
Disptchfe internal record number
3 (UNIQUE)
wip_id
wipbin
objid
WIPbin internal record number
18
Joins:
Join From
Join To
(
disptchfe
).disptchfe2case
(
case
).case_onsite2disptchfe
My Recent Objects
case2wip_dfe
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