Adjusting the Number of Displayed Lines in the View Queries Screen

In the Reports module of Sage X3, there is a View Queries screen that enables users to search predefined data collections on screen. This functionality utilizes a graphical query tool designer, which is responsible for designing queries based on the SQL language.

The graphical query tool designer includes a function to create screens that display the results of queries run on the database. It operates by temporarily extracting data from a table and presenting it on the screen.

In sage recently a concern was raised by one of our client who reported an issue with fetching all lines in the report on the screen level. Despite transactions being visible on the main transaction screen, they were not displaying on the screen report.

Path: All -> Reports -> Reports -> View Queries

New Stuff: Manufacturing Dashboard to get empty location details

Figure 1 View Query screen Figure 2 Incomplete output of query

As shown in Figure 1 and Figure 2, the on-screen report ZPTK001 has a total of 392 lines. However, only 100 lines are visible on the screen.

To solve the above concern we have performed the below mentioned steps.

Step 1: Navigate to Graphical query tool as the query is developed using it.

Path: All ->Setup ->Usage -> Reports -> Graphical query tool

Figure 3 Graphical Query tool screen

On this screen, we have the “Number of Lines” field in the Advanced Tab, which is used to limit the number of records displayed in the output area. By default, this field is blank, which actually limits the output to 100, even if the query results contain more rows. This is done to help reduce the chance of performance issues.

Step 2: To specify the desired value, enter it in the “Number of Lines” field in the Advanced Tab.

Figure 4 Increased the number of lines

Here we’ve change the Number of Lines field to value to 9999(max value that can be used) then validate the screen.

Step 3: To navigate to view queries screen and again verify the output.

Path: All -> Reports -> Reports -> View Queries

Figure 5 Complete output of query

After increasing the number of lines, as depicted in Figure 5, we have successfully addressed the concern. Now, all 392 rows specified by the query are visible on the screen.

Here we increase the number of lines as per requirement similarly, you can decrease the number of lines on the screen. By following these two simple steps, you can effortlessly adjust the number of lines displayed in the grid on screens.