• View Page Source

• Recent Changes
  Page Index
  About
  SystemInfo
  

  IT_slab_2010
  UndefinedPages
  

Query Builder to get Day-wise leave details#

A new field has been introduced to fetch the Day-Wise Leave report of the employees. This report will give details of all the days on which the employee has taken leave for the given year/period.

The report is generated using Query builder and can be saved for subsequent usage.

To create Query Builder

1. From the home page go to Reports > Query Builder.
2. Click on New Query.
3. Select the Basic Information category from the drop down menu. Choose Employee name and Employee number field and move it to Output fields.
4. Now go to Leave Info category and choose the required field for display.
5. Next, select Leaven taken (Daywise) category and select all the fields for display.
6. You will now have to select the order in which the fields will have to appear on the report. Use the Up and Down arrow here for navigation.
7. Now select the Conditions to filter the information and click on Next.
8. The Results of the query will be displayed. You can choose to modify the query by clicking on Back or save to store the report.