Active Query Builder support area

SQL Query modification

Learn how to create SQL queries from scratch or to edit existing SQL queries with Active Query Builder

Tag
All Unmarked Dashboard Knowledge Base Dashboard Popular Articles Dashboard Quick Start Dashboard Release Notes

How to add the "with (nolock)" hint to all datasources in the query?
- updated 5 years ago
How to specify the stored procedure parameters programmatically?
- updated 7 years ago
How to create a simple query programmatically?
- updated 7 years ago
Generation of INSERT, UPDATE, DELETE statements for a given SELECT statement
- updated 10 months ago
How to change sorting, add filters, limits and aggregations to the query?
- updated 3 years ago
How to check if a query contains specific tables and they are joined correctly?
- updated 8 years ago
How to add or modify TOP, LIMIT, FETCH FIRST clauses or ROWNUM condition programmatically?
- updated 8 years ago
How to join an object that has just been added by the user with existing objects in the query?
- updated 8 years ago
How to take additional actions when the user adds an object to the Design Pane?
- updated 6 years ago
How to add objects and joins to the query programmatically?
- updated 3 years ago

1
2
›