VisualQuery Designer

you are here (click to zoom) - discover the stack

2sxc includes a visual designer for creating queries called VisualQuery. It's drag-and drop, and each component can be configured to your needs.

The Designer

This is what it looks like:

This is what you see when you run a query:

Add Parts / DataSources

Just add parts to your query as you need them:

...and drag them around for positioning as you want:

Connect Parts / DataSources

Now just connect Out Streams of some parts to the In Streams on other parts:

In some cases, the connection to drop unto already has the right name, otherwise just click on the name to rename it:

Tip

Renaming connections can be very important, as the receiver of data may expect a specifically named In Stream to bring it data. The most common name is Default BTW.

You can also rename the Outbound connection if you want this:

Tip

Just like the In-Streams, the Out-Streams names can have an important effect. In the example above, renaming the Out means that the shown App DataSource will only give data of the type Company on this stream.

Save, Run and Debug

Here's an example of the result after running the query shown above:

As you can see, the designer shows each connection and how much data was in it (and you'll see a dialog showing the data). If we click on a stream we can also see exactly what was in the stream: