Service details (main data)
Service name – name of the service
Service description
Service type. At the moment, only e-mail type is available
Interval – interval in which service will be executed, in minutes. E.g. 30 min
Execution per day. How many times will the service be executed in a day. E.g. 1 if we only want service to be executed once a day, like in the morning or after working hours
Start time. Time when service will start to execute. E.g. 8:00
End time. Time after which service will not be executed in a day. E.g. 16:00
Connection. Database connection for service. This connection will be used for additional conditions and parameters for service and service reports.
Is active. Service is action or not. Only active services will be executed.
10. Save service.
11. Execute service for test. The service will be executed as long as all conditions about execution time are correct (time, number of executions etc.)
12. Running days. Day in week when service will be executed. E.g. Some reports we will need only on working days
Service sending details (service message, conditions, reports etc.)
Text for the message that will be send in service email
Report. Selected report
Layout. Layout that will be sent
Export type. Document type that will be sent (PDF, Excel etc.)
Recalculate the report for each user. If selected, the report will be recalculated for each user
Parameter report name
Parameter value source type. Only SQL condition for now
SQL query which will be used for parameter. In this case, yesterday’s date will be used as a parameter value
More than one report can be selected for service. Service can also be created without reports. Only message will be sent in e-mail.
Here we can define condition that will be checked before the service sends a message and report. If the result of the query is 1, the service will send message/report. In this example, you can see that the service will perform sending if there is stock that is lower than minimal stock. Enter only “SELECT 1” if you want to always send report (e.g., sales report for a day, working hours, etc.).
0 Comments