5.3. Creating Object 1102 Status (base)

 

5.3.1. Creating Object 1102 Status (base)

To create the object 1102 Statuses (base):

 

5.3.1.1. Open the context menu of the folder 1100 Status by right-clicking the mouse; 

 

 

5.3.1.2. Select New object > Table;

 

 

5.3.1.3. In the Properties window, enter 1102 in the Object Code field, enter the Status (base) in the Object Name field. 

 

 

 

5.3.2. Grid Design

To change the table:

 

5.3.2.1. Open object 1102 Status (base) for modification by double-clicking the left mouse button; 

 

 

Note: if you want to study grid design process in detail, follow the steps 5.3.2.2 - 5.3.2.12. If you already know how to do this, skip the steps 5.3.2.2 - 5.3.2.12 and go to the step 5.3.2.13.

 

5.3.2.2. In the field Data Source specify the object - vw_statuses;

 

 

5.3.2.3. In system fields Record ID, Date & Time (Created), Date & Time (Updated), Date & Time (Closed), User ID, select accordingly fields user_id, dttmcr, dttmup, dttmcl, userid;

 

 

5.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 (date and time of status creation), status_type_name (status name); 

 

 

5.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, Status, respectively; 

 

 

5.3.2.6. Move the mouse pointer over the border between the headings of the first and the second column;

5.3.2.7. Click the left mouse button and, without releasing it, change the width of the first column;

 

 

5.3.2.8. In the same way set the required width of the other column;

 

 

5.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;

 

 

5.3.2.10. Select the column dttmcr and set the Sort field to 2-Descending

 

 

5.3.2.11. In the field Allow Additions, select 1-Yes

 

 

5.3.2.12. In the Allow Editions, Allow Deletions, select 0-No

 

 

Note: If you followed the steps 5.3.2.2 - 5.3.2.12, skip steps 5.3.2.13 - 5.3.2.18 and go to step 5.3.2.19.

 

5.3.2.13. Download the file archive containing the settings of objects;

5.3.2.14. Extract the files from the downloaded archive;

5.3.2.15. Open the context menu by right-clicking in the data area;

 

 

5.3.2.16. Select Import settings from the file;

5.3.2.17. In the appeared window specify the path to the file 1102_Table;

 

 

5.3.2.18. Click the Open button;

 

All table settings will be imported.

 

 

5.3.2.19. Save changes by selecting Menu > Save or by clicking the appropriate button in the toolbar.

 

 

 

5.3.3. Form Design

To change the form:

 

5.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 5.3.3.2 - 5.3.3.32. If you already know how to do this, skip the steps 5.3.3.2 - 5.3.3.32 and go to the step 5.3.3.33.

 

5.3.3.2. In the field Data Source choose database object - t_statuses

 

 

5.3.3.3. In system fields Record ID, Date & Time (Created), Date & Time (Updated), Date & Time (Closed), User ID choose fields from the table - client_id, dttmcr, dttmup, dttmcl, userid;

 

 

5.3.3.4. Click the left mouse button on the Field button on the toolbar;

 

 

5.3.3.5. Move the mouse pointer to the data area;

5.3.3.6. Press the left mouse button and, without releasing it, outline the size of the field;

 

 

5.3.3.7. In the Control Source field, click the Advanced button; 

 

 

5.3.3.8. In the appeared window type in object_id!1001.object_ref_nr, since this field will refer to the object 1001 Tickets (base) and display the number of the selected ticket when adding the status;

 

 

5.3.3.9. Click the Save button;

5.3.3.10. in the Enabled field, specify the value 0-No;

 

 

5.3.3.11. In the field Back Color choose a background color;

 

 

5.3.3.12. Similarly, add one more field below;

 

 

5.3.3.13. In the Control Source field, click the Advanced button;

5.3.3.14. Enter status_type_id!1101.status_type_name

 

 

5.3.3.15. Click the Save button;

5.3.3.16. Left-click on the Label button on the toolbar;

 

 

5.3.3.17. Move the mouse pointer to the data area;

5.3.3.18. Press the left mouse button and, without releasing it, outline the size of label so that the label is left to the top field

 

 

5.3.3.19. In the Caption field enter Ticket №

 

 

5.3.3.20. Similarly, add one more label to the left of the second field; 

 

 

5.3.3.21. In the Caption field, enter Status

 

 

5.3.3.22. Select Edit > Select All

 

 

5.3.3.23. In the Height field specify the height of the elements - 0,6; press the Enter key; 

 

 

5.3.3.24. Select all the labels by clicking the left mouse button and, without releasing it, outlining the area on the screen with the mouse pointer;

 

 

5.3.3.25. In the Width field specify the width of the labels - 3; press the Enter key; 

 

 

5.3.3.26. Select all fields; 

 

 

5.3.3.27. In the Width field specify the width of the fields - 6; press the Enter key; 

 

 

5.3.3.28. Select Edit > Select All;

5.3.3.29. Select Arrange > Align > Top;

5.3.3.30. Select Arrange > Align > Left;

 

 

5.3.3.31. 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;

 

 

5.3.3.32. 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;

 

 

Note: If you followed the steps 5.3.3.2 - 5.3.3.32, skip steps 5.3.3.2 - 5.3.3.32 and go to step 5.3.3.39.

 

5.3.3.33. Download the file archive containing the settings of objects;

5.3.3.34. Extract the files from the downloaded archive;

5.3.3.35. Open the context menu by right-clicking in the data area;

 

 

5.3.3.36. Select the menu item Import settings from file;

5.3.3.37. In the appeared window, specify the path to the file 1102_Form

 

 

5.3.3.38. Click the Open button;

 

All settings of the form will be imported.

 

 

5.3.3.39. Select Menu > Save

 

 

5.3.3.40. Close the object by clicking on the corresponding button. 

 

 

 

5.3.4. Next

5.4. Creating Object 1202 Comment (base)