1. Click on the Manage tab and the Add New Query button.

   Manage my queries:

   

    

2. Enter a query name and optional description. Both fields can be changed anytime later.

   Query name and description:

   

    

3. Click the Add button.

   Saved query:

   

    

4. Click the My Queries tab. You will see your queries. Click the Hello Collective2 link.

   The query name link sends a query source code (currently empty) to the code editor. The query name must be visible in the code editor header.

   (A source code lines numbering starts at 100 intentionally.)

   Send a code to the editor:

   

    

5. Say we want to see trades of the system Carma Stocks (ID = 81128026).

   Enter following text to the code editor on the right. Do not forget the semicolon at the end:

   C#

   Copy

   TABLE = from trade in C2TRADES
           where trade.SystemId == 81128026
           select trade;

    

6. Press the Run button.

   You will see some text in the Log window and the result of your query in the Results window.

   Run a query:

   

    

7. Scroll screen down to see the whole table.

   Results table

   

    

   There is about 16 columns in the table.

   Scroll table horizontally to see columns on the right side.

   Results table - right side columns

   

    

8. Click the Results column to sort data in ascending order.

   Click again to sort data descending.

   Click again to remove ordering.

   Play with the Result column

   

    

9. Enter FCX to the entry field in the Symbol column.

   This is a filter. You see just rows where Symbol = FCX.

   Filter by symbol

   

    

Congratulation!

You got your first experiences with C2Explorer data query!