Tango provides standard lease administration reports in Excel, Word or Acrobat format.  Each report is accessible by navigating to the Functional Dashboard and clicking on the General Reports module located in the Reporting tile.

Query Builder

In addition to the standard and custom report combinations built into the system and in accordance with the Scope of Work (SOW), Tango provides access for additional configurable and custom reporting capabilities to easily create custom ad hoc reports by using the Query Builder. The Query Builder is a User Interface (UI) component which allows the user to construct a basic SQL query in a programmable way.

You can access it by navigating to the Functional Dashboard and clicking on the Query Builder module located in the Reporting tile. 

Upon entering the Query Builder, by default, no tables or columns are included in the output table.

1. To create a new query, click the arrow in the Table Name field and select the appropriate table needed to create the desired query (i.e. TMCS_CLIENT’S_NAME_L_INTG_QB – table used to query data from the Lease Details > Basic Info & Additional Info tabs). Once selected, a list of all columns included in the table will display immediately below in the Column Name field. *Note:  only one single table can be selected and queried at a time. Therefore, if required, the user can run multiple queries and join them through excel using the VLOOKUP function as an example.

1. To add a column or columns to the output table, click on the column in the Column Name tab located on the left side of the screen immediately below the Table Name field. 
1. Click on the single arrow pointing to the right ( > ) to add the single column to the select data tab located to the right of the Column Name tab (repeat this step for each individual column required); or
2. Click on the double arrows pointing to the right ( >> ) to add all columns

To remove a column or columns from the output table, click on the column in the select data tab located to the right of the Column Name tab. 

1. Click on the single arrow pointing to the left ( < ) to remove the single column from the select table tab and back to the Column Name tab (repeat this step for each individual column required); or
2. Click on the double arrows pointing to the left ( << ) to remove all columns

The order in which columns appear in the select data tab is the order of columns in the output table. To change the order of a column/columns select the column to be moved and 

1. Click the move down arrow ( ˅ ) to move the column to the right of the output table;
2. Click the move down arrow ( ˅ ) to move the column to the end of the output table;
3. Click the move up arrow ( ˄ ) to move the column to the left of the output table; or 
4. Click the move up arrow          to move the column to the beginning of the output table
1. As columns are added to the select table tab, a basic filter will automatically be created in the Where Clause tab located in the section below the Column Name and select table tabs. If the basic filter is sufficient, proceed to type ‘where 1=1’ at the end of the query (see step 3 in the preceding figure). If the basic filter is not sufficient, you can specify/add additional filter criteria by using the filters in the Where Clause section.

1. Click the Run Query command button to generate the query. The data retrieved will then display in the Output table located at the bottom of the screen.

Click the Save Query command button to save the query. Once saved, the query will be added to the Saved Queries table located in the top right section of the form where it will be available for selection for future use.

Saved queries can also be deleted by clicking the Delete command button in the Saved Queries table if the query is no longer required for future use.

1. Click the Export to Excel command button to save the query in excel for further review and analysis. 

*Note: Table Names are displayed using the Oracle database name; hence, refer to the legend provided in Query Builder Tables to see which tabs within the application are represented by each table.

Attachments (2)

69a6856279968.qb_reporting_dashboard.png
89.8 KB

69a685627996b.qb_query.png
47.7 KB