Chapter 2. Query Generator and Query Wizard

In the previous chapter, you learned basic concepts regarding certain terminologies used in this book. You also know that tables and table relationships are important for SQL Query. What are all of these concepts about? You will better understand when you start your own journey to create a SQL Query report.

How do I start? That is a good question. I have learned this the hard way. Even though the tools to create queries are readily available from the SAP Business One menu, I myself had never gone through most of these tools before I planned to write this book to show you how to start. I have kept using only Query Manager and system queries until now. To be honest, I just found out too late that I took such a longer route than necessary. What a pity! If I had started with Query Generator and Query Wizard, it would have saved me a tremendous amount of time.

These tools are quite convenient and efficient for everyone to use, especially for starters to write their first query for SAP Business One. These tools will help you to omit this process of writing every single statement, tables' names, or fields' names, etc.

This chapter will introduce you to two basic SQL Query tools for SAP Business One:

Both tools are for starters to get to know SQL query in SAP Business One quickly. After you have learned these tools, you could get a simple job done just with a few mouse clicks. The introduction gives you detailed steps so that you can have step-by-step advice.

In the next section, the differences between these tools are discussed. You can decide which one is more suitable for you when you read through all their features and benefits.

If you are a more experienced reader, you may find that these tools are no longer necessary. Otherwise, you are strongly encouraged to go through the chapter to refresh yourself.

The last section introduces System Queries built-in to SAP Business One. Those system queries are another good start for readers whose SQL Query level is above average. You could then customize them and create your own queries quickly. For a beginner, you may just learn how to run those queries first to save time.

The previous screenshot shows you how to access these different tools from the SAP Business One menu. You can find all tools for this chapter from it. They are all under the Tools | Queries menu. Query Generator is the second item; Query Wizard is the third item; and System Queries is number five.