How to get list of available pages in NAV

(0) Share

Report

Posted on by Community Member Microsoft Employee

I need to get list of names of all available pages and corresponding table numbers to these pages. How can be done this in c/al? What system tables can be used for this purpose?

NAV 2013 R2, 2015, 2016.

*This post is locked for comments

All responses (9)

Answers (4)

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to get list of available pages in NAV

oh, i didn't see the 'Metadata' field type, it's BLOB, so obviously. I simply thought that we can retrieve one xml file with all pages metadata. Now it's clear..
Verified answer

Suresh Kulla 43,745 on at

Like (1)

Report

RE: How to get list of available pages in NAV

use the below code to extract metadata into an xml file and in the xml file you have the property nodes

This is just an example for Page 42

.

ObjectMetaData.SETRANGE("Object Type",ObjectMetaData."Object Type"::Page);
ObjectMetaData.SETRANGE("Object ID",42);
IF ObjectMetaData.FINDFIRST THEN BEGIN
ObjectMetaData.CALCFIELDS(Metadata);
IF ObjectMetaData.Metadata.HASVALUE THEN BEGIN
ObjectMetaData.Metadata.CREATEINSTREAM(Data);
IF ISNULL(XMLDoc) THEN
XMLDoc := XMLDoc.XmlDocument;
XMLDoc.Load(Data);
XMLDoc.Save('C:\Temp\ObjectMetaDataxml.xml');
END;
END;
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to get list of available pages in NAV

Hi everyone,

At current moment i have made new custom xmlPort based on idea of aavio and setup new web service for my development goals in NAV 2016.

In previous versions of NAV this virtual table is absent. I understand the idea of Yukon to use "Object Metadata" table and export data from it in xml file. But i don't know how to retrieve data with such structure as shown by Yukon. I can see only these columns

Thanks for the help
Binesh 7,885 on at

Like (2)

Report

RE: How to get list of available pages in NAV

Follow these procedures
Open Object Designer And Select Page Object And then Click New. See the Screenshot

Now Compile, Save And Run your page.....

Here is the result

Please verify the answer if it satisfy your requirement. Doing so you'll help the community to identify the valid answers.
Verified answer

aavio 895 on at

Like (2)

Report

RE: How to get list of available pages in NAV

its a virtual table, still you can create record variable referring to table 2000000138

please check this link also msdn.microsoft.com/.../hh167225(v=nav.90).aspx
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to get list of available pages in NAV

Hi aavio,

I have NAV 2016 version 9.00.42815 and can't find table with such id. What version do you mean? Are any upgrades required?
Verified answer

aavio 895 on at

Like (2)

Report

RE: How to get list of available pages in NAV

In 2016 there is new system table 2000000138 - Page Metadata

you can refer this table to get the source table and SourceTableView
Verified answer

Yukon 714 on at

Like (2)

Report

RE: How to get list of available pages in NAV

Hi Vladimir,

Jens already mention there is no API and toolkit for at this moment.

I understanding Nav object is store on "Object Metadata" Table (Ver 6.0 and above). If you really want to get it you can try this way. Export the data from "Object Metadata" table and save as XML and then find the node as per your requirement.

Here is export xml from "Object Metadata".

Regards,

Yukon
Jens Glathe 6,092 on at

Like (0)

Report

RE: How to get list of available pages in NAV

Hi Vladimir,

I'm afraid this is not possible from C/AL. You would need to query the SourceTableView property of the page objects, and I know of no API to do this. Interesting history: in the old NAVISION (text based), the program had a means to do just this. There was no fixed link (like LookupFormID, DrillDownFormID) in these tables, So, the NAVISION client presented a list of all suitable forms that had the right SourceTableView for the lookup.

with best regards

Jens