Small and medium business | Business Central, N...

List Page linked to Query doesn't pull data

(0) Share

Report

Posted on by Anita75

1,165

Hi All,

I've created a list page based on a query object. When I run the query on its own data is displayed, however when the query is published to a page, the page is opened just with column headings. Sample code below:

page 50100 myPage

{

PageType = List;

Caption = 'Page';

ApplicationArea = All;

UsageCategory = ReportsAndAnalysis;

SourceTable = "Purchase Header";

SourceTableTemporary = true;

Editable = false;

DeleteAllowed = false;

InsertAllowed = false;

layout

{

area(Content)

{

repeater(Group)

{

field(No; "No.") { ApplicationArea = all; Caption = 'Order No.'; }

}

Procedure SetPageData()

Var

Myquery: query PODetail;

Begin

while MyQuery.Read() do begin

//Init();

"No." := Myquery.No;

Insert();

end;

End;

}

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Bilal Haider 414 on at

Like (0)

Report

Hi,

There can be two possibilities.

Possibility 1: You have not created a table that is required to hold the query result values. The table in the code is standard so you need to create a new table to hold your query result. Add that table as source table in the above page. Note: This table can be temporary.

Possibility 2: May be there is issue in query. Have you checked that query is working correct? Run it separately and see if it showing some data.

If it is none of above then share your query code as well. And if it helps you then please verify this.

Regards,

Bilal

Was this reply helpful? Yes No
Suggested answer

THE Italian on at

Like (0)

Report

I think you haven-t open the query object. This is needed to run the query.

see

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-query-overview

Was this reply helpful? Yes No
Anita75 1,165 on at

Like (0)

Report

Thanks and changed the code but still no luck, this in version 16 not 17 so I dont have the new table type property. Maybe there is a better way or somone go an example :

Procedure SetPageData()

Var

Myquery: query PODetail;

Begin

Myquery.Open();

while MyQuery.Read() do begin

"No." := Myquery.No;

Status := Myquery.Status;

Insert();

end;

End;

Was this reply helpful? Yes No
Anita75 1,165 on at

Like (0)

Report

Thanx checked query results and works fine ...

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 414 on at

Like (0)

Report

Okay and have you tried to put the results of query to a table first and use that table as Source Table. Like in the code you are using "Purchase Header", replace it with that new table where you are putting this query results.

Was this reply helpful? Yes No
Anita75 1,165 on at

Like (0)

Report

Ok I did create a new table as below:

table 60101 OpenPOTest

{

    DataClassification = ToBeClassified;

    fields

    {

        field(10; No; Code[20])

        {

            DataClassification = ToBeClassified;

        }

    }

    keys

    {

        key(PK; No)

        {

            Clustered = true;

        }

    }

}

and then on the page changed the trigger:

trigger OnOpenPage()

var

OpenPO: Query OpenPOTEST;

begin

if OpenPO.Open() then begin

while OpenPO.Read() do begin

Rec.Init();

Rec.No := OpenPO.No;

Rec.Insert();

end;

OpenPO.Close();

end;

end;

This works except I have an extra table just to create a page out of a query. There should be a better way to do this wthout having to create a new physical table as in version 16 TableType = Temporary is not available.

Primary problem I'm trying to solve is combine data from multiple tables into one page and if someone can share a better solution it would be great

Was this reply helpful? Yes No