DNN Community Blog

The Community Blog is a personal opinion of community members and by no means the official standpoint of DNN Corp or DNN Platform. This is a place to express personal thoughts about DNNPlatform, the community and its ecosystem. Do you have useful information that you would like to share with the DNN Community in a featured article or blog? If so, please contact .

The use of the Community Blog is covered by our Community Blog Guidelines - please read before commenting or posting.


Visual Query 2.0 is SQL & LINQ for JavaScript & Razor (2sxc 9.8)

Visual Query v2 comes with many enhancement which will make both JavaScript and Razor / MVC development much easier in DNN.

Introduction to Visual Query

Just a brief introduction if you haven't used Visual Query. We all develop web apps which show data - be it a C#/Razor based list of blog-items or a JavaScript based product catalog. All these things have in common, that there is data which must be selected, sorted, filtered, etc. before we show it. Visual Query is a drag-drop based query system which lets you create queries like this:

The above example shows the initial (#1) App data source which has all the data of this app. The Company stream coming out of it provides all items of the type Company and passes it on to #2 Paging data-source, which is in this example will only provide 3 items at a time (the Default out). It also creates a new item called Paging which contains information like the current page number, the total items and the total page count. All this is the passed on to #3 2sxc Target which can be either a C#-Razor view or a JavaScript view (Angular, React, etc.) which can now work with this data. 

Productivity Highlights of 2.0

The first two things you'll notice are the many colors and the smaller blocks. But that's really just first impressions - Visual Query 2 is all about productivity. Here's what's new:

  1. Color streams help see what's connected to what
  2. Icons in each data-source help quickly determine what this source does, even after you renamed it
  3. All data sources now have extensive help in the 2sic wiki, like the help for the App data source
  4. Smaller data-source parts help you see more of your query in one screen
  5. Only configurable components now show configure-buttons on hover...
  6. ...and only components with a dynamic Out provide the orange new stream buttons
  7. Sources with Fallbacks (like filters which should be ignored if they don't return anything) now show the Fallback in-stream

Testing Highlights of 2.0

One of the most important enhancements is showing the test-parameters which are used when you are developing a query.  Here's an example:

This shows how the query will behave when there is not Tag in the URL but there is an Author. The magenta/green pointers show how this affects the data returned from these filters. Having these values on the same screen as you're creating a query is very helpful. 

New Data Sources: Sql and Shuffle

Last but not least we created two new data sources:

  1. the SqlDataSource allows you to query any SQL database. I'll write an extensive blog about it in a few hours.
  2. the ShuffleDataSource let's you randomly pick a few items from a large list of items - this is common for cases where you need 3 random quotes or something

Hope you love it :)

...and do try it - the latest 2sxc can be found on github

Love from Switzerland, 
Daniel


Daniel Mettler grew up in the jungles of Indonesia and is founder and CEO of 2sic internet solutions in Switzerland and Liechtenstein, an 20-head web specialist with over 800 DNN projects since 1999. He is also chief architect of 2sxc (see github), an open source module for creating attractive content and DNN Apps.



Read more posts by Daniel Mettler

Comments

There are currently no comments, be the first to post one.

Comment Form

Only registered users may post comments.

NewsArchives


Aderson Oliveira (15)
Alec Whittington (11)
Alex Shirley (10)
Andrew Nurse (30)
Andy Tryba (1)
Anthony Glenwright (5)
Antonio Chagoury (28)
Ash Prasad (32)
Ben Schmidt (1)
Benjamin Hermann (25)
Benoit Sarton (9)
Beth Firebaugh (12)
Bill Walker (36)
Bob Kruger (5)
Brian Dukes (2)
Brice Snow (1)
Bruce Chapman (20)
Bryan Andrews (1)
cathal connolly (55)
Charles Nurse (163)
Chris Hammond (209)
Chris Paterra (55)
Clinton Patterson (36)
Cuong Dang (21)
Daniel Bartholomew (2)
Daniel Mettler (151)
Dave Buckner (2)
David Poindexter (4)
David Rodriguez (3)
Doug Howell (11)
Erik van Ballegoij (30)
Ernst Peter Tamminga (74)
Geoff Barlow (10)
George Alatrash (6)
Gifford Watkins (3)
Gilles Le Pigocher (3)
Ian Robinson (7)
Israel Martinez (17)
Jan Blomquist (2)
Jan Jonas (3)
Jaspreet Bhatia (1)
Jenni Merrifield (6)
Joe Brinkman (274)
John Mitchell (1)
Jon Henning (14)
Jonathan Sheely (4)
Jordan Coopersmith (1)
Joseph Craig (2)
Kan Ma (1)
Keivan Beigi (3)
Ken Grierson (10)
Kevin Schreiner (6)
Leigh Pointer (31)
Lorraine Young (60)
Malik Khan (1)
Matthias Schlomann (15)
Mauricio Márquez (5)
Michael Doxsey (7)
Michael Tobisch (3)
Michael Washington (202)
Miguel Gatmaytan (3)
Mike Horton (19)
Mitchel Sellers (28)
Nathan Rover (3)
Navin V Nagiah (14)
Néstor Sánchez (31)
Nik Kalyani (14)
Peter Donker (53)
Philip Beadle (135)
Philipp Becker (4)
Richard Dumas (22)
Robert J Collins (5)
Roger Selwyn (8)
Ruben Lopez (1)
Ryan Martinez (1)
Salar Golestanian (4)
Sanjay Mehrotra (9)
Scott McCulloch (1)
Scott S (11)
Scott Wilkinson (3)
Scott Willhite (97)
Sebastian Leupold (80)
Shaun Walker (237)
Shawn Mehaffie (17)
Stefan Cullmann (12)
Stefan Kamphuis (12)
Steve Fabian (31)
Timo Breumelhof (24)
Tony Henrich (3)
Torsten Weggen (2)
Vicenç Masanas (27)
Vincent Nguyen (3)
Vitaly Kozadayev (6)
Will Morgenweck (40)
Will Strohl (165)
William Severance (5)

Content Layout

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out