Report Generator Demo

Try it out! Or maybe read some background info first...

On The Importance Of Data Entity Relations

In the demo dojo you can see how WYSE honors the 'Relational' in 'Relational Databases', both client side and server side. Without that 'relational', tables would just be stand-alone containers of data. Much of the richness of databases comes from the relations between the different entities in it. For that reason a lot of report generators fall short of delivering valuable information: They are stand-alone table/view based. Here WYSE steps up. When you have a set of lists that form a hierarchical relationship tree. You can dynamically query the total picture and extract more information. Here you can see the lists structure that is used in this demo...

  • Customer
    • Home Address (1:1)
    • Billing Address (1:1)
    • Purchases (1:n)
      • Product (1:1) (Please note: This is not a table but a subselect statement that joins a Product table with a ProductPriceHistory table)
      • Delivery Address (1:1)

Dynamic Queries

WYSE offers a simple but bountiful way to supply selection criteria via a text-based expression language that is easily extensible. In function it is reminscent of GraphQL. In the language you can...

PS WYSE regards efficiency highly. Here specifically that means the SQL statement that is generated based on your demo settings is optimized. Depending on what columns you select and the where clause you dynamically build, the 'select' statement will be pruned when possible: Joins that are superfluous are weeded out.