|Powered by QM on a Rpi server|
KnowledgeBase 00035: Panning and Scrolling in the Query Processor
This article was originally published as a Tip of the Week.
The QM query processor includes useful features to pan reports that are wider than the screen and to scroll back through pages of a report.
Developers sometimes have to juggle field display widths to get the columns required in a report to fit the screen. The pan feature of QM's query processor allows a report to be wider than the screen, panning all or part of it to show the columns of interest by use of either the horizontal cursor keys or the letters L and R.
Panning is controlled by use of the PAN keyword in a query sentence. If this keyword appears either before or after all display clause elements, all columns are panned. If the keyword appears part way through the display clause elements, the items before it are fixed, panning only the later data columns.
How often have you paged down through a lengthy report and gone past an item of interest? With the scroll feature of QM's query processor, you can move back up to earlier pages of the report.
Scrolling is enabled by including the SCROLL keyword in the query sentence. When running in scrolling mode, the query processor recognises the cursor up key or the letter P to show the previous page, cursor down or the letter N to show the next page, or a page number followed by the return key to move to a specific page.
Automating Pan and Scroll
If panning or scrolling is required as standard for all reports, the keywords can be included in the $QUERY.DEFAULTS VOC record.