web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Creating page and deploying it to nav client using query

(0) ShareShare
ReportReport
Posted on by

Hi all,

How do I create a page table and add the query in? Then, how do I deploy it to the Nav client?

Pls help.

Thank you.

*This post is locked for comments

I have the same question (0)
  • Stefano Demiliani Profile Picture
    37,172 Most Valuable Professional on at

    Create your query, then create a table with the fieds of your query and a list page based on this table. On this list page, create a global variable that points to your query object. On this page, set SourceTableTemporary to Yes.

    Then, in OnOpenPage, open the query and load the data into the temporary table:

    YourQuery.OPEN;

    WHILE YourQuery.READ then

    begin

     //assign the fields from the query to the table

     INSERT;

    end;

    FINDFIRST; //returns to the first record.

    The table you create acts only as a buffer, this is not counted on customer's license (it's temporary).

  • Suggested answer
    CDsilva Profile Picture
    4,188 on at

    Hi ,

    Are you trying to create a Role center ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans