| View Name: | qry_bug_view |
| View Number: | 209 |
| Group: | Quality |
| Description: | Used by form CRs from Query (803) |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| elm_objid | bug | objid | Bug internal record number | 3 (UNIQUE) |
| id_number | bug | id_number | Change request number; generated via auto-numbering | 4 |
| owner | owner(user) | login_name | User login name | 12 |
| condition | condition | title | Condition of the bug | 7 |
| status | gse_status(gbst_elm) | title | Reserved; not used | 8 |
| product | part_num | description | Maps to sales and mfg systems | 21 |
| title | bug | title | Title of the change request | 2 |
| priority | gse_priority(gbst_elm) | title | Priority of the change request | 35 |
| type | gse_type(gbst_elm) | title | Type of the change request | 37 |
| creation_time | bug | creation_time | Creation date/time of the change request | |
| x_res1 | part_num | x_res1 | Data Restriction field | |
| x_res2 | part_num | x_res2 | Data Restriction field | |
| x_res3 | part_num | x_res3 | Data Restriction field | |
| x_res4 | part_num | x_res4 | Data Restriction field | |
| x_res5 | part_num | x_res5 | Data Restriction field |
| Join From | Join To |
|---|---|
| (bug).bug_condit2condition | (condition).bug_condition2bug |
| (bug).bug_owner2user | owner(user).owner2bug |
| (bug).bug_type2gbst_elm | gse_type(gbst_elm).bug_type2bug |
| (bug).bug_priority2gbst_elm | gse_priority(gbst_elm).priority2bug |
| (bug).bug_sts2gbst_elm | gse_status(gbst_elm).status2bug |
| (bug).bug_product2part_info | (mod_level).part_info2bug |
| (mod_level).part_info2part_num | (part_num).part_num2mod_level |
| qry_bug_view | |||