Brief example.
Create a new table to hold your query.
Create a new page to show your query. Source to be the created table but as temporary.
You’ll then need a function to fill the page/run your query and add the results.
Kind of like this
page 50000 "Query in a page”
{
PageType = List;
ApplicationArea = All;
UsageCategory = Administration;
SourceTable = "Query Table";
SourceTableTemporary = true;
Editable = false;
DeleteAllowed = false;
InsertAllowed = false;
layout
{
area(Content)
{
repeater(Control1)
{
field("Query field 1 Code"; "Query Field 1 Code")
Procedure SetPageData()
Var
Myquery: query MyQuery
Begin
while MyQuery.Read() do begin
NextRowNo := NextRowNo + 1;
"Entry No." := NextRowNo;
"Query Field 1 Code" := Myquery.Journal_Template_Name;
Insert();
End;
