Queries

1. To open Genius Queries select the Functions and Queries button in the toolbar.

2. In the right side of the Excel document you will see a list of all Genius Services, Functions and Queries in the system. Select Tree View or Search View to find the right query.

    Queries are marked with  in front of them but functions have  in front of them.

3. In the Search View you can order functions and queries by name or service by clicking on Name or Service. You can also search for a function or a query by name.

4. Select a query and select Add or double-click on a query name to open the parameter window. You can also right-click on a query name in tree view and select Add to worksheet

    to open the parameter window. Finally, you can click on a query name and drag it to the cell you want it to appear in to open the parameter window.

5. Change Starting Cell if wanted and insert value, or cell including the value, in the parameter fields. Behind the parameter fields you will see how to insert the parameters, e.g.

    insert date in the format "dd.mm.yyyy" og "dd.mm.yy".

6. Choose which fields will be shown in the query result. In the right window are the fields which will not be shown but in the left window are the fields which will be shown. Move the

    fields between these windows with the arrow buttons. You can change the order of fields with the up and down arrows.

7. Choose by which fields the query result will be sorted. If the Descending checkbox is checked then the sorting will be descending else it will be ascending. If nothing is sorted it

    depends on the query how the results are sorted. It is possible to sort by a field which is not included in the result.

8. Select various Settings, such as "Show Header" or "Adjust Column Width", by checking the appropriate boxes.

9. Click OK to get the query result.

10. To edit a query right-click somewhere in the query result and select Edit Genius Query.

11. To delete a query you can select all values in the query and press Delete on the keyboard or right-click and select delete. You can also right-click somewhere in the query result and

      select Edit Genius Query. Then select the Delete button in the parameter window.

12. To get help on a query click on the query name and select Help below the list of functions and queries. Help on the query will open in a new window.