7.3. Creating Object 1203 Latest Comments
7.3.1. Creating Object 1203 Latest Comments
With a large number of tickets, it becomes urgent to receive information about the latest received letters on tickets. For this an object 1203 Latest Comments is needed.
To create an object 1203 Latest Comments:
7.3.1.1. Call the context menu of the folder 1200 Comments by right-clicking the mouse;
7.3.1.2. Select New Object > Table;
7.3.1.3. In the Properties window, enter 1203 in the Object Code field, enter the Latest Comments in the Object Name field.
7.3.2. Grid Design
To change the table:
7.3.2.1. open object 1203 Latest Comments for modification by double-clicking the left mouse button;
Note: if you want to study grid design process in detail, follow the steps 7.3.2.2 - 7.3.2.11. If you already know how to do this, skip the steps 7.3.2.2 - 7.3.2.11 and go to the step 7.3.2.12.
7.3.2.2. In the field Data Source specify the object - vw_latest_comments;
7.3.2.3. In system fields Record ID, Date & Time (Created), Date & Time (Updated), Date & Time (Closed), User ID, select accordingly fields comment_id, dttmcr, dttmup, dttmcl, userid;
7.3.2.4. Open the context menu by right-clicking in the empty space of the object, choose Add a column and select columns dttmcr (comment creation date and time), object_ref_nr, status_type_name (current ticket status), comment_type_name (comment type), comment_file_present (attachment), comment_from (from), comment_text (body);
7.3.2.5. Select each column by clicking the left mouse button on any line of the table, specify in the field Caption the displayed name of the column - Date and Time, Ticket №, Status, Comment Type, File, From, Body, respectively;
7.3.2.6. Move the mouse pointer over the border between the headings of the first and the second column;
7.3.2.7. Click the left mouse button and, without releasing it, change the width of the first column;
7.3.2.8. In the same way set the required width of the other column;
7.3.2.9. Select the last column and in the field Auto Size specify the value 1-Yes - column size will vary depending on the free space of the screen;
7.3.2.10. Select the column dttmcr and set the Sort field to 2-descending;
7.3.2.11. In the fields Allow Additions, Allow Editions, Allow Deletions select 0-No;
Note: If you followed the steps 7.3.2.2 - 7.3.2.11, skip steps 7.3.2.12 - 7.3.2.17 and go to step 7.3.2.18.
7.3.2.12. Download the file archive containing the settings of objects;
7.3.2.13. Extract the files from the downloaded archive;
7.3.2.14. Open the context menu by right-clicking in the data area;
7.3.2.15. Select Import settings from the file;
7.3.2.16. In the appeared window specify the path to the file 1203_Table;
7.3.2.17. Click the Open button;
All table settings will be imported.
7.3.2.18. Save changes by selecting Menu > Save or by clicking the appropriate button in the toolbar.
7.3.3. Form Design
To change the form:
7.3.3.1. Go to Form Design by selecting View > Form Design, or by pressing the appropriate button in the toolbar;
Note: if you want to study form design process in detail, follow the steps 7.3.3.2 - 7.3.3.35. If you already know how to do this, skip the steps 7.3.3.2 - 7.3.3.35 and go to the step 7.3.3.36.
7.3.3.2. In the field Data Source choose database object - t_comments;
7.3.3.3. In system fields Record ID, Date & Time (Created), Date & Time (Updated), Date & Time (Closed), User ID choose fields from the table - comment_id, dttmcr, dttmup, dttmcl, userid;
7.3.3.4. Click the left mouse button on the Field button on the toolbar;
7.3.3.5. Move the mouse pointer to the data area;
7.3.3.6. Press the left mouse button and, without releasing it, outline the size of the field;
7.3.3.7. In the Control Source field, click the Advanced button;
7.3.3.8. Enter the value object_id!1001.object_ref_nr;
7.3.3.9. Click the Save button;
7.3.3.10. In the Enabled field, specify the value 0-No;
7.3.3.11. In the Back Color field, select the background color;
7.3.3.12. Similarly, add one more field below;
7.3.3.13. In the Control Source field, click the Advanced button;
7.3.3.14. Enter the value comment_type_id!1201.comment_type_name;
7.3.3.15. Click the Save button;
7.3.3.16. Similarly, add six more fields (each subsequent lower than the previous one);
7.3.3.17. In the Control Source field for each added, choose accordingly comment_from, comment_to, comment_cc, comment_bcc, comment_subject, comment_text;
7.3.3.18. Left-click on the Label button on the toolbar;
7.3.3.19. Move the mouse pointer to the data area;
7.3.3.20. Press the left mouse button and, without releasing it, outline the size of label so that the label is left to the top field;
7.3.3.21. In the Caption field enter the Ticket №;
7.3.3.22. Similarly, add seven more labels (one for each field);
7.3.3.23. In the Caption field of each of the labels enter Comment Type, From, To, To, Copy, Bcc, Subject, Body, respectively;
7.3.3.24. Select Edit > Select All;
7.3.3.25. In the Height field specify the height of the elements - 0,6; press the Enter key;
7.3.3.26. Select all the labels by clicking the left mouse button and, without releasing it, outlining the area on the screen with the mouse pointer;
7.3.3.27. In the Width field specify the width of the labels - 3; press the Enter key;
7.3.3.28. Select all fields;
7.3.3.29. In the Width field specify the width of the fields - 6; press the Enter key;
7.3.3.30. Select Edit > Select All;
7.3.3.31. Select Arrange > Align > Top;
7.3.3.32. Select Arrange > Align > Left;
7.3.3.33. Move the mouse pointer over the elements, press the left mouse button and, without releasing it, move all the elements in the upper left corner;
7.3.3.34. Move the mouse pointer to the lower right corner of the data area, press the left mouse button and, without releasing it, reduce the size of the data area to a minimum;
7.3.3.35. Select the field comment_text - this field will occupy the remaining free space when working in the form and store multi-line text, so you should allow the text to scroll vertically by setting the Scroll Bars field to 2-Vertical;
Note: If you followed the steps 7.3.3.2 - 7.3.3.35, skip steps 7.3.3.36 - 7.3.3.41 and go to step 7.3.3.42.
7.3.3.36. Download the file archive containing the settings of objects;
7.3.3.37. Extract the files from the downloaded archive;
7.3.3.38. Open the context menu by right-clicking in the data area;
7.3.3.39. Select the menu item Import settings from file;
7.3.3.40. In the appeared window, specify the path to the file 1203_Form;
7.3.3.41. Click the Open button;
All settings of the form will be imported.
7.3.3.43. Close the object by clicking on the corresponding button.
7.3.4. Next