| View Name: | queelm_case |
| View Number: | 59 |
| Group: | Support |
| Description: | View case information for Queue form (728) |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| que_objid | queue | objid | Queue internal record number | 18 |
| elm_objid | case | objid | Case internal record number | 3 (UNIQUE) |
| clarify_state | condition | condition | Case condition | 8 |
| id_number | case | id_number | Unique case number assigned based on auto-numbering definition | 4 |
| age | condition | queue_time | Age of case in seconds | 6 |
| condition | condition | title | Condition of case | 7 |
| status | gse_status(gbst_elm) | title | Status of case | 17 |
| title | case | title | Title of case | 2 |
| priority | gse_priority(gbst_elm) | title | Priority of case | 35 |
| severity | gse_severity(gbst_elm) | title | Severity of case | 36 |
| type | gse_type(gbst_elm) | title | Type of case | 37 |
| owner | user | objid | Case owner's Internal record number | |
| workaround | workaround | objid | Case workaround's internal record number | |
| condition_code | condition | condition | Code number for case condition | |
| x_res1 | site | x_res1 | Data Restriction field | |
| x_res2 | site | x_res2 | Data Restriction field | |
| x_res3 | site | x_res3 | Data Restriction field | |
| x_res4 | site | x_res4 | Data Restriction field | |
| x_res5 | site | x_res5 | Data Restriction field |
| Join From | Join To |
|---|---|
| (case).case_currq2queue | (queue).currq2case |
| (case).case_state2condition | (condition).case_condition2case |
| (case).calltype2gbst_elm | gse_type(gbst_elm).call_type2case |
| (case).respprty2gbst_elm | gse_priority(gbst_elm).resp_priority2case |
| (case).respsvrty2gbst_elm | gse_severity(gbst_elm).resp_severity2case |
| (case).casests2gbst_elm | gse_status(gbst_elm).case_status2case |
| (case).case_owner2user | (user).curr_owner2case |
| (case).case_soln2workaround | OUTER (workaround).solution2case |
| (case).case_reporter2site | (site).cust_loc2case |
| queelm_case | |||