6.3. Traitement SQL

 

6.3.1. SQL-processing 

Because tables 1102 and 1202 depend on table 1001, data input in objects 1102 and 1202 should be disabled if the entry in table 1001 is not selected.

 

To do this:

 

6.3.1.1. Select any row in the table 1102 Status (base)

 

 

6.3.1.2. In the Allow Additions field, click the Advanced button (Note: when you click on the "+" sign to the left of the Allow Additions field, the value specified in the base object is displayed);

 

 

6.3.1.3. In the appeared window, enter the value "= CASE WHEN [1001].[object_id] IS NULL THEN false ELSE true END;" without quotes. The equal sign means for the program the need to calculate the value to the right of the sign and assign this value to the field Allow Additions, the value in square brackets to the point is the object code, the value in square brackets after the point is the value of the object_id field for the ticket selected in the object 1001 Tickets (base)

 

 

6.3.1.4. Click the Save button; 

 

 

6.3.1.5. Select any row in the table 1202 Comment (base)

 

 

6.3.1.6. In the Allow Additions field, click the Advanced button; 

 

 

6.3.1.7. In the appeared window, enter the value "= CASE WHEN [1001].[object_id] IS NULL THEN false ELSE true END;" without quotes; 

 

 

6.3.1.8. Click the Save button. 

 

 

6.3.2. Next

6.4. Refreshing Objects