Share
ReportHi,
How can i get all the output menu items name in ax2012 ? Is there any specific table which holds the menu item name and Ssrs report Id? Any idea
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hi,
How can i get all the output menu items name in ax2012 ? Is there any specific table which holds the menu item name and Ssrs report Id? Any idea
*This post is locked for comments
Hi Zohan,
I don't know your exact requirement. You can also find all output menu items in the System table (view on the model database) called ModelElement. Then filter the record type field to show only OutputTool. This will only give a menu item output name, but not the SSRS report itself. To get that, you need to use Dictionary classes to read properties.
You can use the TreeNode class like shown in the blog. Why is it not ok for you?
The below example is done by examining the blog post:
All responses (
Answers (
static void listOutputMenuItems(Args _args)
{
#Properties
#AOT
TreeNode listNode, itemNode;
TreeNodeIterator itemNodeIt;
listNode = TreeNode::findNode(#MenuItemsOutputPath);
itemNodeIt = listNode.AOTiterator();
itemNode = itemNodeIt.next();
while (itemNode)
{
info(itemNode.AOTgetProperty(#PropertyName));
itemNode.treeNodeRelease();
itemNode = itemNodeIt.next();
}
}
Like I said, you can use the information provided in the blog to achieve your goal. You need to:
1) Iterate all Output menu items
2) For each of them, check if it has Object type: SSRS Report or Object type: Class AND Object: "*Controller"
3) If yes, write the menu item name to infolog
At least that should get you quite close.
This blog should provide the information that you need: ronnyfch.wordpress.com/.../how-to-get-list-of-all-menu-items-at-ax-and-the-license-on-it
The blog shows how to list all menu items that require some user license, but you should be able to use that information to fulfill your requirement. The important thing is that it shows you how to iterate through menu items, and how to inspect properties of the menu items in code.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156