Bolt
Schema
Forms
Business Rules
Database Info
SQL
Lists
Licenses
About
View Name:
site2case_view
View Number:
5291
Group:
ClearSupport
Description:
Used in new find caller workflow of Case window
Flags:
VIEW_OPTIMIZED
Baseline/Custom:
Baseline
Fields
Joins
select * from table_site2case_view
Keyboard shortcuts available
Fields:
View Field Name
Table Name
Field Name
Comment
Generic Field Id
wip_objid
wipbin
objid
WIPbin internal record number
18
elm_objid
case
objid
Case internal record number
3 (UNIQUE)
site_objid
site
objid
Site internal record number
Joins:
Join From
Join To
(
case
).case_wip2wipbin
(
wipbin
).wipbin2case
(
case
).case_reporter2site
(
site
).cust_loc2case
My Recent Objects
site2case_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