Using Xpoda Assistant, you can run a conditional query between specified time periods.
Assistants must be installed in order for your assistants to work. You can access the assistant setup document from the link below.
For this, first of all, you need to log in to studio.xpoda.com with your user information. After logging in, the Assistant option should be selected from the fields on the left menu.
Assistant splash image
Record List: In this area, you can see your assistants that you have defined before. You can make changes for the assistants you have defined by making a selection.
Name: The assistant is given a name.
Type: The action to be taken by the assistant is selected. For the query execution process, Run Query is selected from the Type field.
Data Query: You must write the query you want to run in this field. You can write a conditional query like Insert, Update, Alter. Example usage is given in the examples below.
Working Condition Area
It is determined that your assistant you have defined will work at what time intervals and how many minutes depending on the condition you have written.
Start Date: The date that the assistant will start is selected.
End Date: The date on which the assistant will end his/her job is selected.
Minute: It is written how many minutes the assistant will take action. The assistant's working time is based on minutes.
Run Condition: This is the area where you can run the assistant depending on any condition. A query expression is written in this field. The query you have written here will be triggered every minute you specified above. As long as the return value result from the query is 1, the assistant works. Here you can connect the work of the assistant to different conditions by differentiating the query. You can also make it always work by giving it a fixed value. For example: “SELECT 1”
Error Information: If there is any problem in the work of the assistant, it is written to which e-mail address the problem will be forwarded. You can use this feature especially in error tracking.
The assistant is given a name called “Update mail address”. And Run Query is selected from the type field. The assistant is activated. As long as the assistant is not activated, it will only be defined and will not work.
The query to be executed is written in the Data query field.
For this example, we performed a mail update for the user whose UserID is 1 in the XPODA_CLIENT_USERS table.
Working Condition field:
The times when the assistant will start and stop working are selected. Then it is written how many minutes this operation will be done.
Since we want this assistant to run every minute, the Working Interval field is set to 1.
SELECT 1 statement is written in the Run Condition field because it is desired to run continuously without being connected to any condition.
The address firstname.lastname@example.org was written to send the notification e-mail in case of any problem in the work of the assistant.