ALERTS IN VIENNA ADVANTAGE
Contents
1. VERSION 1 0 Date 20 12 2014 Vv ALERTS IN VIENNA ADVANTAGE A USER S GUIDE VIENNA ADVANTAGE This is a publication of VIENNA Advantage GmbH Version 2015 Copyright 2015 VIENNA Advantage GmbH All rights reserved This document is provided as is Information and views expressed in this document including URL and other Internet Web site references may change without notice You bear the risk of using it Some examples depicted herein are provided for illustration only and are fictitious No real association or connection is intended or should be inferred This document does not provide you with any legal rights to any intellectual property in any VIENNA Advantage or other product You may copy and use this document for your internal reference purposes VIENNA Advantage the VIENNA Advantage logos and the VIENNA Advantage product and service names mentioned herein are registered trademarks or trademarks of VIENNA Advantage GmbH or its affiliated entities Microsoft Visual Studio Windows and Windows Server are Trademarks of the Microsoft group of companies Oracle is a registered trademark of Oracle Corporation and or its affiliates Other names may be trademarks of their respective owners All other trademarks are property of their respective owners VIENNA Advantage disclaims any warranty regarding the sample code contained in this documentation including the warranties of merchantability and fitness for a pa2. cshjml statementdifference AS TotalBalance cshjml beginningbalance cshjml statementdifference cshjml endingbalance AS DiffBalance Table Sql FROM VAPOS_POSTerminal pos INNER JOIN C_CashBook cshbk ON cshbk C_CashBook_ID pos C_CashBook_ID INNER JOIN c_cash cshiml ON cshjml C_CashBook_ID cshbk C_CashBook_ID Sql WHERE cshjml beginningbalance cshjm statementdifference lt gt cshjml endingbalance AND pos isactive Y ShowingResuk 1 1 of 1 Navigate or Update record Home Alert Notice User Enter Name Check Valid checkbox as True Wednesday January 7 Action 2015 SuperUser q Related Preference 9 Help Alert is execute and send the information to the relevant users when alert is valid and where clause condition is matched Pre Processing It indicates that Process SQL is executing which user write in pre processing before executing the Select Clause query User can write any kind of query like Update Delete etc in this field Enter Sql SELECT It indicates that the SQL SELECT Clause to use for selecting the record for a measure calculation But do not include the SELECT itself Enter Table It indicates all the Database table information If users want to execute the alert based on single table then user can select table from this TABLE field If users want to execute the alert based on multiple table then user need to write in SQL FROM clause
3. 50 that alerts can be execute and send the information to the relevant users Alerts IN VIENNA ADVANTAGE 4 3 PRE REQUISITES Tuesday December 23 2014 Superuser ij Internal Supervisor gt z EMail User ID l Home C Alert Processor O Alet User In VIENNA Advantage User makes the setting at User Window for NOTICE and E Mail 3 1 NOTIFICATION TYPE Select Notification Type If you select Notification Type as Notice then only Notice is send to the relevant users when the alert is executed If you select Notification Type as Notice Email then Notice and E Mail is send to the relevant user when the alert is executed But for E Mail you make a setting at User window 3 2 E MAIL Enter E Mail Address Check E Mail allowed is True Alerts IN VIENNA ADVANTAGE 4 CONFIGURING ALERTS 4 1 ALERT PROCESSOR Dli Tuesday January 6 2015 Superuser MN IV Alert Processor L L Xx Processor Log Tenant Organization nw Name Alert for Cash Difference Descnption A H Active A Schedule Upload And Email Attachment Document gt eam Supervisor Days to keep Log Brian White Date Last Run Date next run ray ShowingResull 1 1 of 1 Navigate or Update record A Home C Alen Processor C Notice O Aet C User Enter Name of Processor Enter Description Select Schedule In VIENNA Advantage Schedule is used
4. to define the frequency or interval time whenever you want to execute the process Please read the Schedule related document to understand the schedule concept in greater detail Select Supervisor In VIENNA Advantage Supervisor indicates who will be used for forwarding and escalating issue for this user Enter Days to keep log It indicates the number of days to keep the log entries Older log entries may be deleted Date Last Run It indicates the last time an action occurred for this request Alerts IN VIENNA ADVANTAGE te Date Next Run It indicates the next time when the action is occurred for this request 4 2 ALERT Es Saturday December 20 2014 Superuser 10 X Enforce Tenant Security Enforce Role Security Alert Subject ompiere Database Space Alert Message Check that the ShowingResull 1 10f1 Data Requeried Enter Name Select Alert Processor Alert Processor is used to define the different processes that you want to occur Check valid checkbox as True Alert is execute and send the information to the relevant users when alert is valid and where clause condition is matched Enter the appropriate Alert Subject Enter the Alert Message which you want to send to the relevant users Alerts IN VIENNA ADVANTAGE 4 3 ALERT RULE Sql SELECT pos VAPOS_Name AS TeminalName cshbk name AS CashbookName cshjml StatementDate cshim heginningbalance cshim endingkalance cshjml beginningbalance
5. Alerts IN VIENNA ADVANTAGE Enter Sql FROM The FROM Clause indicates the Sql FROM clause to use for selecting the record for a measure calculation It can contain JOIN Clause But do not include FROM itself Enter Sql WHERE The WHERE Clause indicates the WHERE Clause to use for record selection But do not consider WHERE Clause itself Note that WHERE Clause should be Fully Qualified It means that WHERE clause contain Pe tablename columnname Enter Other Sql Clause It indicate any other complete clause like GROUP By HAVING ORDER BY etc after WHERE clause Enter Post Processing It indicates that Process SQL is executing which user write in post processing after executing the Select Clause query User can write any kind of query like Update Delete etc in this field Alerts IN VIENNA ADVANTAGE 4 4 ALERT RECIPIENT Wednesday January 7 2015 SuperUser ny Action D Chat l l Related Tenant Organization Attachment Ideasinc lt Preference 1 Help Alert Alert for Cash Difference History records Check Requests Y Active 7 Workflow User Contact Copy Record SuperUser Role Y Subscribe Record Ideasinc Admin Zoom Across where use al Private Record Lock Shov ngResuk 1 1 of 1 Navigate or Update record A Home Notice User Alert Y Select User Contact It contains the entire USER within the system Select the users to whom you want to s
6. end the alert Select Role It contains the entire Role in the system The Role determines security and access a user who has this Role will have in the system If user wants to send alert to all users who belong to particular Role then select Role Alerts IN VIENNA ADVANTAGE 5 ALERTS FROM SYSTEM Friday January 9 2015 SuperUser q Notice Action Chat gt Related Tenant Organization Preference Attachment Ideasinc HQ 0 0 g Help gt History records Message Created On PostingError E 04 06 2009 05 30 AM f gt Check Requests User Contact Z Wordow Copy Record Workflow Activity Y Subscribe Record Table Zoom Across where us M_InOut_Shipment Receipt Private Record Lock Reference MinOut 100 600000 DocStatus C 0 Text Message Posting Error No Costs for Plum Tree Doc_InOut MMS DocumentNo 600000 DateAcct 2002 02 22 Amount 0 Sta E PeriodOpen true Balanced true ShovingResuk 1 50 of 100 Navigate or Update record Home C Alert Processor O Alet Notice User On the basis of user alert when the alert is executed excel is created and bind in attachment for all relevant user at Notice window and same excel is sent to the relevant user by E Mail Alerts IN VIENNA ADVANTAGE INDEX language 4 Alerts IN VIENNA ADVANTAGE role 2 5 7
7. er care located in the Contact section of http www viennaadvantage com Alerts IN VIENNA ADVANTAGE 2 ABOUT ALERTS 2 1 OVERVIEW OF ALERTS VIENNA Advantage Alert facilitates the flow of information within your organization to manage your business information and to notify your users of the information you required You can create alerts that are as simple or as complex as you need and you can create your alerts in a variety of ways so they perform the kind of execution according to your organization requirement An Alert checks the database for information according to a schedule you define and if where clause condition matched then system used to execute the alert to the relevant users You can also define the frequency or interval time whenever you want to execute this alert Saturday December 20 2014 Superuser Alert Alert Rule Alert Recipient Tenant Organization System FA z Name Space in Database Description Oracle specific Comment Y B to Active Alert Processor System Alert Processor Alert Subject Compiere Database Space Alert Message Check that the Compiere Database has sufficient space ShomingResuk 1 1 of 1 Data Requeried 2 2 TYPE OF ALERTS In VIENNA Advantage there are two types of alerts in the systems which are NOTICE and E Mail Alert To configure the alert in the system you need to write a query at Alert window and make the setting at user window
8. rticular purpose Use of this product is covered by a license agreement provided with the software product If you have any questions please email the VIENNA Advantage Customer Care listed at http www viennaadvantage com URL and other Internet Web site references may change without notice You bear the risk of using it Alerts IN VIENNA ADVANTAGE TABLE OF CONTENTS L Traces Tras OI EEE 3 1 1 UU AE LORS A als Manual o oO o ite auetoceusaa teas veaenneouss E 3 1 2 PRIS GS Sage EEE 3 1 3 q 3 1 4 do a A 3 DOME Macro 4 2 1 A a e 4 2 2 Be OAI e o A 4 3 Pre RECUISIRSS creci 5 3 1 NO e a a a E 5 3 2 EM Alpina anda 5 o e o a ee a de a ee 6 4 1 Ld see T a ea e O o ero PI enorme 6 4 2 PCM a a eee ue to tin te ni A E ee 7 4 3 PGT M tancias 8 4 4 A So ee ee eee er 10 o Alerts PONY SSI a a da on ed dede ee do dm 11 A O E A 12 Alerts IN VIENNA ADVANTAGE 1 INTRODUCTION 1 1 WHAT S IN THIS MANUAL This Document intends to inform the user about the Alerts in VIENNA Advantage 1 2 AUDIENCE Audience and Market End Users 1 3 SYMBOLS AND CONVENTIONS O Awe Ca ee Tenant Client Tenant is a terminology used to define a subset of data related to one or more organizations in a system It is not a business entity but the name of a group which could relate to one or multiple business entities 1 4 PRODUCT SUPPORT In case of any questions related to this user manual you can contact VIENNA Advantage custom
Download Pdf Manuals
Related Search