AXForum  
Вернуться   AXForum > Microsoft Dynamics NAV > NAV: Blogs
All
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 27.05.2020, 21:14   #1  
Blog bot is offline
Blog bot
Участник
 
23,365 / 790 (73) +++++++
Регистрация: 28.10.2006
waldo: Getting not-out-of-the-box information with the out-of-the-box web client
Источник: https://dynamicsuser.net/nav/b/waldo...box-web-client
==============

A few days ago, Isaw this tweet:
Do you need to see current the database size for a company broken down into table sizes? In #MSDyn365BC 2020 release wave 1, you can do that in the new Table Information page. See more: https://t.co/ShGVYnec2g pic.twitter.com/DGHlr5WlME

— Microsoft Dynamics 365 Business Central (@MSDYN365BC) May 23, 2020
And that reminded meabout a question I had a few weeks ago from my consultants on how to get moreobject-formation from the Web Client. More in detail: in Belgium, we have 2 languages for a tiny country (NLB,FRB) that differ from the language used by developers (ENU). Meaning: consultants speak another languagethan the developers, resulting in misunderstandings.

I actually had avery simple solution for them:

TheFields Table

For developers, awell known table with information about fields. But hey, since we can “run tables” in the web client (andsince this is pretty safe to do since these are not editable (and shouldn’t be– but that’s another discussion :D)), it was pretty easy to show theconsultants an easy way to run tables. It’s verywell described by Microsoft on Microsoft Docs. Just add “table=” inthe URL the right way, and you’re good to go. So for running the “Fields table”, you could be using thisURL: https://businesscentral.dynamics.com/?table=2000000041

And look at thatwealth of information:
  • Data types
  • Field names
  • Field captions depending on the language you’re working in
  • Obsolete information
  • Data Classification information
  • ..
All a consultant could dream of to decently describe change requests and point developers to the right data, tables and fields.

This made me wonderthough:

Andcan we easily even more from the web client?

Not all of theBusiness Central users, customers, consultants, … are developers. So, can we still access this kind ofinformation, without the access to code, VSCode or anything like that?

Yeswe can.

In fact, thestarting point should be: how do I find objects? Is there a list with objects? And therefore also a list with theseso-called system tables?

Well, you’ll need to…

learnhow to find “AllObj”, and you’ll find it all!

AllObj is a system table that houses all objects (including the objects from Extensions), so if you go to this “kind of” url, you’ll find all objects in your system:

https://businesscentral.dynamics.com/?table=2000000038

You’ll see a verysimple list of objects, and you can even see the app (package Id) it belongs to(not if that is important though …):

So – now you knowhow to find all objects and how to run objects. You can run tables, reports, queriesand pages, simply by constructing theright URL (pretty much the same as explained here).

System/Virtualtables

To find thesespecial tables with system information, simply filter the “AllObj”table on “TableData” and scroll down to the system tables numberrange (ID range of 2.000.000.000 and above) and start browsing :-). You’ll see that you don’t always havepermission to read the content .. but if you do, you’d be surprised of the datathat you can get out of the system.

Justa few pointers

Session information https://businesscentral.dynamics.com/?table=2000000009 All Objects https://businesscentral.dynamics.com/?table=2000000038 Fields https://businesscentral.dynamics.com/?table=2000000041 License Permission https://businesscentral.dynamics.com/?table=2000000043 Key https://businesscentral.dynamics.com/?table=2000000063 Record link https://businesscentral.dynamics.com/?table=2000000068 API Webhook Subscription https://businesscentral.dynamics.com/?table=2000000095 API Webhook Notification https://businesscentral.dynamics.com/?table=2000000096 Active Session https://businesscentral.dynamics.com/?table=2000000110 Session Event https://businesscentral.dynamics.com/?table=2000000111 Table Metadata https://businesscentral.dynamics.com/?table=2000000136 Codeunit Metadata https://businesscentral.dynamics.com/?table=2000000137 Page Metadata https://businesscentral.dynamics.com/?table=2000000138 Event Subscription https://businesscentral.dynamics.com/?page=9510 Whatif I get an error?

Well, that happens –like this one:

I don’t know why itdoes that – but do know you can always turn to a developer, that can try toapply the C/AL trick: just create a page in an extension and add all fieldsfrom the table and simply run that page.




Источник: https://dynamicsuser.net/nav/b/waldo...box-web-client
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
dynamicsaxse: November 2018 Release – Dynamics AX2012 R3 update Blog bot DAX Blogs 0 15.11.2018 09:11
waldo: AL Code Analysis Rules (Diagnostic Descriptors) – Updated Again Blog bot NAV: Blogs 0 19.09.2018 04:12
german_nav_developer: Buildnummern-Übersicht Microsoft Dynamics NAV 2013 R2 Blog bot NAV: Blogs 0 15.05.2016 18:12
waldo: Setting up Project “Madeira” Preview (also when you’re not from the US) Blog bot NAV: Blogs 0 15.05.2016 18:12
Platform updates overview - 3.70.B - NAV2009 R2 Blog bot Dynamics CRM: Blogs 0 07.02.2011 22:06
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 23:12.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.