1. Embeddable Query Builder

The underlying Knex query builder defines the methods: count, countDistinct, avg, avgDistinct, sum, sumDistinct, min, and max. To avoid confusion and naming collisions, Query Builder prefixes its aggregate helper methods with get (e.g. The query builder component uses the scoped slots technique and lets developers implement their own render logic. This way it gives maximum flexibility for building a custom-tailored UI with minimal API. Below you can see the demo of the query builder component with Vuetify. Query Objects - on the right side of the Query Builder window. This area displays all the data source objects for the current connection. From here objects may be dragged onto the main query building area. The Query Builder tool, enables you to query the full CMS database and return meaningful results, d-encrypting its contents. There is no limit to the scope of the queries, you can query all the content, including content not normally accessible through the CMC or BI LaunchPad.

Accessing Query Builder

Query Builder can be found at the below URL http://MyServer:Port/AdminTools

Make sure you are using a user credentials that is part of Administrator user group in order to gain access to all the repository objects. Please note using Query Builder we can only query the information stored in the CMS database not from the File repository files.

Simple queries to use against the repository

To list all the Users

SELECT * FROM CI_SYSTEMOBJECTS WHERE SI_KIND=’USER’

To list all the Universes

SELECT * FROM CI_APPOBJECTS WHERE SI_KIND=’UNIVERSE’

To list all the WebI reports

SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND=’WEBI’

Query Builder Blog series

Basics

Sample Queries

BusinessObjects Query builder – Exploring Lumira & Design studio Objects

Use cases

Easy Query Builder (EQB) - is a free program which allows you to create SQL queries to your database in a user-friendly way. You don’t need to know SQL or any other complex query language - all your requests can be described visually, very easily, and in (almost) natural language.

Suppose you are not SQL-guru but need to deal with databases - find some information, filter table(s) by parameters or to build an SQL statement for some other purpose. In this case Easy Query Builder utility is your assistant.

It supports the majority of different database types such as MS SQL Server, MySQL, Oracle and MS Access among others. Results can be exported to Excel spreadsheets for easier viewing and sharing.

Query builder for non-experienced users

It takes just a few clicks to add conditions and build the query. No complex SQL constructs to deal with - just a visual interface that looks like a human language sentence.

You don't need to understand database design or table relationships. Easy Query Builder performs all the 'dirty' work behind the scenes.

Learn SQL with Easy Query Builder

EQB is useful if you are learning SQL. Just build the queries you can imagine and see what they look like in SQL.

Moreover, the changes in the query being built are instantly reflected in the SQL box, so you can track any minor changes. This will allow you to get a more deep understanding of the way things work.

It allows you to build SQL queries to any database without need to deal with SQL syntax. It takes just a few clicks to add conditions and build the query. Using our user-friendly interface even quite complex SQL queries can be built in virtually human language.

Finding the necessary information from your database files requires the use of a powerful SQL query builder. Such a tool will allow you, for example, to quickly get important information such as the details on your most valuable customers. You can use a query builder to get the important information that you need quickly. To do this, you need to have the ability to build SQL queries to your database. Easy Query Builder is one of the better value and more user-friendly tools for doing exactly that. It provides you with the ultimate tool for extracting the necessary data from your database in minimal time with maximum reliability.

To extract data from a database, there are various options, but none of them are nearly as effective or as easy as having a dedicated SQL query builder like Easy Query Builder. Other options include spending countless hours learning the SQL language in order to make a new query. Doing it manually in this way not only takes time, but you will also need all of the specialist knowledge at your disposal which does not come cheaply if you need to hire extra staff to do the job. There are also other SQL query builder solutions which provide a basic GUI or command-line interface, but many of these are still extremely hard to use and/or do not provide the range of features that your company requires.

Having a full understanding of SQL code and syntax is hardly practical if you don’t already and to build SQL statements yourself, you will need to have an extensive knowledge in this area so that you can type in commands, table and field names and more. You will need to know exactly how your data is stored in the database. While a basic SQL query builder will provide users with an easier solution, it is also not ideal, since, in many cases, you will still need to have a degree of expertise in the inner workings of the database. The best way to do this is surely to use an SQL query builder which allows you to build queries in your own, natural language, rather than learning complex SQL routines.

Easy Query Builder is an SQL query builder designed to do exactly that. It makes the handling of otherwise extremely complex and technical queries much easier to handle. For example, you can select understandable attributes such as “Order Date” or “Customer Name.” Such operations can be easily carried out with just a few clicks of the mouse. The user interface is simple, but it still provides the highest degree of functionality that you expect from a powerful and versatile solution.

Easy Query Builder supports the majority of different database types such as MS SQL Server, MySQL, Oracle and MS Access amongst others. Results can also be exported to Excel spreadsheets for easier viewing and sharing.

Embeddable Query Builder

The very best thing of all about Easy Query Builder is that it is freeware – it costs absolutely nothing at all!