Edited: 2017-01-01

Introduction

Phoebus SQL query provide a function to store a query script and up to 5 input tables for the query.

The result of query running is a datatable

Usage

For example, on the international day of children, HR department needs to form a list of employees, who have at least one children under 16. Company will pay a gift cost 20$ for each children under 16.

The setting below allows to define such list.

Firstly, Phoebus extract a list of dependants in June of the current year to a table named EDP using the url in table Url1. This is a common phoebus url which can accept parameters.

Then Phoebus query table EDP with the script, defined in Phoebus SQL Script. The script filter all dependant under 16  and return a table with 2 columns: Employee Code, Number of Children

Module:

Data

User table

pbs.BO.Data.PSQLRun?$QueryCode=PSQL_Code&para1=value1&para2=<<vfrom..vto ....