Fork me on GitHub
2sxc 9.43 for DNN 7 to 9
Website Builder, Content Manager, App-System: open-source and fun
You are here: Home  >  Learn  >  Visual Query Designer

Learn to use the Visual Query Designer

This should help you get started. 

Note that the tool is optimized for self-discovery - so I'm just documenting the most important things so you can get started. So first there are some basic videos, but everything else is described below. 

Get to know the Query Designer in 12min

Get to know this ASAP and have fun.

Get to know the Query Designer in 12min

Get to know this ASAP and have fun. 

Learn to use URL parameters in Queries 10min

Learn to use URL parameters in Queries 10min

Finding the Visual Query Designer

Note that this feature is only avalable on 2sxc-Apps. This is by design, because complex development should always happen within an App and not within normal content (that would confuse the user). 

Managing your Visual Queries

This is done in the following dialog - click on the image to learn more about the specifics. 

Some special notes:

  1. The exact query name is important, as you will re-use this in other places in code. So put your descriptive stuff in the description.

Understand the Default Query

The Default query shown when you create a new query shows you what would happen if you didn't specify a query - the data-pipeline would do the following

  1. Retrieve the in-memory cache (at the bottom)
  2. Pass data to the publication-filter to ensure that non-editors see unpublished content, while editors should see published content
  3. Then go through the ModuleDataSource which retrieves all items which had been added to a specific module
  4. From there go to the 2sxc View/Template

You can now change it, remove things etc. as you want to. 

Connecting DataSources

Do this with drag-and drop - and read the notes in the image.

Editing DataSource Components

See instructions in the image

Adding more Parts

See Image

Testing your Query

Always remember to add test-parameters (if your Query has parameters). 

Then test. 

Assign a query to a Razor/Token Template

When your query is ready to use and you want to assign it to a template, go to the template settings and configure it as shown in the screenshot.