Services managment

Service details (main data)

1. Service name – name of the service

2. Service description

3. Service type. At the moment, only e-mail type is available

4. Interval – interval in which service will be executed, in minutes. E.g. 30 min

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

6. Start time. Time when service will start to execute. E.g. 8:00

7. End time. Time after which service will not be executed in a day. E.g. 16:00

8. Connection. Database connection for service. This connection will be used for additional conditions and parameters for service and service reports.

9. 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

1. Report. Selected report

2. Layout. Layout that will be sent

3. Export type. Document type that will be sent (PDF, Excel etc.)

4. Recalculate the report for each user. If selected, the report will be recalculated for each user

5. Parameter report name

6. Parameter value source type. Only SQL condition for now

7. 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.).