Workflow Plus Lines View Tool Features Automatically creates SQL - PowerPoint PPT Presentation

Workflow Plus Lines View Tool

Features � Automatically creates SQL Views from Requests using this functionality � An XML file is created when using Lines in a request. This tool makes it easier for reporting and data extraction

Generate Line Views for Requests

Sample Request with Lines

Transform this Data in XML File

To SQL View of Data

Using This Tool � To create Views in the SQL table to extract data that was used in workflow requests utilizing the lines function � All workflow requests that use the Lines Functionality � SSRS Reports can be created using data from both the Absences table and the SQL View

Issues Solved � Creates SQL Views from Workflow Requests using the Lines Functionality � No more creating a specific SQL view from the data for each type of request using this function

Skill Set to Use this Tool The following skills are useful with this Tool: � Knowledge of Synergy � Knowledge and can create Lines Functionality within requests � Basic knowledge of Synergy’s SQL table structure & fields

This Tool is Bundled with: � Workflow Plus Free Fields � Workflow Plus Attachment Fields � Workflow Plus Comment Fields � Workflow Plus Spell Check � Workflow Plus Auto Timestamp in Long Comment Fields � Workflow Plus HTML Formatting � Workflow Plus URL Hyperlinks � Workflow Plus Browser Import / Export

FAQ’s � Installation / training & on-going support covered by annual maintenance agreement � Maintenance plan is required for tool to be used � Enabling Add-On Role required on Synergy license for resources � Works with all Synergy Enterprise sites and ERP system data

Contact Us Contact us to schedule a demo or receive additional information on our tools Dave Kloepfer Sales Manager SynergyExpert.com dkloepfer@synergyexpert.com 847-956-6500 (Office) 847-867-4401 (Cell)