Update and Clean ADT Based on Time

You can use the pre-defined ADTs to define the intent diagnosis, but with the intent execution, the ADT data will become large or redundant. You can use a built-in function "GetTimeString" to update or delete the ADT data.

Complete the following steps to update ADT with "GetTimeString".

1. Add a column for ADT. Enter a display name “timecolumn” and set the data type as Time.
   
2. Add this ADT to intent as a reference table.
   
   
   1. Click All Intent Variables in the diagnosis.
   2. On the Use Automation Data Table tab, click +Automation Data Tables to add the ADT defined in step1. 
3. Swith to the Intent Variable tab and click Add Compound Variable to define a variable “ten_hours_before” with the function “GetTimeString” to prepared for being called later.
   
   

   The format of this function is “GetTimeString (offset, timeunit)”, which can be used to get a certain time before/after the current time and return the time with string. If offset is equal to 0, it means the current time, and a negative number (such as -10) means before the current time. Timeunit can be 0/1/2, representing min/hour/day respectively.

   For example, if you set the variable as “GetTimeString(-10,1)”, it means 10 hours before the current time.

4. Add an Operate on Table logic to clean this ADT.
   
   
5. Define the following settings to delete the ADT data.
   
   
   1. Select the defined ADT and then select Delete Table Row as operation.
   2. Set the matching condition as “timecolumn Larger than ten_hours_before”.
      The column “timecolumn” is the one defined in step1, and the variable “ten_hours_before” is the one defined in step3.
   3. Click OK.