How to build simple and advanced queries in 1point
How to build simple and advanced queries in 1point
In this video, we demonstrate how to build both simple and advanced queries in 1point's query manager. Learn how to select tables and columns, apply your own column aliases, add conditions with AND/OR logic, join across multiple tables, create reusable parameters for values that change, and switch to the SQL editor or the AI Query Assistant to generate a query in plain English. This guide helps teams pull exactly the data they need, however complex the query, without relying on someone else to write the SQL for them.
In this video, we demonstrate how to build both simple and advanced queries in 1point's query manager. Learn how to select tables and columns, apply your own column aliases, add conditions with AND/OR logic, join across multiple tables, create reusable parameters for values that change, and switch to the SQL editor or the AI Query Assistant to generate a query in plain English. This guide helps teams pull exactly the data they need, however complex the query, without relying on someone else to write the SQL for them.
